Column definition: The EXTRA column

I am trying to use the EXTRA column that exist in mySQL ( DEFAULT EXTRA FIELD KEY NULL PRIVILEGES TYPE), but I do not understand how to put a value into it, I can get the value with SHOW COLUMNS,

RE: ASP MySQL

I usually use MySQL with MyODBC, then it is just like any other database, but faster :) Stefan -Original Message- From: L_U_I_Z [mailto:[EMAIL PROTECTED]] Sent: den 10 september 2001 22:08 To: [EMAIL PROTECTED] Subject: ASP MySQL I'm developing an application and I have to

The EXTRA field

Hi, I would like to use the EXTRA field for sorting and maybe caption, but I find no way of setting it. I tried like: Alter table myTable change myField myNewField varchar(255) DEFAULT 'a' EXTRA '3' But that does not work. I can not find anything in the documentation about this. Thanks