Skip to content

Instantly share code, notes, and snippets.

@eklect

eklect/x.mysql

Created March 22, 2021 15:42
Show Gist options
  • Save eklect/a08bf7be1eaa3d0536b3eeb498bfc795 to your computer and use it in GitHub Desktop.
Save eklect/a08bf7be1eaa3d0536b3eeb498bfc795 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL → How to get/list tables of a database from Information Schema table
Raw
x.mysql
SELECT TABLE_NAME
FROM `INFORMATION_SCHEMA`.`tables`
where table_schema='YOUR_DATABASE_NAME_HERE';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment