Mega Code Archive

 

Categories / MySQL / Table Index

 

Get the descriptive data of the columns belonging to the PLAYERS table

mysql> mysql> mysql> CREATE TABLE PLAYERS     -> (     ->     PLAYERNO INTEGER NOT NULL,     ->     NAME CHAR(15) NOT NULL,     ->     INITIALS CHAR(3) NOT NULL,     ->     BIRTH_DATE DATE ,     ->     SEX CHAR(1) NOT NULL,     ->     JOINED SMALLINT NOT NULL,     ->     STREET VARCHAR(30) NOT NULL,     ->     HOUSENO CHAR(4) ,     ->     POSTCODE CHAR(6) ,     ->     TOWN VARCHAR(30) NOT NULL,     ->     PHONENO CHAR(13) ,     ->     LEAGUENO CHAR(4) ,     ->     PRIMARY KEY (PLAYERNO)     -> ); Query OK, 0 rows affected (0.00 sec) mysql> mysql> mysql> SHOW COLUMNS FROM PLAYERS; +------------+-------------+------+-----+---------+-------+ | Field      | Type        | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | PLAYERNO   | int(11)     | NO   | PRI | NULL    |       | | NAME       | char(15)    | NO   |     | NULL    |       | | INITIALS   | char(3)     | NO   |     | NULL    |       | | BIRTH_DATE | date        | YES  |     | NULL    |       | | SEX        | char(1)     | NO   |     | NULL    |       | | JOINED     | smallint(6) | NO   |     | NULL    |       | | STREET     | varchar(30) | NO   |     | NULL    |       | | HOUSENO    | char(4)     | YES  |     | NULL    |       | | POSTCODE   | char(6)     | YES  |     | NULL    |       | | TOWN       | varchar(30) | NO   |     | NULL    |       | | PHONENO    | char(13)    | YES  |     | NULL    |       | | LEAGUENO   | char(4)     | YES  |     | NULL    |       | +------------+-------------+------+-----+---------+-------+ 12 rows in set (0.00 sec) mysql> mysql> drop table players; Query OK, 0 rows affected (0.00 sec) mysql> mysql> mysql>