建库建表

drop database if exists zpark;




CREATE DATABASE  zpark DEFAULT CHARACTER SET=UTF8;




create table tb_user

(

id int(12) auto_increment not null primary key,

name char(20) not null,

password char(20),

address varchar(100) default "北京",

regtime date

);


insert into tb_user (name,password,regtime) values ('tillzhang','123456','2007-08-21');

insert into tb_user (name,password,regtime) values ('till','234567','2007-08-22');


describe命令察看刚建立的表结构

mysql>describe