mysql 复制表数据到原表

来源:互联网 发布:晋城广电网络 编辑:程序博客网 时间:2024/04/29 02:59
INSERT into t_product (product_name,type_id,type_little_id,price,price_old,abstract_title,imagePath,imagePath2,imagePath3,imagePath4,inventory,content,rating,ratingNum,sellNum,state,create_date,unit)  SELECT product_name,type_id,type_little_id,price,price_old,abstract_title,imagePath,imagePath2,imagePath3,imagePath4,inventory,content,rating,ratingNum,sellNum,state,create_date,unit  FROM t_product

0 0