I just created a database on my new mySQL 5 DB and started adding tables from a previous version SQL dump. I am receiving errors around INSERTS with escaped characters \'95,98,ME\'
LOCK TABLES `script_os` WRITE;
INSERT INTO `script_os` VALUES (1,'All Windows Versions','if(true)\n($func)'),(2,'Windows 9x','if(CheckOperatingSystem(\'95,98,ME\'))\n($func)'),(3,'Windows NT','if(CheckOperatingSystem(\'XP,2000,NT4,2003\'))\n($func)');
Am I missing something? I need to insert this progrmatically into the DB so I need for this to work rather than creating new escape keys. I understand the reason was to prevent SQL Injection but surely I am not the only one having issues with this? I searched and found a few articles only.
Thanks for any insight you can provide.