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 |
How would concatenate strings in mysql?
What is longblob?
How is mysql database stored?
How can you see all indexes defined for a table?
how to find 2nd highest salary in random database salary of employer.....
Where is the mysql config file?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
What is the main different between Null and NOT Null. Difference between Primary and Unique Key. How to Check the database from which application is it possibe.
What is delimiter $$?
How many rows can a mysql table hold?
Is mysql free software?
How do I view a mysql database?