Forum

Notifications

Clear all

prevent duplication data uploaded to MySQL

(@elias)

Illustrious Member

Joined: 5 months ago

Posts: 4277

Topic starter 18/10/2024 7:10 pm

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

Quote

(@elias)

Illustrious Member

Joined: 5 months ago

Posts: 4277

Topic starter 18/10/2024 7:10 pm

you may
[list=1]

use unique keys

before insert triggers in the MySQL

write a program, maybe PHP, to perform Pre-Insert tasks

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

ReplyQuote

Share: