code_junkie

What's the most efficient way to check the presence of a row in a table

Nov 13th, 2011
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. SELECT * FROM table WHERE id=5
  2. SELECT id FROM table WHERE id=5
  3.  
  4. SELECT COUNT(*) FROM table WHERE id=5
  5.  
  6. SELECT COUNT(1) FROM mytable WHERE id = 5
  7.  
  8. SELECT id FROM table WHERE id=5 LIMIT 1
  9.  
  10. SELECT null FROM table WHERE id = 5 LIMIT 1;
  11.  
  12. SELECT 1 FROM table WHERE id = 5 LIMIT 1;
Add Comment
Please, Sign In to add comment