這只是一篇文記,我不打算詳細說明
主要功能就是把某一個表的資料參照過來做更新
UPDATE file_record
SET tid = (select cdb_posts.tid from cdb_posts where cdb_posts.pid=file_record.pid)
WHERE EXISTS (select cdb_posts.tid from cdb_posts where cdb_posts.pid=file_record.pid);
隨機文章
- ubuntu 2004 LEMP Quickly Install Guide. (2020-07-24)
- 用壓力鍋做紅豆西米露 (2011-10-05)
- Blogger xmlrpc API問題 (2007-10-31)
- Windows 7 X64 + Appserv + ODBC + Mysql => Error IM014 (2020-07-01)
- 不給力的永豐銀行全國加油站聯名卡 (2014-02-26)