duplicate record notification

[lipun4u]

In my database, after insertion of records, I want to know if the record inserted is duplicate or not. How can I do this ??

[Daniel0]

Why not just check if it exists before inserting?

[lipun4u]

that will be time consuming.

 

it returns 1062 error code(in my case....)

 

is this the universal error code for duplicate record insertion  ??

[Daniel0]

Yes, that error code means what you're trying to insert is a duplicate on a row that's supposed to be unique.

[nadeemshafi9]

In my database, after insertion of records, I want to know if the record inserted is duplicate or not. How can I do this ??

 

something like this, i bet someone comes up with a better idea biut

 

insert into ....

 

$last_id = mysql_insert_id();

 

$sql = "select count(*) as count from blah b1 where name = (select name from blah b2 where id = {$last_id}) "

[nadeemshafi9]

Why not just check if it exists before inserting?

 

lol, im getting there