DROP DATABASE IF EXISTS `bd36_user`;
CREATE DATABASE IF NOT EXISTS `bd36_user`;
USE `bd36_user`;
CREATE TABLE IF NOT EXISTS `user` (
`id` int PRIMARY KEY AUTO_INCREMENT COMMENT 'id',
`account` varchar(20) NOT NULL COMMENT '账号',
`password` varchar(20) NOT NULL COMMENT '密码',
`age` int NOT NULL COMMENT '年龄'
) COMMENT '用户表';
INSERT INTO user VALUES(null, 'zhangsan', '123456', 20);
INSERT INTO user VALUES(null, 'lisi', 'aaaaaa', 35);
INSERT INTO user VALUES(null, 'wangwu', 'bbbbbb', 25);
INSERT INTO user VALUES(null, 'zhaoliu', '123abc', 30);
图1创建下图所示的所有东西用的的数据库DROP DATABASE IF EXISTS `bd36_user`;CREATE DATABASE IF NOT EXISTS `bd36_user`;USE `bd36_user`;CREATE TABLE IF NOT EXISTS `user` ( `id` int PRIMARY KEY AUTO_INCREMENT C...