MySQL学生管理系统：创建表、插入数据示例

生成学生管理表：

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `age` int(11) NOT NULL,
  `sex` varchar(10) NOT NULL,
  `class` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

生成登录注册表：

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

插入 20 条数据：

INSERT INTO `student` (`name`, `age`, `sex`, `class`) VALUES
('张三', 18, '男', '高一1班'),
('李四', 19, '男', '高一2班'),
('王五', 17, '女', '高一3班'),
('赵六', 18, '男', '高一1班'),
('钱七', 19, '女', '高一2班'),
('孙八', 17, '男', '高一3班'),
('周九', 18, '女', '高一1班'),
('吴十', 19, '男', '高一2班'),
('郑十一', 17, '女', '高一3班'),
('王十二', 18, '男', '高一1班'),
('张十三', 19, '女', '高一2班'),
('李十四', 17, '男', '高一3班'),
('赵十五', 18, '女', '高一1班'),
('钱十六', 19, '男', '高一2班'),
('孙十七', 17, '女', '高一3班'),
('周十八', 18, '男', '高一1班'),
('吴十九', 19, '女', '高一2班'),
('郑二十', 17, '男', '高一3班'),
('刘一', 18, '女', '高一1班'),
('陈二', 19, '男', '高一2班');

INSERT INTO `user` (`username`, `password`) VALUES
('admin', 'admin'),
('user1', '123456'),
('user2', '123456'),
('user3', '123456'),
('user4', '123456'),
('user5', '123456'),
('user6', '123456'),
('user7', '123456'),
('user8', '123456'),
('user9', '123456'),
('user10', '123456'),
('user11', '123456'),
('user12', '123456'),
('user13', '123456'),
('user14', '123456'),
('user15', '123456'),
('user16', '123456'),
('user17', '123456'),
('user18', '123456'),
('user19', '123456');