0 votes

How do I prevent duplication data uploaded to MySQL database from a CSV or Excel file upload?
in General by (36.4k points)
reshown by | 31 views

1 Answer

0 votes

you may

  1. use unique keys
  2. before insert triggers in the MySQL
  3. write a program, maybe PHP, to perform Pre-Insert tasks
  4. 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).

by (36.4k points)
reshown by

1.8k questions

1.8k answers

85.0k users

6 Online Users
0 Member 6 Guest
Today Visits : 756
Yesterday Visits : 3892
Total Visits : 2009171
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.
1,829 questions
1,840 answers
85,034 users
@ 2022 V Katsanioti ,All rights reserved