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

Answers were Sorted based on User's Feedback



The structure of table view buyers is as follows: +----------------+-------------+------+-----+---..

Answer / guest

2346

Is This Answer Correct ?    4 Yes 0 No

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---..

Answer / amita

in first condition even though u deleted all the records
from the table it takes the next no. of last deleted record.
suppose there is 2000 records in the table then it will take
2001.
and in second condition the ans is 2346

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is mysql_pconnect?

0 Answers  


How do you connect MySQL database with PHP?

0 Answers  


How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

0 Answers  


List some mysql advantages and disadvantages?

0 Answers  


What is definer in mysql?

0 Answers  


What are triggers in mysql?

0 Answers  


about foregine

2 Answers  


How do I enable mysqli extension?

0 Answers  


Can varchar be primary key?

0 Answers  


Can you tell how many values can set the function of mysql to consider?

0 Answers  


What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

4 Answers   Aufait, CSS, Wipro,


What is the difference between BLOB AND TEXT?

0 Answers  


Categories