|
楼主 |
发表于 2004-8-19 11:45:35
|
显示全部楼层
[PHP]
create table create_member(
member_id int unsigned not null auto_increment,
primary key(member_id),
last_name varchar(20) not null,
first_name varchar(20) not null,
suffix varchar(5) null,
expiration date null default'0000-00-00',
email varchar(100) null,
street varchar(50) null,
city varchar(50) null,
state varchar(2) null,
zip VARCHAR(10) NULL,
phone VARCHAR(20) NULL,
interests VARCHAR(255) NULL
);
[/PHP]
我如果把它们一条一条写在mysql>后面就能建立表 |
|