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
- 4705 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
How do I change global variables in mysql?
What is key in mysql?
How to set mysql variable in php?
How do you rename a table in mysql?
Can mysql and mariadb coexist?
What is delimiter in mysql trigger?
What are the 'mysql' command line options?
How can you change the name of any existing table by using the sql statement?
What is the datatype of image in mysql?
Which statement is used to delete a table in MySQL.
How can you retrieve a particular number of records from a table?
How to use regular expression in pattern match conditions?
How do you backup a database in mysql?
How to get last inserted id after insert data from a table in mysql?
How to use sum function in where clause in mysql?
