/* mysql> Drop table Bird; Query OK, 0 rows affected (0.00 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.05 sec)
mysql> INSERT INTO Bird VALUES ('BlueBird','Joe','Car','f','1999-03-30',NULL); Query OK, 1 row affected (0.00 sec)
mysql> select * from Bird; +----------+-------+---------+------+------------+-------+ | name | owner | species | sex | birth | death | +----------+-------+---------+------+------------+-------+ | BlueBird | Joe | Car | f | 1999-03-30 | NULL | +----------+-------+---------+------+------------+-------+ 1 row in set (0.00 sec)
*/
Drop table Bird;
CREATE TABLE Bird ( name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE ); INSERT INTO Bird VALUES ('BlueBird','Joe','Car','f','1999-03-30',NULL);
select * from Bird;
|