mysql - ER_WRONG_VALUE_COUNT_ON_ROW : Column count doesn't match value count at row 1

Question

ER_WRONG_VALUE_COUNT_ON_ROW:列数与第 1 行的值数不匹配

CREATE TABLE employee (

employee_id INT,
first_name VARCHAR(20) NOT NULL,
last_name VARCHAR(20),
birth_date DATE,
sex VARCHAR(1),
salary INT,
super_id INT,
branch_id INT,
PRIMARY KEY(employee_id)
);


INSERT INTO employee VALUES(100, 'David', 'Wallace', '1967-11-17', 'M', 250,000, 2, 1);

Answer 1

从你的工资值中删除comma(,) - 它的数据类型是 int

INSERT INTO employee
VALUES(100, 'David', 'Wallace', '1967-11-17', 'M', 250000, 2, 1)