How to get database structure in MySQL via query

by

I think that what you’re after is DESCRIBE

DESCRIBE table;

You can also use SHOW TABLES

SHOW TABLES;

to get a list of the tables in your database.

More Related Contents:

  1. Create a Cumulative Sum Column in MySQL
  2. Equivalent of explode() to work with strings in MySQL
  3. 1064 error in CREATE TABLE … TYPE=MYISAM
  4. mysql select dynamic row values as column names, another column as value
  5. Access denied for user ‘root’@’localhost’ (using password: YES) (Mysql::Error)
  6. MySQL DELETE FROM with subquery as condition
  7. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  8. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  9. Simple Random Samples from a Sql database
  10. node.js mysql error: ECONNREFUSED
  11. Relational database design multiple user types
  12. MySQL Select Date Equal to Today (having datetime as the data type)
  13. Count table rows
  14. mysql root password forgotten
  15. How to deploy local MySQL database to Heroku
  16. Should I use MySQL blob field type?
  17. How to lock a single row
  18. MySQL Cannot drop index needed in a foreign key constraint
  19. MySQL Insert & Joins
  20. Does MySQL overwrite a column of same value on update?
  21. How to join two tables using a comma-separated-list in the join field
  22. mysql like performance boost
  23. MySQL selecting yesterday’s date
  24. Does MySQL included with MAMP not include a config file?
  25. How do I write an SP in phpMyAdmin (MySQL)?
  26. ALTER TABLE ADD COLUMN takes a long time
  27. Creating MYSQL Procedure in Laravel 4 Migrations
  28. MySQL: Computed Column
  29. Mysql server does not support 4-byte encoded utf8 characters
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment