📄 bookstore.sql
字号:
use bookstore;
create table bookinfo(id INT not null primary key,title VARCHAR(50) not null,author VARCHAR(50) not null,bookconcern VARCHAR(100) not null,publish_date DATE not null,price FLOAT(4,2) not null,amount SMALLINT,remark VARCHAR(200));
insert into bookinfo values(1,'Java从入门到精通','张三','张三出版社','2004-6-1',34.00,35,null);
insert into bookinfo values(2,'JSP深入编程','李四','李四出版社','2004-10-1',56.00,20,null);
insert into bookinfo values(3,'J2EE高级编程','王五','王五出版社','2005-3-1',78.00,10,null);
create table account(userid VARCHAR(10) not null primary key,balance FLOAT(6,2));
insert account values("甲",500.00);
insert account values("乙",200.00);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -