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
- 4704 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
How do I select a table in mysql?
How to insert html code into mysql database using php?
Is postgresql better than mysql?
In which year mysql created?
What is mysql aggregate functions? Explain
What's the difference between mysql and sql server?
Is mysql still relevant?
What is the command line end user interface - mysql?
How can you create and drop view in mysql?
What is row level locking?
what is mysql optimization in brief?
What is a trigger? How you can create a trigger in mysql?
What is regexp?
what is the default port for mysql server? : Mysql dba
What is acid in mysql?
