我收到一个错误消息17:28:46 [SEVERE] com.MysqL.jdbc.exceptions.jdbc4.MysqLSyntaxErrorException: You have an error in your sql Syntax; check the manual that corresponds to your MyS QL server version for the right Syntax to use near ' Now(), DATE_ADD( Now(), INT ERVAL 1 MONTH )' at line 1
’‘.sanchixx
INSERT INTO vips( memberId, gotten, expires )
SELECT name, Now(), DATE_ADD( Now(), INTERVAL 1 MONTH )
FROM members WHERE id = ?
您可以按照以下更正的方式尝试插入语句:
INSERT INTO vips( memberId, gotten, expires )
SELECT name FROM members
WHERE id = ?, Now(), DATE_ADD( Now(), INTERVAL 1 MONTH )
参考: