My Blog

toolman xyz

  1. Home
  2. About
  3. Archives
  4. Tags
  5. Search
  6. Links
  7. Disclaimer
  8. RSS
Featured image of post mysql insert into where not exists
MySql

mysql insert into where not exists

Apr 15, 2020
1 minute read

INSERT INTO [to] (name) SELECT name FROM [from] WHERE not exists (select * from [to] where [from].name = [to].name);

 

MySql PostgreSQL
Licensed under CC BY-NC-SA 4.0

Related content

分類測試

mysql 找每一個人的最後一筆紀錄

MYSQL 處理查詢結果

© 2020 - 2025 My Blog
Built with Hugo
Theme Stack designed by Jimmy