How do you insert a table?
No Answer is Posted For this Question
Be the First to Post Answer
How to return query output in html format?
Where is the mysql data directory?
How to do login in mysql with unix shell.
if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?
How can I connect mysql database?
What is innodb mysql?
What is the role of a limit in a mysql query?
What do you understand by mysql terminal?
What are the types of queries?
how can you test for null values in a database? : Mysql dba
How do I copy an entire mysql database?
The 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