2.4k questions

2.4k answers

95.8k users

5 Online Users
0 Member 5 Guest
Today Visits : 1034
Yesterday Visits : 2653
Total Visits : 2354181

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

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

0 votes
66 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

Copyright © 2024 - Viktoria Katsanioti - All rights reserved. Russia, Kaliningrad, mail: matizegr@yahoo.com

Powered by Question2Answer
...