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
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