📄 books.sql
字号:
CREATE TABLE books
(id VARCHAR(8)
PRIMARY KEY,
name VARCHAR(24),
title VARCHAR(96),
price FLOAT,
yr INT,
description VARCHAR(30),
saleAmount INT) default charset=gbk;
INSERT INTO books VALUES('201', 'wangfa',
'Java',
33.75, 1999, 'Java program', 1000);
INSERT INTO books VALUES('202', 'zhangbing',
'Weblogic referance', 45.99,
2002, 'very good', 2000);
INSERT INTO books VALUES('203', 'sunyan',
'Oracle database',
40, 2003, 'the best book for oracle', 2000);
INSERT INTO books VALUES('204', 'dawei',
'from oak to Java',
20.75, 1998, 'worth to look', 2000);
INSERT INTO books VALUES('205', 'aming',
'Apache',
50.75, 2002, 'the material for Apache', 2000);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -