建立数据库,以及表
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
期待明天 阅读(155)
评论(0) 编辑 收藏 所属分类:
MySQL