mysql>mysql> CREATE TABLE myTable ( -> id int, -> first_name VARCHAR(20), -> last_name VARCHAR(20), -> sex CHAR(1), -> start_date DATE, -> end_date DATE);Query OK, 0 rows affected (0.05 sec)mysql>mysql> show tables;+----------------+| Tables_in_test |+----------------+| mytable |+----------------+1 row in set (0.00 sec)mysql>mysql> describe myTable;+------------+-------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+------------+-------------+------+-----+---------+-------+| id | int(11) | YES | | NULL | || first_name | varchar(20) | YES | | NULL | || last_name | varchar(20) | YES | | NULL | || sex | char(1) | YES | | NULL | || start_date | date | YES | | NULL | || end_date | date | YES | | NULL | |+------------+-------------+------+-----+---------+-------+6 rows in set (0.00 sec)mysql>mysql> drop table myTable;Query OK, 0 rows affected (0.00 sec)mysql>
Name (required)
email (will not be published) (required)
Website