create table mysql 5.7 example

Example: mysql:5.6 syntax create table

Press CTRL+C to copy mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
       species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);