建立數據庫,以及表
create database rorely;
use rorely;
create table test(
id int(4) not null unique auto_increment,
name varchar(20) not null,
age int(3) not null,
sex varchar(10)not null,
address varchar(100)
);
insert into test values(null,'Jim',23,'male','wenming cun 23#');
insert into test values(null,'Jim',23,'male','wenming cun 23#');
insert into test values(null,'Jim',23,'male','wenming cun 23#');
insert into test values(null,'Jim',23,'male','wenming cun 23#');
insert into test values(null,'Jim',23,'male','wenming cun 23#');
select * from test;