SQL/MySQL/Table Index/Table Structure

Use DESCRIBE to find out the table structure

   <source lang="sql">

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

      </source>