[問卦] 8000萬筆資料的SQL
通通塞在一個table裡面 還沒建primary key
剛剛幫他建一個primary key下去
只看到一直在running
是不是等中午吃完便當再回來看他PK建完沒?
還是下班前再看了?
--
推
02/16 22:07,
02/16 22:07
→
02/16 22:08,
02/16 22:08
→
02/16 22:09,
02/16 22:09
→
02/16 22:09,
02/16 22:09
→
02/16 22:10,
02/16 22:10
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.82.161.33 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/Gossiping/M.1695089131.A.32C.html
推
09/19 10:05,
7月前
, 1F
09/19 10:05, 1F
→
09/19 10:06,
7月前
, 2F
09/19 10:06, 2F
噓
09/19 10:06,
7月前
, 3F
09/19 10:06, 3F
→
09/19 10:07,
7月前
, 4F
09/19 10:07, 4F
要問原本弄這套系統的啊 媽的有病
→
09/19 10:07,
7月前
, 5F
09/19 10:07, 5F
噓
09/19 10:07,
7月前
, 6F
09/19 10:07, 6F
→
09/19 10:07,
7月前
, 7F
09/19 10:07, 7F
現在就是要拆 不先弄個PK每次都要全表掃
我看到年底都拆不完
→
09/19 10:08,
7月前
, 8F
09/19 10:08, 8F
→
09/19 10:08,
7月前
, 9F
09/19 10:08, 9F
這麼天的系統你怎麼會覺得會有說明文件
※ 編輯: Merkle (111.82.161.33 臺灣), 09/19/2023 10:10:53
推
09/19 10:09,
7月前
, 10F
09/19 10:09, 10F
噓
09/19 10:09,
7月前
, 11F
09/19 10:09, 11F
推
09/19 10:09,
7月前
, 12F
09/19 10:09, 12F
→
09/19 10:10,
7月前
, 13F
09/19 10:10, 13F
→
09/19 10:10,
7月前
, 14F
09/19 10:10, 14F
推
09/19 10:10,
7月前
, 15F
09/19 10:10, 15F
→
09/19 10:11,
7月前
, 16F
09/19 10:11, 16F
推
09/19 10:11,
7月前
, 17F
09/19 10:11, 17F
推
09/19 10:13,
7月前
, 18F
09/19 10:13, 18F
→
09/19 10:14,
7月前
, 19F
09/19 10:14, 19F
推
09/19 10:14,
7月前
, 20F
09/19 10:14, 20F
當然是舊資料要留著才要這樣搞
→
09/19 10:14,
7月前
, 21F
09/19 10:14, 21F
→
09/19 10:14,
7月前
, 22F
09/19 10:14, 22F
推
09/19 10:16,
7月前
, 23F
09/19 10:16, 23F
→
09/19 10:16,
7月前
, 24F
09/19 10:16, 24F
推
09/19 10:18,
7月前
, 25F
09/19 10:18, 25F
→
09/19 10:19,
7月前
, 26F
09/19 10:19, 26F
→
09/19 10:19,
7月前
, 27F
09/19 10:19, 27F
推
09/19 10:19,
7月前
, 28F
09/19 10:19, 28F
推
09/19 10:20,
7月前
, 29F
09/19 10:20, 29F
推
09/19 10:24,
7月前
, 30F
09/19 10:24, 30F
要去問那位當年幫他們弄的天才啊...
→
09/19 10:24,
7月前
, 31F
09/19 10:24, 31F
推
09/19 10:28,
7月前
, 32F
09/19 10:28, 32F
※ 編輯: Merkle (111.82.161.33 臺灣), 09/19/2023 10:31:56
→
09/19 10:32,
7月前
, 33F
09/19 10:32, 33F
→
09/19 10:33,
7月前
, 34F
09/19 10:33, 34F
推
09/19 10:37,
7月前
, 35F
09/19 10:37, 35F
→
09/19 10:37,
7月前
, 36F
09/19 10:37, 36F
推
09/19 10:38,
7月前
, 37F
09/19 10:38, 37F
推
09/19 10:45,
7月前
, 38F
09/19 10:45, 38F
→
09/19 10:47,
7月前
, 39F
09/19 10:47, 39F
推
09/19 10:54,
7月前
, 40F
09/19 10:54, 40F
推
09/19 10:55,
7月前
, 41F
09/19 10:55, 41F
推
09/19 11:03,
7月前
, 42F
09/19 11:03, 42F
推
09/19 11:04,
7月前
, 43F
09/19 11:04, 43F
→
09/19 11:04,
7月前
, 44F
09/19 11:04, 44F
推
09/19 11:04,
7月前
, 45F
09/19 11:04, 45F
推
09/19 11:16,
7月前
, 46F
09/19 11:16, 46F
→
09/19 11:25,
7月前
, 47F
09/19 11:25, 47F
推
09/19 11:29,
7月前
, 48F
09/19 11:29, 48F
推
09/19 11:34,
7月前
, 49F
09/19 11:34, 49F
→
09/19 11:41,
7月前
, 50F
09/19 11:41, 50F
推
09/19 11:50,
7月前
, 51F
09/19 11:50, 51F
推
09/19 12:18,
7月前
, 52F
09/19 12:18, 52F
→
09/19 12:20,
7月前
, 53F
09/19 12:20, 53F
→
09/19 12:21,
7月前
, 54F
09/19 12:21, 54F
→
09/19 12:22,
7月前
, 55F
09/19 12:22, 55F
推
09/19 12:26,
7月前
, 56F
09/19 12:26, 56F
推
09/19 12:29,
7月前
, 57F
09/19 12:29, 57F
推
09/19 12:34,
7月前
, 58F
09/19 12:34, 58F
→
09/19 12:47,
7月前
, 59F
09/19 12:47, 59F
→
09/19 12:53,
7月前
, 60F
09/19 12:53, 60F
推
09/19 14:32,
7月前
, 61F
09/19 14:32, 61F
→
09/19 15:12,
7月前
, 62F
09/19 15:12, 62F
推
09/19 18:39,
7月前
, 63F
09/19 18:39, 63F
推
09/19 20:11,
7月前
, 64F
09/19 20:11, 64F
討論串 (同標題文章)