代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/141805/5768263
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/141805/5768274
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/141805/5768322
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/141805/5768330
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/141805/5768345
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/141805/5768364
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/141805/5768431
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
www.eeworm.com/read/141805/5768434
sql delete.sql
DELETE FROM tx;
DELETE FROM customer_account_xref;
DELETE FROM account;
DELETE FROM customer;
DELETE FROM next_id;
www.eeworm.com/read/141805/5768435
sql insert.sql
DELETE FROM tx;
DELETE FROM customer_account_xref;
DELETE FROM account;
DELETE FROM customer;
INSERT INTO account VALUES
('5005', 'Money Market', 'Hi Balance', 4000.00, 0.00, 3500.00, '2000-02-28 23: