MySQL中建库、建表、建记录的相关SQL

建库

drop database if exists book;
create database book;
use book;

建表

drop table if exists t_user;
CREATE TABLE `t_user`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL UNIQUE,
  `password` varchar(32) NOT NULL,
  `email` varchar(200) NULL,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

建记录

insert into t_user (`username`,`password`,`email`) values ('admin','admin','admin@life.com');