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
- 4752 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
Is pdo faster than mysqli?
What is delimiter $$?
Which is faster mongodb or mysql?
How to include comments in sql statements?
Is blocked because of many connection errors mysql?
How do I install mysql workbench?
What is the difference between myisam dynamic and myisam static in mysql?
What is pdo connection?
What is striped backup
Is mariadb better than mysql?
What is pragma exception?
Why do we use views instead of tables?
What command is used to delete the data from the table without deleting the table structure?
How can you see all indexes defined for a table?
How to delete an existing column in a table?
