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