Hi, I am moving a myself database from one hosting company to another for a website.


I have statements like:

INSERT INTO mpn_shopping_4nstats_datecnt VALUES ( '22022002', '79');

But MySQL comes back with:

INSERT INTO mpn_shopping_4nstats_datecnt VALUES ( \'22022002\', \'79\');

MySQL said: 

You have an error in your SQL syntax near '\'22022002\', \'79\')' at line 1

Some reason, MySQL doesn't like the quotes. single or double.

Is there some switch I can set on this msql server?

phpMyAdmin 2.2.0
MySQL 3.23.56 running on localhost

Thanks

John


- - - - -
John Hung P. Ho, Consultant
[EMAIL PROTECTED] - 
(619) 277-0164 virtual office, PST

Reply via email to