mysql的字段拆分问题

Question

我的conten表的字段如下：
                                       contentid                        keywords
                                            1                              炼钢 原料 钢种
                                            2                              标准 轴承钢现在插入表content_tag中，效果如下：
                                                     tag                contentid
                                                      炼钢                   1  
                                                      原料                   1  
                                                      钢种                   1 
                                                      标准                   2 
                                                      轴承钢                2
我的数据量有上万条，逐一修改肯定不行，如何批量处理？请高手指点！！

Answer 1

这不是行转列问题！“炼钢 原料 钢种”属于“keywords”字段的内容

Answer 2

只能用程序或存储过程来解决
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

Answer 3

存储过程实现分词
http://hi.baidu.com/jeakccc/blog/item/c54696cede8f6c34f8dc61ab.html

Answer 4

感谢jeakgreat的无私指点！！我先去弄懂这些知识点。