建立数据库,以及表
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;
	
posted on 2009-07-01 15:56 
期待明天 阅读(173) 
评论(0)  编辑  收藏  所属分类: 
MySQL