MySQL插入语句语法错误与SET

Question

INSERT INTO salon_client_prepaidCard SET (\'010818-demo-1\', 4, 5, 1, 6000) 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'(\'010818-demo-1\', 4, 5, 1, 6000)\' at line 1', sqlState: '42000', index: 0, sql:

该表有一个自增的id字段。这里看起来有什么问题？

Answer 1

mysql 插入的正确语法是;-

INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...); 

或使用集合；-

INSERT INTO table_name
   SET column1 = 'value1',
       column2 = 'value2',
       column3 = 'value3';

如果要为表的所有列添加值，则不需要在 SQL 查询中指定列名；-

INSERT INTO table_name
VALUES (value1, value2, value3, ...);