插入数据报错

Question

INSERT IN students VALUE(1, ‘张三’, ‘三哥’, ‘男’, now());

[SQL]INSERT IN students VALUE(1, ‘张三’, ‘三哥’, ‘男’, now());
[Err] 1064 - 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 ‘IN students VALUE(1, ‘张三’, ‘三哥’, ‘男’, now())’ at line 1

Answer 1

提问者 沧海遗珠丶丶 2019-03-15 18:20:54

找到问题的原因了，都是小问题

Answer 2

提问者 沧海遗珠丶丶 2019-03-15 18:01:21

运行插入语句，刷新之后，表里面没有变化

Answer 3

提问者 沧海遗珠丶丶 2019-03-15 17:53:51

[SQL]INSERT INTO `students` VALUE(1, '张三', '三哥', '男', now());

[Err] 1366 - Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' at row 1

现在是这个错误了