Error: INSERT INTO 语句的语法错误。
A complete tool for creating and managing MSAccess databases.
Brought to you by:
marcieldeg
Application version: 2.5.9.813
Steps to reproduce: Running this SQL:
INSERT INTO User(id, username, password)
VALUES ('0001','zhangsan','123456');
INSERT INTO User(id, username, password)
VALUES ('0002','lisi','12345');
INSERT INTO User(id, username, password)
VALUES ('0003','wangwu','1234');
Expected results:
Actual results: EOleException: INSERT INTO 语句的语法错误。
Additional Information: Windows 10 Home China / ACE driver not found
Anonymous
Hi, thanks for reporting.
The terms “user” and “password” are reserved words in SQL. To use them as column names, you need to add square brackets to them. See the example below:
It is not recommended to use reserved words as database element identifiers. Try choosing different names for the tables and columns to avoid this type of problem.