mysql - 无法将行插入表(列数不匹配)

Question

我有一个脚本可以创建一个表，然后插入一行。这是我执行创建表的 SQL 代码:

CREATE TABLE polls ( 
    id INT NOT NULL UNIQUE AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL UNIQUE,
    author VARCHAR(255) NOT NULL,
    created DATETIME NOT NULL,
    expires DATETIME,
    PRIMARY KEY(id)
)

这是我添加新行的地方:

INSERT INTO polls
VALUES ('TestPoll'),('Billy Bob'),('2013-05-01 04:17:31'),('2013-05-01 04:17:31')

或

INSERT INTO polls
VALUES ('TestPoll','Billy Bob','2013-05-01 04:17:31','2013-05-01 04:17:31')

(无论如何我都会得到同样的错误)

我总是得到这个错误:

<class '_mysql_exceptions.OperationalError'>, OperationalError(1136, "Column count doesn't match value count at row 1"), <traceback object at 0x7f7bed982560>

Answer 1

你的语法有误，试试:

INSERT INTO polls
VALUES ('TestPoll','Billy Bob','2013-05-01 04:17:31','2013-05-01 04:17:31')

但是如果你的表结构改变了，你的代码就会崩溃，一个更安全的版本是:

INSERT INTO polls (name, author, created, expires)
VALUES ('TestPoll','Billy Bob','2013-05-01 04:17:31','2013-05-01 04:17:31')