MySQL 数据库及表的创建

drop database if exists testweb;
create database testweb character set utf8;
show databases;
use testweb;
drop table if exists person;

create table person(
id integer auto_increment comment ‘id’,
name varchar(20) comment ‘姓名’,
age integer comment ‘年龄’,
sex varchar(10) comment ‘性别’,
birthday date comment ‘出生日期’,
description text comment ‘备注’,
create_time timestamp default current_timestamp(),
primary key(id)
);