The structure of table view buyers is as follows: +----------------+----------

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

Question Posted / pranab

2 Answers
4835 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---..

Answer / guest

2346

Is This Answer Correct ?

4 Yes

0 No

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---..

Answer / amita

in first condition even though u deleted all the records
from the table it takes the next no. of last deleted record.
suppose there is 2000 records in the table then it will take
2001.
and in second condition the ans is 2346

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More MySQL Interview Questions

how to delete duplicate rows in sql server 2005?

2 Answers EWIT, Reliance,

How do I change mysql password?

0 Answers

What are the other commands to know the structure of table using MySQL commands except explain command?

2 Answers SigmaTree,

What is the datatype for password in mysql?

0 Answers

what programming language which is used for testing and developement in sql?

3 Answers

What is a storage engine?

0 Answers

How can I see mysql database?

0 Answers

What is auto increment in mysql?

0 Answers

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers

How many sql ddl commands are supported by 'mysql'?

0 Answers

What is a storage engine? What are the differences between innodb and myisam engines?

0 Answers

What is unsigned in mysql?

0 Answers

For more MySQL Interview Questions Click Here