create table 'book'
(
'book_id' int(11) not null AUTO_INCREMENT,
'book_name' varchar(100) not null default '',
'book_author' varchar(100) not null default '',
'book_price' double not null default '0',
'image' varchar(100) not null default '',
'describe' varchar(200) not null default '',
primary key('book_id')
)
例示:
create table 'student'
(
'student_id' int(11) not null autou_increment,
'student_name' varchar(100) not null default '',
'student_number' double not null default '0',
primary key('student_id')
)