how to view data in a table: MySQL tutorial Exploring tables




To get SQL to explain a table showing all the columns and their datatypes you can use the following code: EXPLAIN tableName; For example EXPLAIN products …

Original source