|
|
Posted by J.O. Aho on 03/09/07 07:36
alex.waldner@gmail.com wrote:
> Sorry - here you've got the whole error message.
>
> An Error Was Encountered
> Error Number: 1064
>
> 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 'Dual, Night, Instrument, CC, landingsDay, landingsNight,
> comment) VALUES (NULL, ' at line 1
>
> INSERT INTO logbook (id, pilot, date, acModel, acReg, blockOffAP,
> blockOff, blockOnAP, blockOn, totalTime, PIC, Dual, Night, Instrument,
> CC, landingsDay, landingsNight, comment) VALUES (NULL, '1',
> '2007-03-08', 'C172', 'SELZF', 'ESOW', '1234', 'ESSA', '1256', '0.4',
> '0', '0.4', '0', '0', '0', '0', '0', NULL)
>
Dual is a reserved word and should really not be used for
database/table/column/function/procedure names, I strongly recommend you
rename it, you can also use the "single quotes" ``.
Notice the difference from the usual single quote ' and the one used for
database/table/column names which is tittle a bit `.
--
//Aho
Navigation:
[Reply to this message]
|