ignore mysql duplicate data insert if no duplicate data

Asked 2 years ago, Updated 2 years ago, 42 views

Hello, I'm a beginner at mysql.

c# is currently using mysql. I feel difficult and ask for advice while doing it, so I ask for advice.

The data in the DB is being updated, ignored, and if not, INSERT. There may be content 1 in category 100,101, but content 1 should not be duplicated in category 100. It is necessary because the categories 100 and 101 are always overlapped whenever INSERT is done.

Thank you.

mysql

2022-09-22 08:40

1 Answers

If the category and content are keyed, I think we can use on duplicate key update. (Oracle has something called merge, but...)) http://choija.tistory.com/m/9


2022-09-22 08:40

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.