Mysql1064 error cause and Solution

The 1064 error indicates that My SQL syntax is incorrect and the specific location of the error is displayed.

View the content to be updated and execute new php statements.

The php statement is as follows:

If (! $ Handle = @ fopen ($ fname, "r") {echo "open $ fname failed \ n"; exit ;}; $ str = ""; $ count = 0; $ ins = "insert into pydot_g (id, aauthor) VALUES"; while ($ buf = fgets ($ handle, 1000 ))! = False) {list ($ id, $ field) = explode ("#", $ buf); $ str. = sprintf ('(% d,' % s'), ', $ id, $ field); $ count ++;} $ str. = "(3955, '000000')"; $ dup = "on duplicate key update aauthor = VALUES (aauthor);"; $ SQL = $ ins. $ str. $ dup; // echo $ SQL. "\ n"; if (! Mysql_query ($ SQL) {echo "mysql failed \ n"; echo mysql_errno (). ":". mysql_error (). "\ n" ;}fclose ($ handle); mysql_close ($ link );

The content to be updated is as follows:

1320 # CarryDream Int 'l Co., Ltd.1321 # es app Group1322 # app4uu

It can be found that there are still single quotation marks (') in the content to be followed, and the fields printed in the SQL statement also contain single quotation marks, which conflict with each other.

So the solution is to change the SQL statement to the double quotation mark "", so this problem can be solved.