开发者

load SQL and ignore duplicates

开发者 https://www.devze.com 2023-02-19 21:02 出处:网络
I want to import an SQL file using PHPMyAdmin where I know开发者_C百科 duplicates exist.I am using the syntax:

I want to import an SQL file using PHPMyAdmin where I know开发者_C百科 duplicates exist. I am using the syntax:

LOAD DATA INFILE 'C:\Documents and Settings\...\db_settings_extends.sql' ignore;

I receive the error:

#1064 - 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 '' at line 1

How do I correct this?


From the error message, it looks like duplicates are not the problem. It seems to not like your string value or something next to it.

0

精彩评论

暂无评论...
验证码 换一张
取 消