How to get a list of columns in an existing table?
Answer / Saurabh Agarwal
To get a list of columns (schema) for an existing table in MySQL, run the following command: DESCRIBE table_name;
| Is This Answer Correct ? | 0 Yes | 0 No |
How to shut down the server with 'mysqladmin'?
How can you change the name of any existing table by using the sql statement?
How do I start and stop mysql server?
Why MySQL is used?
how to connect a php script with the mysql database?
Does mysql automatically index foreign keys?
Where is mysql used?
What is the difference between char and varchar data types?
Is mysql open source?
What is prepare statement in mysql?
How database are managed?
How to use rank function in mysql?
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)