update qcust set UID='7EA04_20123';
update qfact set UID='7EA04_20123';
update qc_country set UID='7EA04_20123';
update qc_color set UID='7EA04_20123';
update qc_type set UID='7EA04_20123';
update qc_size set UID='7EA04_20123';
update qc_defpri set UID='7EA04_20123';
update qc_quality set UID='7EA04_20123';
update qc_wash set UID='7EA04_20123';
update qc_macc set UID='7EA04_20123';
update qdept set UID='7EA04_20123';
update qdetail set UID='7EA04_20123';
update qemp set UID='7EA04_20123';
update qhead set UID='7EA04_20123';
update qitems set UID='7EA04_20123';
update qmacc set UID='7EA04_20123';
update qmtrm set UID='7EA04_20123';
update qmtrs set UID='7EA04_20123';
update update_yn set UID='7EA04_20123';
update qpandn set UID='7EA04_20123';
DELETE FROM qcust WHERE CUSTNO = 'root001' AND CUSTNAME = 'webRoot' AND MOBIL = '0987654321';
INSERT INTO `qcust` (`UID`,`XID`,`TR`,`CUSTNO`,`CUSTNAME`,`MOBIL`,`EMAIL`,`MSN`,`GMAIL`,`GPSLA`,`GPSLO`,`DEPTNO`,`EMPID`,`DISCOUNT`,`ADDRESS`,`PS`,`BANKNO`,
`BANKNAME`,`COUNTRY`,`TRADETYPE`,`STATE`,`PIC`,`CREATEDATE`,`CREATETIME`,`BIRTHDAY`,`C1`,`C2`,`C3`,`M1`,`M2`,`M3`,`S1`,`S2`,`S3`)
VALUES ('7EA04_20123','123456789','30','root001','webRoot','0987654321','root001@gmail.com','0987654321','', '0', '0' , 'AA','A11','100', '', '', '1', 'AA0', '1', '4', NULL , NULL , '2014-01-01', '140101000000', '1010', '1' , '5', '0', '1' , '0' , '0' , '1' , '0' , '0');