INSERT INTO STORE_INFO_TABLE(GOOD_ID,MAIN_ID,MINOR_ID,GOOS_COUNT,UNIT,USER_ID,INDATE)
VALUES('GS00001','MA00001','MI00001','5','G','1','2012-01-14')
ON DUPLICATE KEY UPDATE
GOOS_COUNT=GOOS_COUNT+'5'
mysql INSERT INTO ON DUPLICATE KEY UPDATE
最新推荐文章于 2024-07-27 17:38:38 发布