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
- 4927 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 to rename an existing table in mysql?
What does mysql workbench do?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
How do I update a variable in mysql?
How can you find out the version of the installed mysql?
What is definer in mysql trigger?
What is datatype in mysql?
What is session variable in mysql?
What is an index? How can an index be declared in mysql?
What is a crosstab query?
How do I create a database in mysql workbench?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What is the difference between float and double?
What is the use of i-am-a-dummy flag in mysql?
How do I switch users in mysql?
