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??
Regards hans
At 18:10 24-12-2003, you wrote:
Have tried to use back sticks? Like `check`
Thanks Emery
----- Original Message ----- From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 I > > 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 SQL > 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/[EMAIL PROTECTED] > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]