SQL 语句可以直接实现。 insert into tb_service_project (lcatalog_id,scatalog_id,tiaoma,project_name,image_path,price,service_explain,recommend,deleted) select lcatalog_id,scatalog_id,tiaoma,product_name as project_name,image_path,price,summary as service_explain,recommend,deleted from product where tiaoma = 'xxxxxxxxxxxxxxx';类型对应就行。。
楼主【zhaoweichunmei】截止到2008-07-15 15:08:51的历史汇总数据(不包括此帖):
发帖的总数量:2 发帖的总分数:30 每贴平均分数:15
回帖的总数量:1 得分贴总数量:0 回帖的得分率:0%
结贴的总数量:0 结贴的总分数:0
无满意结贴数:0 无满意结贴分:0
未结的帖子数:2 未结的总分数:30
结贴的百分比:0.00 % 结分的百分比:0.00 %
无满意结贴率:---------------------无满意结分率:---------------------
如何结贴请参考这里:http://topic.csdn.net/u/20080501/09/ef7ba1b3-6466-49f6-9d92-36fe6d471dd1.html
insert into tb_service_project (lcatalog_id,scatalog_id,tiaoma,project_name,image_path,price,service_explain,recommend,deleted)
select lcatalog_id,scatalog_id,tiaoma,product_name as project_name,image_path,price,summary as service_explain,recommend,deleted
from product where tiaoma = 'xxxxxxxxxxxxxxx';类型对应就行。。