1.MYSQL增删改查
2.创建表
CREATE TABLE MyGuests2 ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, age SMALLINT(5) UNSIGNED, sex VARCHAR(5), wherefrom VARCHAR(10), address VARCHAR(60), email VARCHAR(50), 爱好 varchar(10), reg_date TIMESTAMP )
运行图:
