Tuesday, June 21, 2016

How to show table structure on MySQL

You can get records from a table using 'SELECT' statement on MySQL, but what about getting the structure of the table itself?

To get table structure on MySQL, you can use 'DESCRIBE' command/statement, like this:

DESCRIBE [table name]
Example:
DESCRIBE employee
DESCRIBE users

No comments:

Post a Comment