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
- 2 Answers
- 3959 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
2346
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to create a table index in mysql?
How many queries can mysql handle?
How to enter Characters as HEX Numbers?
How to delete the repeated records from a table?
How do I tune a mysql query?
How to enter microseconds in sql statements?
What is mysql protocol?
What is 'mysqlcheck'?
What are the functions of commit and rollback statements?
What is 'mysqldump'?
What's the difference between mysql and sql server?
What is mysql command line?
What is sql vs mysql?
What is datatype in mysql?
What is the password of mysql?
