Fermé

MySQL: SQL Statement Help for Deduping, Merging Records, CSV Import

I have a rough MySQL DB schema designed and need help with writing SQL statements to:

1. Create tables

2. Upload CSV data (thousands of records)

3. Dedupe the uploaded data

4. Merge records based on rules

5. Provide the SQL Statements and help implementing for uploading more data at a later time

I have MySQL server running with Workbench on a local computer, so I can test your work on larger data sets. But you'll need your own dev environment.

Sample input data file, DB schema, and notations with sample data will be provided to winning bidder.

Compétences : Administration de Bases de données, Programmation de bases de données, MySQL, SQL

en voir plus : transfer data mysql sql server, windows mobile sql statement, sql statement excel, csv import mysql, mysql csv import, microsoft sql express csv import, creating php registration login mysql sql, mysql sql server oracle postgres, getafreelancer message sql query help needed, mysql sql server replication, decimal places oracle sql statement, update mysql records csv, creating csv file net sql statement large file, excel pivot table vb script, salon iris sql statement help, sql statement help, i need css help, i need layout help design outsourcing, i need marketing help, i need orifessionsl help writing a poem

Concernant l'employeur :
( 110 commentaires ) San Francisco, United States

Nº du projet : #17372596

22 freelance font une offre moyenne de $51 pour ce travail

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(153 Commentaires)
6.9
softcarve

Hi, I would like to 1. create your table structure. 2. clean data to remove the duplicates. 3. sql to upload the data later. Get in touch to discuss more. Available to start now. Regards, Manish

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(61 Commentaires)
5.4
mahmoudgamal008

I have more than 7 years of professional and practical experience in SQL, MySQL and database development. I have more than 1800 answers in Stackoverflow(Q&A Site) [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(40 Commentaires)
5.6
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(63 Commentaires)
5.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(8 Commentaires)
3.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
1.2
yassinekhaidouch

Hi friend I can do this work for you . we can discuss more over chat . I need to know more details about your mysql server ... for start working ...

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
1.3
lemarin68

Experienced DBA using SQL Server, PostgreSQL,Db2, Oracle, Mysql 8 years in a row. I have workked with phpadmin, Mysql Workbench, Mysql CLI,no problem to build a self working environment.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
1.2
seamantopcoder

MYSQL EXPERT HERE. Hi sir, i have developed my own sql called - YSQL from mysql opensource. So i have many experiences with sql and i am very interested in your project. Please let me discuss more and thanks.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
0.0
hfakoor22

Hi, I regularly perform complex T-SQL, MYSQL scripts for deduping, merging large datasets. I also modify large dat filed (used for uploads) using complex queries. Currently I'm an e-Discovery Analyst doing data mini Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
Tolfordtech

I am assuming that the csv upload piece is done and that all you need is to have the result of that de-duplicated. I live and work in the US. I'm available in the afternoon/evening of EST. I'm currently working at a te Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
sunishee3

As per the requirements of the project will complete the work in the given schedule. Have worked extensively in SAP Fieldglass on backends , transformation scripts and Sql Server DBs. Earlier worked with Oracle too.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
saroeunsaing

I want work as database design. i am strongly on database design an dot net framework . and i hope we will be able work together.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doin Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0