Skip to content

Instantly share code, notes, and snippets.

@samqiu
Created December 21, 2011 02:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samqiu/1504240 to your computer and use it in GitHub Desktop.
Save samqiu/1504240 to your computer and use it in GitHub Desktop.
哪个更快
SELECT * FROM `post` WHERE `status` != 'inherit' AND `status` != 'auto-draft';
SELECT * FROM `post` WHERE `status` NOT IN ('inherit', 'auto-draft');
@samqiu
Copy link
Author

samqiu commented Dec 21, 2011

哪个效率更高

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment