Get table names using SELECT statement in MySQL

by

To get the name of all tables use:

SELECT table_name FROM information_schema.tables;

To get the name of the tables from a specific database use:

SELECT table_name FROM information_schema.tables
WHERE table_schema="your_database_name";

Now, to answer the original question, use this query:

INSERT INTO table_name
    SELECT table_name FROM information_schema.tables
        WHERE table_schema="your_database_name";

For more details see: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

More Related Contents:

  1. Which ORM should I use for Node.js and MySQL? [closed]
  2. MySQL select all rows from last month until (now() – 1 month), for comparative purposes
  3. Can’t connect to RDS instance from EC2 instance
  4. Linux shell script for database backup
  5. How can a query multiply 2 cell for each row MySQL?
  6. Incorrect integer value: ” for column ‘id’ at row 1
  7. find number of rows in returned mysql result (nodejs)
  8. What is difference between storing data in a blob, vs. storing a pointer to a file?
  9. How to estimate SQL query timing?
  10. Rails select random record
  11. mysql select distinct rows into a comma delimited list column
  12. Access mysql running on localhost from minikube
  13. MySQL fulltext search – Only results that contain all words
  14. How to use `bcrypt` algorithm within `encrypt` function in MySQL for verifying password?
  15. MySQL query to select results with auto increment as a new column added in the result
  16. mysql UPDATE statement – overhead for same values?
  17. Select from same table as an Insert or Update
  18. How do I limit the number of rows per field value in SQL?
  19. MySQL: Left join and column with the same name in different tables
  20. MySQL scripts in docker-entrypoint-initdb are not executed
  21. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  22. How to import a csv file into MySQL workbench?
  23. How to get mysql random integer range?
  24. How to find nearest location using latitude and longitude from SQL database?
  25. Are Users ‘User’@’%’ and ‘User’@’localhost’ not the same?
  26. MySql – Update table using select statment from same table
  27. Optimizing MySQL for ALTER TABLE of InnoDB
  28. MySQL: SELECT from another server
  29. What is the jdbc driver “org.gjt.mm.mysql.Driver” for?
  30. How to allow fulltext searching with hyphens in the search query

Leave a Comment