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
- 4812 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 foreign key indexed mysql?
Why use stored procedures in mysql?
What is the difference between char and varchar?
What is mysql connector used for?
How to enable or disable a row of a table using MySQL in struts?
How many types of indexes are there in mysql?
how to Return total number of rows.
Write a query to find duplicate rows in table?
What do you understand by mysql terminal?
How can we run batch mode in mysql?
How do I change the max connection in mysql?
What is the data source name for mysql?
What are the benefits of mysql?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
Can we save images in mysql database?
