更新文章標題

[bananasims]

求先個 server 好似死死下咁，其實我用咗條 SQL 去同啲回覆加返晒 Re:，搞到好似死 server 咁。

代碼: 選擇全部

UPDATE phpbb_posts p SET p.post_subject = (SELECT t.topic_title FROM phpbb_topics t WHERE t.topic_id = p.topic_id) WHERE (SELECT COUNT(*) FROM phpbb_topics g WHERE g.topic_first_post_id = p.post_id) >= 1;
UPDATE phpbb_posts p SET p.post_subject = CONCAT('Re: ', (SELECT t.topic_title FROM phpbb_topics t WHERE t.topic_id = p.topic_id)) WHERE (SELECT COUNT(*) FROM phpbb_topics g WHERE g.topic_first_post_id = p.post_id) < 1;


[hamu278]

唔怪得頭先好似好難 load 入黎睇 post 啦

[bananasims]

唔怪得頭先好似好難 load 入黎睇 post 啦

當然，SQL 中有 SQL

[lsp]

係喎 COUNT(*) 有嘜用架, 特然間唔記得左, 想問下

[bananasims]

係喎 COUNT(*) 有嘜用架, 特然間唔記得左, 想問下

SELECT 咗既資料總共有幾多行。

[hamu278]

WC 一陣會唔會搵你

[bananasims]

應該唔會，幾分鐘啫

[lsp]

BNN 話 「咁都搵我, 即刻轉用公廁」

[bananasims]

BNN 話 「咁都搵我, 即刻轉用公廁」

好鬼好笑既啫