Skip to content

Instantly share code, notes, and snippets.

@aannganyelne

aannganyelne/select_all_table_name.sql

Created September 27, 2022 12:49
Show Gist options
  • Save aannganyelne/bf131ba753bbd055ef7f46c5f3c2b510 to your computer and use it in GitHub Desktop.
Save aannganyelne/bf131ba753bbd055ef7f46c5f3c2b510 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Select All Table Name
Raw
select_all_table_name.sql
SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'database_name'
ORDER BY table_name ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment