create database stu; 创建数据库
use stu;使用数据库
create table studentinfo( id int(10) auto_increment primary key,name varchar(50),class varchar(50),dormitoryno varchar(10));
创建表格(id自增)
insert into studentinfo(name,class) values (‘小明’,103);打入信息
insert into studentinfo(name,class) values (‘小红’,103);
insert into studentinfo(name,class) values (‘小蓝’,103);