prevent duplication data uploaded to MySQL

More
1 month 2 weeks ago #3334 by Elias
How do I prevent duplication data uploaded to MySQL database from a CSV or Excel file upload?

Please Log in to join the conversation.

More
1 month 2 weeks ago #3335 by Elias
Answered by Elias on question prevent duplication data uploaded to MySQL
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).

Please Log in to join the conversation.

Time to create page: 0.258 seconds