×

Notice

The forum is in read only mode.

prevent duplication data uploaded to MySQL

More
3 months 2 days ago #3334 by Elias Katsaniotis,MSc
How do I prevent duplication data uploaded to MySQL database from a CSV or Excel file upload?
More
3 months 2 days ago #3335 by Elias Katsaniotis,MSc
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).
Time to create page: 0.092 seconds

Site Info

V. Katsanioti,

Russia,

Kaliningrad Oblast.

matizegr@yahoo.com

Visit counter

United States of America (the) 80.6% United States of America (the)
Russian Federation (the) 11.1% Russian Federation (the)
China 4.9% China

Total:

33

Countries
00001846
Today: 16
Yesterday: 55
This Week: 71
Last Week: 565
This Month: 1,766
Last Month: 81

Who's Online

We have 1427 guests and no members online