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
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