建立數(shù)據(jù)庫，以及表
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;