Use DESCRIBE to find out the table structure : Table Structure « Table Index « SQL / MySQL

1. SQL / MySQL
2. Table Index
3. Table Structure

Use DESCRIBE to find out the table structure

/*mysql> Drop table employee;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE employee (
    ->     id int unsigned not null auto_increment primary key,
    ->     firstname varchar(20),
    ->     lastname varchar(20),
    ->     title varchar(30),
    ->     age int,
    ->     yearofservice int,
    ->     salary int,
    ->     perks int,
    ->     email varchar(60)
    -> );
Query OK, 0 rows affected (0.04 sec)

mysql> Show tables;
+-----------------+
| Tables_in_t     |
+-----------------+
| bird            |
| category        |
| cloth           |
| employee        |
| event           |
| exam            |
| man             |
| myusers         |
| person          |
| product         |
| productcategory |
| report          |
| sales           |
| shirt           |
| student         |
| timetable       |
+-----------------+
16 rows in set (0.00 sec)

mysql> Describe employee;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| id            | int(10) unsigned |      | PRI | NULL    | auto_increment |
| firstname     | varchar(20)      | YES  |     | NULL    |                |
| lastname      | varchar(20)      | YES  |     | NULL    |                |
| title         | varchar(30)      | YES  |     | NULL    |                |
| age           | int(11)          | YES  |     | NULL    |                |
| yearofservice | int(11)          | YES  |     | NULL    |                |
| salary        | int(11)          | YES  |     | NULL    |                |
| perks         | int(11)          | YES  |     | NULL    |                |
| email         | varchar(60)      | YES  |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)

*/
Drop table employee;

CREATE TABLE employee (
    id int unsigned not null auto_increment primary key,
    firstname varchar(20),
    lastname varchar(20),
    title varchar(30),
    age int,
    yearofservice int,
    salary int,
    perks int,
    email varchar(60)
); 

Show tables;

Describe employee;



           
       

Related examples in the same category