How do I prevent duplication data uploaded to MySQL database from a CSV or Excel file upload?

Question

1 Answer

Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you, Elias Katsaniotis, MSc.

ekatsa · Answer 1 · 2022-05-16T06:39:15+0000

you may

use unique keys
before insert triggers in the MySQL
write a program, maybe PHP, to perform Pre-Insert tasks
maybe more

In one migration project from a Tailored Oracle Accounting System to SAP, I had done the insert using PRO*C programs for the export (where there were possible checks) and the Impor Utility of SAP).

How do I prevent duplication data uploaded to MySQL database from a CSV or Excel file upload?

Your answer

1 Answer

Categories