×

Notice

The forum is in read only mode.

prevent duplication data uploaded to MySQL

  • Elias
  • Elias's AvatarTopic Author
  • Offline
  • Administrator
  • Administrator
More
5 months 2 weeks ago#3334by Elias
How do I prevent duplication data uploaded to MySQL database from a CSV or Excel file upload?
  • Elias
  • Elias's AvatarTopic Author
  • Offline
  • Administrator
  • Administrator
More
5 months 2 weeks ago#3335by Elias
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.107 seconds

Contact

Site Info

V. Katsanioti,

Russia,

Kaliningrad Oblast.

matizegr@yahoo.com

Visit counter

United States of America (the)70.0%United States of America (the)
Russian Federation (the)14.6%Russian Federation (the)
China10.2%China

Total:

44

Countries
00004710
Today:41
Yesterday:61

Who's Online

We have 81 guests and no members online