Skip to content

Instantly share code, notes, and snippets.

@gotodeploy

gotodeploy/gist:8496809

Created January 18, 2014 21:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save gotodeploy/8496809 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save gotodeploy/8496809 to your computer and use it in GitHub Desktop.
Download ZIP
Get all table names (comma separated) from "database_name".
Raw
gistfile1.sql
SELECT GROUP_CONCAT(TABLE_NAME) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = "database_name";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment