change column name and make a unique column so we get no dupes.
No Answer is Posted For this Question
Be the First to Post Answer
What is MySQL?
Is mysql an oracle product?
What is a trigger in mysql?
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
which version of mysql can't support stored procedure??
how to find 2nd highest salary in random database salary of employer.....
What is the difference between mysql and pdo?
How to enter numeric values as hex numbers?
How do I delete a mysql user?
What is the datatype of image in mysql?
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
What is cast in mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)