Yes, I have used `
I don't think check is reserverd because I can CREATE the column name! From
the mysql prompt its possible to insert a record, but not from my Delphi
Code. After that i try to alter / delete the column but thats impossible.
Other columns in the same table where altered without any problems.
Maybe its a bug I can create the column name check??
At 18:10 24-12-2003, you wrote:
>Have tried to use back sticks?
>----- Original Message -----
>From: "Martijn Tonies" <m.tonies@stripped>
>Sent: Wednesday, December 24, 2003 16:41
>Subject: Re: Column name: CHECK
> > > I use the column name CHECK (smallint), but when I insert into the table
> > > get an error : Check the manual for: Check) values ( etc.etc.
> > >
> > > When I try to change the column name (alter table tablename change check
> > > blabla smallint) I get an error too, check your manual..
> > >
> > > Does anybody know what's happening?
> > Reserved word?
> > With regards,
> > Martijn Tonies
> > Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
> > Server.
> > Upscene Productions
> > http://www.upscene.com
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1