Skip to content

Instantly share code, notes, and snippets.

@buithehoa

buithehoa/count-the-number-of-tables-in-the-current-mysql-database

Created April 2, 2019 04:02
Show Gist options
  • Save buithehoa/45a4a540b7571daa251ecfb53d8d862e to your computer and use it in GitHub Desktop.
Save buithehoa/45a4a540b7571daa251ecfb53d8d862e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
count-the-number-of-tables-in-the-current-mysql-database
select count(*) from information_schema.tables where table_schema = database();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment