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;
|
|
|
|
|
|
|
