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 |
What is the use of indexing table?
What is mysql gpl?
what is collation? how many types of installations in sql server?
How do I export mysql query results to excel?
How to convert numeric values to character strings?
How do you create a primary key?
What is the difference between truncate and delete?
How can we encrypt and decrypt a data presented in a table using mysql?
What is the use of mysqli_num_rows?
What are the common mysql functions?
Explain advantages of MyISAM over InnoDB?
what is database black box testing? : Mysql dba
Oracle (3253)
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)