2.4k questions

2.4k answers

96.7k users

11 Online Users
0 Member 11 Guest
Today Visits : 2567
Yesterday Visits : 1939
Total Visits : 2378520

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
68 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
...