Please help me find out where I made the mistake. Thank you for your careful answer.

Question

Why is an error returned?

Answer 1

INSERT INTO myuser VALUES('','mijueshitai','123456',86,'meijie@qq.com','emeishan');

Answer 2

Check the ID to see if it grows automatically. If it grows automatically, you don’t need to write this column when writing data, that is:

INSERT INTO myuser(NAME,PWD,AGE,EMAIL,ADDR) VALUES('mijueshitai','123456',86,'meijie@qq.com','emeishan');

另外在数据表设计的时候，尽量别使用数据库的一些关键字，如NAME。

Answer 3

Look at your table structure, the data type may be wrong

Answer 4

The value inserted is wrong. The id should be the primary key, not NULL!