|
出现错误的语句
INSERT INTO pw_Organization(OrganizationNumber,OrganizationName,ClientName,DedicatedLimit,UsedLimit,ReleaseLimit,LimitExpireDate,ExpireOperatorID,HandleTime)
VALUES(1,2,3,4,5,6,2019-07-17,2,2019-07-17)
解决方法：日期类型加单引号
INSERT INTO pw_Organization(OrganizationNumber,OrganizationName,ClientName,DedicatedLimit,UsedLimit,ReleaseLimit,LimitExpireDate,ExpireOperatorID,HandleTime)
VALUES(1,2,3,4,5,6,'2019-07-17',2,'2019-07-17')
(1 行受影响)
| 
转播
