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.
Hello.
That is not possible nor suggested
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