coscup還是回味無窮阿~

INT旁邊有數字，表示可以容納多少個數字
VARCHAR存文字，旁邊的數字45超過會存不進去
TINYINT存0跟1
調排序

往上拉按APPLY顯示就會不同
用語法看只要看的內容
目前可以看到全部用*

只要看到id跟win
SELECT id,win FROM sampledatabase.sbl_team_data;

撈出team_id=2
SELECT * FROM sampledatabase.sbl_team_data where team_id=2

撈出team_id>2的資料
SELECT * FROM sampledatabase.sbl_team_data where team_id>2

撈出team_id !=2的資料

撈出team_id 在2跟6用in
SELECT * FROM sampledatabase.sbl_team_data where team_id in (2,6)

找出team_id 在2跟5之間
SELECT * FROM sampledatabase.sbl_team_data where team_id between 2 and 5

點team_id欄位顯示^表示遞增排序

找出season欄位有包含S1
SELECT * FROM sampledatabase.sbl_team_data where season like '%S1%'

找win欄位2開頭用2%
SELECT * FROM sampledatabase.sbl_team_data where win like '2%'

找win欄位2結尾用%2
SELECT * FROM sampledatabase.sbl_team_data where win like '%2'

找 lost欄位不是空值 NULL
然後season是S16
SELECT * FROM sampledatabase.sbl_team_data where lost is not null and season = 'S16'

新增 資料SQL
INSERT INTO sampledatabase.sbl_team_data (team_id, win) VALUES ('43', '3');

用,擺在一起可以節省效能
INSERT INTO sampledatabase.sbl_team_data (team_id, win) VALUES ('43', '3'), ('56', '3');

按 重新整理

討論資料庫關聯
新增表

顯示 寫表名

寫表的內容，按apply

旁邊按重新整理顯示

加入內容再按APPLY

顯示

大家明天見~