mysql query needs changing from old to new mysql?
Posted on 2009-05-17
I'm moving from a server with an old version of mysql 3.23.58 to a newer version, 5.0.45
In my php scripts, I have a query like this:
INSERT INTO oys_reports (city,code,condition,f,c) VALUES ('Baltimore IH','NAMD','na','61','16.1')
which doesn't seem to work with mysql 5, I just get a syntax error.
Is there a different way to do the same thing now?