Guest User

Untitled

a guest
Jun 21st, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. INSERT IGNORE INTO building_access (employee_id, b0, b12, b13, b14, b15, b16)
  2. SELECT * FROM (SELECT '102OSI', '1', '0', '1', '0', '1', '0') AS tmp
  3. WHERE NOT EXISTS ( SELECT employee_id FROM building_access WHERE employee_id = '102OSI' ) LIMIT 1;
Add Comment
Please, Sign In to add comment