CREATE TABLE my_contacts
(
last_name VARCHAR(30),
first_name VARCHAR(30),
email VARCHAR(50),
gender CHAR(1),
birthday DATE,
profession VARCHAR(50),
location VARCHAR(50),
status VARCHAR(20),
interests VARCHAR(100),
seeking VARCHAR(100)
);
原文：http://www.cnblogs.com/hello-yz/p/5229232.html