What are the other commands to know the structure of table using MySQL commands except explain command?
2 6506The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id
2 3923
Can we rename database in mysql?
How to filter data from a mysql database table with php?
What is mysql common?
Is sql and mysql same?
How can we encrypt and decrypt a data presented in a table using mysql?
How do you rename a procedure in mysql?
How do you flush privileges?
How much does mysql cost?
What are the limitations of mysql?
How to convert character strings to dates?
How to create a trigger in mysql?
what is database black box testing? : Mysql dba
Where is the myisam table stored?
How do you stop an access query?
How do I tune a mysql query?