Why is an error returned?
INSERT INTO myuser VALUES('','mijueshitai','123456',86,'meijie@qq.com','emeishan');
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。
Look at your table structure, the data type may be wrong
The value inserted is wrong. The id should be the primary key, not NULL!
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:
Look at your table structure, the data type may be wrong
The value inserted is wrong. The id should be the primary key, not NULL!