Hello All,

I have a question regarding Mysql query. Is it possible to insert if no duplicate found and if found, return the value. Something like, "insert into <table> values(..) on duplicate select a column in the record tht causes the duplication. Please let me know incase it is available. I dont want to run multiple queries to perform this.
Thanks in advance.

For example,

Table : N A B C All are unique, N- auto increment/primary key
so if we insert a record and if it is duplicate, is it possible to get the corresponding auto-incremented value for the record already existing?

Regards,
Bala

You get to do a "select", check whether or not it returned any rows and, if not, then do an "insert". It sounds like you might also wish to do this inside a transaction (so you can do a *second* "select", and roll back if another "insert" occurs concurrently).

PS:
And, of course, you might have the luxury of being able to add a "unique" constraint to the column(s) in question, assuring that you'll *never* have duplicates...

As you mentioned above, I defined the columns as unique and im using "select" to check this operation. But it is time consuming, because of our table has nearly 15million records. If there is duplicate while insert, mysql gives error with columns that caused duplicates, instead would it be possible to print the auto incremented column?

For example,

If if insert a record and if it is success then i can use last_insert_id() to get the auto incremented value.
Similarly, if my insert fails because of duplicate , is there any such function to return the already existing value? Just a thought. Because running select again to get that value takes much time .

Thanks and Regards,
Bala