huisededaodao的博客

复制数据 并改变其中一列的值 insert INTO company_setting(company_id,cate_id,setting_id,status,add_time) SELECT 8 as company_id,cate_id,setting_id,status,add_time FROM company_setting where id BETWEEN 419 AND 424 查询表中重复的数据 select * from setting where (`name`,`desc`,..