Created when there is no problem, but an error 1064 when inserting data, the last one is the print of the SQL statement

CodePudding user response:

The value and try on quotes

CodePudding user response:

reference 1/f, February 16 response:

add value on quotes try

Solve the cow force
Is this statement right
SQL="INSERT INTO booklist (bookisbn, bookname, bookauthor, booktext, bookimg) VALUES (' % s', '% s',' % s', '% s',' % s')" % (s1, s2, s3, s4, s5)
This is the wrong
SQL="INSERT INTO booklist (bookisbn, bookname, bookauthor, booktext, bookimg) VALUES (% s, % s, % s, % s, % s)" % (s1, s2, s3, s4, s5)