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
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 |
What is mysql_pconnect?
How do you connect MySQL database with PHP?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
List some mysql advantages and disadvantages?
What is definer in mysql?
What are triggers in mysql?
about foregine
How do I enable mysqli extension?
Can varchar be primary key?
Can you tell how many values can set the function of mysql to consider?
What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?
What is the difference between BLOB AND TEXT?