Forum Moderators: coopster
mysql> explain users;
+-------------------+-----------------------+------+-----+------------+-----------------+
¦ Field ¦ Type ¦ Null ¦ Key ¦ Default ¦ Extra ¦
+-------------------+-----------------------+------+-----+------------+-----------------+
¦ user_id ¦ mediumint(8) unsigned ¦ ¦ PRI ¦ NULL ¦ auto_increm ent ¦
¦ username ¦ varchar(20) ¦ YES ¦ ¦ NULL ¦ ¦
¦ first_name ¦ varchar(15) ¦ ¦ ¦ ¦ ¦
¦ last_name ¦ varchar(30) ¦ ¦ ¦ ¦ ¦
¦ email ¦ varchar(40) ¦ YES ¦ ¦ NULL ¦ ¦
¦ password ¦ varchar(16) ¦ ¦ ¦ ¦ ¦
¦ registration_date ¦ date ¦ ¦ ¦ 0000-00-00 ¦ ¦
¦ link ¦ varchar(60) ¦ ¦ ¦ ¦ ¦
¦ da ¦ varchar(25) ¦ ¦ ¦ unknown ¦ ¦
+-------------------+-----------------------+------+-----+------------+-----------------+
9 rows in set (0.00 sec)
mysql>
Sample sql query above. Very simple.