SQL Database Records Updating

Замовник: AI | Опубліковано: 20.11.2025

I maintain an SQL-based system that receives new records every week, and I need those incoming values inserted, amended, or deleted accurately in the live tables. The work is pure data entry—no query design or analytics—just ensuring that the data I provide in CSV format is reflected exactly in the SQL database. You will connect through a secure VPN to a MySQL instance (PostgreSQL skills are equally welcome; the syntax is nearly identical for the commands you’ll run). The job involves: • Importing each CSV file to a temporary table. • Running the supplied UPDATE, INSERT, and DELETE statements or executing them manually if needed. • Verifying row counts against the source file to confirm nothing is missed. • Sending me a quick confirmation log once the session is finished. Acceptance criteria 1. All rows from the source file appear in the correct production tables. 2. No duplicate primary keys or foreign-key violations. 3. Confirmation log shows start/finish time and affected row counts. I provide clear CSVs, credentials, and a short SQL script outline; you provide accuracy and a fast turnaround.