What are the other commands to know the structure of a table using mysql commands except explain command?
- 1 Answers
- 1135 Views
- I also Faced
- E-Mail Answers
Answer Posted / Surjeet Kumar Jha
To know the structure of a table in MySQL, you can use the DESCRIBE or SHOW COLUMNS FROM command instead of the EXPLAIN command. The DESCRIBE command provides a human-readable description of the table's columns, while SHOW COLUMNS FROM displays more detailed information about each column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
