thndr Posted February 2, 2006 Share Posted February 2, 2006 Hello again,Small problem.[code]INSERT INTO trans (Amount,Desc,Date,Empty) VALUES('5.95','Fees','02.01.06','W')[/code]it returns:[code]Query failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Desc,Date,Empty) VALUES('5.95','Fees','02.01.06','W')[/code]Thats not working, what did I miss? The first field in the DB structure is ID, and i moved servers, I used to just use "INSERT INTO trans VALUES ('','price') etc, but it doesnt allow that for the ID field on new server so Im trying to do it the other way and its not working. TIA.John Link to comment https://forums.phpfreaks.com/topic/3303-insert-into-not-working/ Share on other sites More sharing options...
wickning1 Posted February 2, 2006 Share Posted February 2, 2006 DESC is a reserved word (DATE should be too but mysql allows it). Try this:[code]INSERT INTO trans (Amount,`Desc`,Date,Empty) VALUES('5.95','Fees','02.01.06','W')[/code] Link to comment https://forums.phpfreaks.com/topic/3303-insert-into-not-working/#findComment-11263 Share on other sites More sharing options...
thndr Posted February 2, 2006 Author Share Posted February 2, 2006 Ah I should have known I think I had problems with that before, thanks! Link to comment https://forums.phpfreaks.com/topic/3303-insert-into-not-working/#findComment-11264 Share on other sites More sharing options...
fenway Posted February 2, 2006 Share Posted February 2, 2006 DATE is reserved, but only for CREATE/ALTER TABLE statements. Still, no need to use it. Link to comment https://forums.phpfreaks.com/topic/3303-insert-into-not-working/#findComment-11266 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.