Terminé

CSV to MySQL

I have a batch of CSV files that I download several times a day and would like to have them turned into MySQL tables. The first line of the CSV is headings and there could be as many as a couple hundred headings and 20,000 lines.

I would like the script to read the headings then decide what type of data is under each heading (varchar, int, dec, text…) and build the sql statement to create the table.

A PHP function would be great. Something that simply takes the name of the CSV file and the name I want the MySQL table to have. I'm thinking this is a quick and easy project. I have included a sample of a CSV. Again, there are several and each have different headings. The script needs to build the sql based on the headings in each CSV, but I can write the code that walks through the different files. I just need the function to do the work.

Questions? Please feel free to ask.

Thanks.

Compétences : MySQL, PHP

en voir plus : mysql free, free mysql, download mysql, need a quick mysql script, mysql read files, php csv sample, php create csv file, php table csv, mysql sql function, write mysql, table heading, batch file name, mysql create table data, table csv, csv text file, create tables sql 2012, free batch code, csv table, read csv file php write csv file, line csv, batch file read csv file, mysql batch, sql file csv, csv file code, php read write csv

Concernant l'employeur :
( 1 commentaire ) Roseburg, United States

Nº du projet : #2331767

Décerné à:

rsdsoftsl

Ready to create the script which converts CSV to MySQL table.

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(228 Commentaires)
7.2

27 freelance font une offre moyenne de $135 pour ce travail

toinnisfree

pls chk pmb

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(601 Commentaires)
8.0
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(252 Commentaires)
7.9
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(491 Commentaires)
7.5
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(53 Commentaires)
7.3
srinichal

I can deliver the PHP script

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(102 Commentaires)
7.1
adnanahsan

Hey there, i have checked your csv file, i will surely do this job for you with perfection, Lets get it done. Looking forward, Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(51 Commentaires)
7.0
creativeitechpvt

Dear Sir, we are able to complete this work with its innovative ideas and excellent customer service. we will make some different to your expectation. we are available via Skype, phone and e-mail and are always o Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(94 Commentaires)
6.6
LuigiWidmore

Hi sir , My name is Luigi Widmore and i'm an expert web developer. My areas are HTML/CSS PHP/MYSQL Design/Photoshop. I can deliver this project in 3 days or less. Please check PM for details , you may be impresse Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 999 jours
(79 Commentaires)
6.2
Alexod

I can do it

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(59 Commentaires)
6.1
Chtioui86

Hi, Please see your private msg TY

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(64 Commentaires)
6.0
herpay

Hello, I've already created similar scrpt and so I can make it within max 2 days after you accept my bid. Regards, Tamas

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(129 Commentaires)
5.5
acecoder84

Hello, Since I am expert of PHP and mysql I can fulfill your requirement. I am ready to start the project. Regards, Sadhan.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(32 Commentaires)
5.4
anhouse

Please find details of the proposal in your pmb

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(8 Commentaires)
5.5
sashamd

PHP/MySQL experience, timely delivery. Please check PMB.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(12 Commentaires)
5.0
prasy8

Hi there, Our preferred technology : PHP/Mysql, javascript, AJAX Charges: At least 40% in advance Ready to start asap. Let me know if you have any questions. Thanks, prasy

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(12 Commentaires)
4.8
ancosys

Hi, Please check pm. Thanks!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(29 Commentaires)
4.5
abupabuya

hi sir im ready to start

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(18 Commentaires)
4.5
muhmuuh

Hello! I think I have the right solution for you

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)
3.6
josevalencia

Hello Im a PHP expert let me do this work for you. It can be done in 24 hours. And you will be happy with the result.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
2.5
hirenow

Hi sir. I can do this. Plz check PM. You will get a good results. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(3 Commentaires)
1.6