Extra column in MYSQL

[aopen]

What information goes into Extra? Except auto_increment.

[Piranha]

Excuse me what? I don't understand what you are asking. Do you have a column named Extra or what?

[aopen]

MYSQL table has the following information:
Field, Type, NULL, KEY, Default, Extra. What information goes into Extra column?

[Piranha]

Are you using phpmyadmin, is that where you see it? A little better explanation please.

[aopen]

mysql> desc sessions;
+--------------+------------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+-------------------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| session_key | blob | YES | | NULL | |
| session_data | blob | YES | | NULL | |
| access_ts | timestamp | NO | | CURRENT_TIMESTAMP | |
| create_on | datetime | YES | | NULL | |
+--------------+------------------+------+-----+-------------------+----------------+

[bradgrafelman]

I've personally never seen any other property of a column except auto_increment be shown in the "Extra" column.

[NogDog]

The online manual does not list the possibilities, and only shows auto-increment as an example. Likewise, I do not off-hand ever remember seeing anything else there. Unfortunately, that's a less than definitive answer, but the best I have right now. 🙂