MySql 之建表语句

create database book_db; use book_db; create table book( b_number int primary key, b_name varchar(20), b_auther varchar(20), b_publish varchar(20), b_price double, b_stock int ); alter table book rename t_book; alter table t_book modify b_number int auto_increment; insert into t_book(b_number,b_name,b_auther,b_publish,b_price,b_stock) values(1001,'Javaweb开发技术','李晓蕾','清华大学出版社', 44.50,10); insert into t_book(b_name,b_auther,b_publish,b_price,b_stock) values('Javaweb程序设计','陈培强','人民邮电出版社', 48.00,10);