Mysql数据库操作

1、insert into mc_message_his_0205 select * from mc_message_his_0201 where infoid='3392'; 复制一张表中的数据到另外一张表中

2、update dmpush_message_info set sys_flag=0 where requestid='1354778645234690'; 更新表中字段

3、delete from mc_file_num where requestid='93058029135';   删除表中某条记录

4、drop table XXXXX ; 删除表