Guest User

Untitled

a guest
Aug 15th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. MySQL INSERT IF NOT EXIST else DELETE row
  2. INSERT INTO wp_postmeta (post_id, meta_key) SELECT ?id, ‘page_title’
  3. FROM DUAL WHERE NOT EXISTS (
  4. SELECT meta_id FROM wp_postmeta WHERE post_id = ?id AND meta_key = ‘page_title’);
  5. UPDATE wp_postmeta SET meta_value = ?page_title WHERE post_id = ?id AND meta_key = ‘page_title’;
Add Comment
Please, Sign In to add comment