At 2:04 PM +0200 9/10/01, Ralof wrote:
>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,
>but I can not set it, andd it seem to be totally
>ignored in the manual.
>
>Does anyone know anything about this?
There is no EXTRA coluumn.
You're misinterpreting the output from SHOW COLUMNS. That statement
provides information about the columns in a table, but the column names
of the SHOW COLUMNS output do not all corrspond to attributes that
you can set directly when you create the table.
Those you can specify directly:
FIELD (column name)
TYPE (the column type; INT, CHAR, etc.)
NULL (by specifying NULL or NOT NULL)
DEFAULT
KEY (by specifying indexes for the the table)
Those you cannot specify directly:
EXTRA (currently used in SHOW COLUMNS only to indicate whether or not
the column has the AUTO_INCREMENT attribute)
PRIVILEGES (you must set these with a GRANT statement)
>
>
>Thankful for any help
>
>Stefan
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
