What are the other commands to know the structure of table
using MySQL commands except explain command?
Answers were Sorted based on User's Feedback
show create table tbl_name;
eg:- show create table tbl_data;
| Is This Answer Correct ? | 8 Yes | 1 No |
Is mysql open source?
What is mysql and how it works?
Explain triggers and stored procedures?
What is msql?
What are the non-standard sql commands supported by 'mysql'?
What are the 'mysql' command line options?
What different Stored Objects are supported in MySQL?
Why phpmyadmin is used for mysql?
What is a text delimiter?
What is longblob?
Which storage engine is best in mysql?
How do I edit a table in mysql workbench?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)