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')
)