代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/451042/1667434
sql create.sql
drop table savingsaccount;
create table savingsaccount
(id varchar(3) constraint pk_savings_account primary key,
firstname varchar(24),
lastname varchar(24),
balance numeric(10,2));
exit;
www.eeworm.com/read/451042/1667440
sql create.sql
drop table lineitems;
drop table orders;
create table orders
(orderid varchar(3) constraint pk_order primary key,
customerid varchar(3),
totalprice decimal(10,2),
status varchar(10));
insert into
www.eeworm.com/read/451042/1667446
sql create.sql
drop table checking;
create table checking
(id varchar(3) constraint pk_checking primary key,
balance decimal(10,2));
insert into checking
values ('123', 100.00);
drop table saving;
create t
www.eeworm.com/read/451042/1667452
sql create.sql
drop table inventory;
create table inventory
(product_id varchar(3),
quantity decimal(10));
insert into inventory
values ('123', 100);
drop table order_item;
create table order_item
(order
www.eeworm.com/read/451042/1667463
sql create.sql
drop table LINEITEM;
drop table ORDERS;
drop table VENDOR_PART;
drop table VENDOR;
drop table PART_DETAIL;
drop table PART;
commit;
/* Self-ref to identify Bill of Material (BOM)
* Compound PK
*/
www.eeworm.com/read/451042/1667511
sql create.sql
drop table customer;
drop table salesrep;
create table salesrep
(salesrepid varchar(3) constraint pk_salesrep primary key,
name varchar(24));
insert into salesrep
values ('876', 'Clyde Webster');
in
www.eeworm.com/read/451042/1667519
sql create.sql
drop table enrollment;
drop table student;
drop table course;
create table student
(studentid varchar(3) constraint pk_student primary key,
name varchar(36));
insert into student
values ('123', '
www.eeworm.com/read/451042/1667534
sql create.sql
-- create tables for CMP roster application
drop table league;
drop table player;
drop table team;
drop table team_player;
commit;
create table league (
id VARCHAR(8) CONSTRAINT pk_league PRIMARY
www.eeworm.com/read/451042/1667553
sql create.sql
drop table storagebin;
drop table widget;
create table widget
(widgetid varchar(3) constraint pk_widget primary key,
description varchar(50),
price decimal (10,2));
insert into widget
values ('876',
www.eeworm.com/read/451042/1667620
sql bank.sql
-- create tables for online banking app
-- also seeds next_id tables w. initial values
DROP TABLE customer_account_xref;
DROP TABLE tx;
DROP TABLE customer;
DROP TABLE account;
DROP TABLE next