Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4803 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Is Mysql query is case sensitive?
Is mysql workbench a dbms?
How do you kill a long running query in mysql?
How do I clear a mysql database?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
How to use regular expression in pattern match conditions?
What is mysql ndb?
How we can get the current date in mysql?
How do you create a schema?
Is mysql a server?
How do I edit a stored procedure in mysql?
How to create table with same structure of student table in mysql?
what is the default port for mysql server? : Mysql dba
Is mariadb faster than mysql?
How to check server status with 'mysqladmin'?
