Sunday, March 25, 2012

Can I duplicate data?

Hello guys! Is it possible to duplicate a primary key?

I would like my database to accept data with the same primary key.

Is it possible?

How do you declare ON DUPLICATE KEY UPDATE?

Please help me. Thanks in advance. Wink

Hello.

That is not possible nor suggestedSmile

If you want to use that particular field for something else (and it is obvous, because you want duplicate values in it):

- add new field of type int

- make it autoincrement (identity)

- make it primary key for table and remove old field from primary key

sql

No comments:

Post a Comment