Skip to content

Instantly share code, notes, and snippets.

@hoodasaad

hoodasaad/Mysql -> Count From Big Table.txt

Last active June 11, 2018 21:27
Show Gist options
  • Save hoodasaad/dd4e72b2249d6390351930cf4be42d00 to your computer and use it in GitHub Desktop.
Save hoodasaad/dd4e72b2249d6390351930cf4be42d00 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql -> Count From Big Table
Raw
Mysql -> Count From Big Table.txt
SELECT `AUTO_INCREMENT` as 'count' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'mahmouda_million' AND TABLE_NAME = 'member'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment