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