這只是一篇文記，我不打算詳細說明
主要功能就是把某一個表的資料參照過來做更新
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);
隨機文章
- I got the website stop message. Ubuntu Web-Server on Proxmox VE is crashed. (2021-02-20)
- 謝長廷~你是律師~你的法律學到哪裡去了~ (2008-03-16)
- rclone FreeBSD issue – config file not found (2019-12-20)
- 虛擬主機-StartLogic (2007-12-04)
- 桃園永安漁港(愈夜愈美麗 ) (2007-11-07)
隨機美圖
