2.4k questions

2.4k answers

99.2k users

3 Online Users
0 Member 3 Guest
Today Visits : 3110
Yesterday Visits : 2217
Total Visits : 2495640

Categories

Notice

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

Information

Viktoria Katsanioti,

Kaliningrad,

Russia,

matizegr@yahoo.com

0 votes
72 views

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

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 (46.5k points)
reshown by
...