?? derby.createstoragebin.sql
字號:
drop table storagebin;drop table widget;create table widget(widgetid varchar(3) not null, constraint pk_widget primary key (widgetid),description varchar(50),price decimal (10,2));insert into widgetvalues ('876', 'Intergalactic Transporter', 1300.00);insert into widgetvalues ('543', 'Superwarp Retrodrive', 55.00);insert into widgetvalues ('777', 'Duct Tape', 1.00);create table storagebin (storagebinid varchar(3) not null, constraint pk_storagebin primary key (storagebinid), widgetid varchar(3), quantity integer, constraint fk_widgetid foreign key (widgetid) references widget(widgetid));insert into storagebinvalues ('123', '876', 100);insert into storagebinvalues ('221', '543', 50);insert into storagebinvalues ('388', '777', 500);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -