/*
mysql> Drop table Bird;
Query OK, 0 rows affected (0.08 sec)
mysql> CREATE TABLE Bird (
-> name VARCHAR(20),
-> owner VARCHAR(20),
-> species VARCHAR(20),
-> sex CHAR(1),
-> birth DATE,
-> death DATE
-> );
Query OK, 0 rows affected (0.04 sec)
mysql> SHOW TABLES;
+----------------+
| Tables_in_info |
+----------------+
| bird |
| cloth |
| course |
| employee |
| event |
| exam |
| myusers |
| report |
| timetable |
| users |
+----------------+
10 rows in set (0.00 sec)
mysql> /* To verify that the table was created the way you expected,
mysql> use a DESCRIBE statement:
ERROR 1049 (42000): Unknown database 'a'
mysql> */
mysql> DESCRIBE Bird;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| owner | varchar(20) | YES | | NULL | |
| species | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| death | date | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
*/
Drop table Bird;
CREATE TABLE Bird (
name VARCHAR(20),
owner VARCHAR(20),
species VARCHAR(20),
sex CHAR(1),
birth DATE,
death DATE
);
SHOW TABLES;
/* To verify that the table was created the way you expected,
use a DESCRIBE statement:
*/
DESCRIBE Bird;