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
- 4819 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
What are all the Common SQL Function?
How can we convert between Unix & MySQL timestamps?
Is mysql a server?
What is the purpose of mysql database?
Explain the difference between mysql and mysql interfaces in php?
How to include numeric values in sql statements?
What is a join? Explain the different types of mysql joins.
What is field in mysql?
Why use stored procedures in mysql?
What is difference between function and procedure in mysql?
What language is used in mysql?
How do I show all mysql databases?
What is the insert?
What is a crosstab query?
What is the difference between a heap table and temporary table?
