?? team.sql
字號:
/*
//參賽隊(組別,球隊)
CREATE TABLE Team
( group1 char(10),
team1 nchar(20) NOT NULL UNIQUE,
PRIMARY KEY (team1),
CHECK(group1 BETWEEN 'A' AND 'H'))
INSERT INTO Team
VALUES ('A', '德國')
INSERT INTO Team
VALUES ('A', '哥斯達黎加')
INSERT INTO Team
VALUES ('A', '波蘭')
INSERT INTO Team
VALUES ('A', '厄瓜多爾')
INSERT INTO Team
VALUES ('B', '英格蘭')
INSERT INTO Team
VALUES ('B', '瑞典')
INSERT INTO Team
VALUES ('B', '巴拉圭')
INSERT INTO Team
VALUES ('B', '特立尼達和多巴哥')
INSERT INTO Team
VALUES ('C', '阿根廷')
INSERT INTO Team
VALUES ('C', '荷蘭')
INSERT INTO Team
VALUES ('C', '科特迪瓦')
INSERT INTO Team
VALUES ('C', '塞黑')
INSERT INTO Team
VALUES ('D', '墨西哥')
INSERT INTO Team
VALUES ('D', '葡萄牙')
INSERT INTO Team
VALUES ('D', '伊朗')
INSERT INTO Team
VALUES ('D', '安哥拉')
INSERT INTO Team
VALUES ('E', '意大利')
INSERT INTO Team
VALUES ('E', '捷克')
INSERT INTO Team
VALUES ('E', '加納')
INSERT INTO Team
VALUES ('E', '美國')
INSERT INTO Team
VALUES ('F', '巴西')
INSERT INTO Team
VALUES ('F', '克羅地亞')
INSERT INTO Team
VALUES ('F', '澳大利亞')
INSERT INTO Team
VALUES ('F', '日本')
INSERT INTO Team
VALUES ('G', '法國')
INSERT INTO Team
VALUES ('G', '瑞士')
INSERT INTO Team
VALUES ('G', '韓國')
INSERT INTO Team
VALUES ('G', '多哥')
INSERT INTO Team
VALUES ('H', '西班牙')
INSERT INTO Team
VALUES ('H', '烏克蘭')
INSERT INTO Team
VALUES ('H', '突尼斯')
INSERT INTO Team
VALUES ('H', '沙特')
SELECT COUNT(group1)
FROM team
WHERE group1='A'
SELECT *
FROM Team
ORDER BY group1
DELETE FROM Team
*/
/*
//參賽隊(組別,球隊,國旗)
ALTER TABLE Team
ADD jack image
*/
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -