|
|
Posted by Alex on 03/09/07 23:20
On Mar 9, 8:36 am, "J.O. Aho" <u...@example.net> wrote:
> alex.wald...@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
Problem solved :D
The issue was the 'Dual'. I renamed it and now it works just fine.
Thanks a lot for your help all of you!
Navigation:
[Reply to this message]
|