create.sql

来自「struts写的一个分页代码」· SQL 代码 · 共 28 行

create table student(
	id int(10) auto_increment primary key,
	name varchar(20),
	age int(10)
);
commit;
insert into student values(1,"tarena1",25);
insert into student values(2,"tarena2",25);
insert into student values(3,"tarena3",25);
insert into student values(4,"tarena4",25);
insert into student values(5,"tarena5",25);
insert into student values(6,"tarena6",25);
insert into student values(7,"tarena7",25);
insert into student values(8,"tarena8",25);
insert into student values(9,"tarena9",25);
insert into student values(10,"tarena10",25);
insert into student values(11,"tarena11",25);
insert into student values(12,"tarena12",25);
insert into student values(13,"tarena13",25);
insert into student values(14,"tarena14",25);
insert into student values(15,"tarena15",25);
insert into student values(16,"tarena16",25);
insert into student values(17,"tarena17",25);
insert into student values(18,"tarena18",25);
insert into student values(19,"tarena19",25);
insert into student values(20,"tarena20",25);

select * from student;