1.Insert

INSERT INTO `mes`.`prc_operation_history`(`factory_name`,`name`,`timekey`,`create_time`,`create_user`,`last_event_time`,`last_event_user`,`type`)VALUES('Module','73000','2017/10/19/12/35','2017/10/19/12/35','admin','2017/10/19/12/35','admin','R');

 

 

 2.UpDate

update job_lot_history set last_event_name='trackin' where true=true; update rtm_machine_history set machine_state_name='idel' where timekey='2017/10/20/13/12';

 3.Select

select * from job_lot_history;

 4.Create

create temporary table `job_product_history_temp` like `job_product_history`;

 5.Truncate

truncate job_product_history_temp;

 6.Drop

drop table job_product_history_temp;

 7.复制表以及表中内容

create temporary table `job_lot_history_temp` like `job_lot_history`;insert into job_lot_history_temp (select * from job_lot_history);update job_lot_history_temp set last_event_name = 'trackout' where true = true;update job_lot_history_temp set timekey = date_add(timekey,interval  12 hour) where true = true;insert into job_lot_history (select * from job_lot_history_temp);select * from job_lot_history_temp