Built a book table using the insert into the book (bookid, bookname, bookauthor, bookcategory booknumber, bookprice) values (' 001 ', 'ordinary world', 'lu yao', 'social class', '100', '50 RMB); To insert data in a book,
But the mysql prompt 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 ', 'ordinary world', 'lu yao', 'social class', '100', '50 RMB at line 1') '

CodePudding user response:

The back of the '001' should not be the whole Angle of commas