lundi 6 juillet 2015

MySQL "old version syntax"

im currently porting my SQLite database to MySQL, just made a script to change all INSERT's and more to MySQL but im sometimes getting an "old version syntax error":

INSERT INTO players(id, name) VALUES (21457, '/Gohst_Killer67\');

The Database structure:

CREATE TABLE IF NOT EXISTS players (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(40))

I have alot usernames saved, but those / or \ keeps raising those error messages. I hope theres a way to fix it without editing all names which contain / or .

Thanks

Aucun commentaire:

Enregistrer un commentaire