004 多筆資料插入

Post date: 2014/10/9 上午 01:20:57

INSERT INTO `test`(

`prefixid`, `uid`, `qpiid`, `point`, `status`, `note`, `seq`, `switch`, `insertt`, `modifyt`

) VALUES (

'sbd','1112','1','300','N','d','1','Y','2014-10-08 00:00:00.000000','2014-10-09 09:10:10.000000'

),(

'sbd','1112','1','300','N','d','1','Y','2014-10-08 00:00:00.000000','2014-10-09 09:10:10.000000'

)