mysql增删改查语句
日期范围查询:SELECT * from reel_barcode_luoduo where Date(exec_date) between '{start_time:yyyy-MM-dd}' and '{end_time:yyyy-MM-dd}' order by exec_date asc; //按日期排序
SELECT * FROM zjm.output where mc='3FT02H12' and Date(datetime) between '2021-11-1' and '2021-11-3' order by datetime asc;
SELECT mc, shift_class, mn, num_name, output, remark, `datetime`, lasttime, package, rework FROM zjm.`output`where `datetime` like'2021-11-04%' ;
insert into txw_oqa_db.reel_barcode_luoduo set dte=111,sn_reel=111,exec_date="2021-10-21"; delete from txw_oqa_db.reel_barcode_luoduo where id=4; update txw_oqa_db.reel_barcode_luoduo set exec_date="2021-10-21" where id=3; SELECT * FROM txw_oqa_db.reel_barcode_luoduo;