Jump to content

i dont understand "insertion unsuccesfulDuplicate entry '0' for key 1"


zachary

Recommended Posts

If you are getting this kind of Error

#1062 - Duplicate entry '5' for key 1 

You cannot insert same value in the filed which has primary key. It must be unique.

 

Normally, an error occurs when you try to INSERT or UPDATE a row that causes a primary key, unique key, or foreign key violation. If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the statement. If you are using a non-transactional storage engine, MySQL stops processing the statement at the row for which the error occurred and leaves any remaining rows unprocessed.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.