En cours

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

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.

85 $ USD en 1 jour
(228 Commentaires)
7.2

27 freelance ont fait une offre moyenne de 135 $ pour ce travail

toinnisfree

pls chk pmb

185 $ 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.

175 $ USD en 3 jours
(252 Commentaires)
7.9
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

200 $ 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

150 $ USD en 20 jours
(53 Commentaires)
7.3
srinichal

I can deliver the PHP script

200 $ 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

150 $ 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

165 $ 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

106 $ USD en 999 jours
(79 Commentaires)
6.2
Alexod

I can do it

250 $ USD en 7 jours
(59 Commentaires)
6.1
Chtioui86

Hi, Please see your private msg TY

100 $ 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

110 $ 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.

150 $ USD en 2 jours
(32 Commentaires)
5.4
anhouse

Please find details of the proposal in your pmb

150 $ USD en 3 jours
(8 Commentaires)
5.5
sashamd

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

80 $ 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

100 $ USD en 5 jours
(12 Commentaires)
4.8
ancosys

Hi, Please check pm. Thanks!

100 $ USD en 2 jours
(29 Commentaires)
4.5
abupabuya

hi sir im ready to start

60 $ USD en 2 jours
(18 Commentaires)
4.5
muhmuuh

Hello! I think I have the right solution for you

70 $ 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.

150 $ 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

99 $ USD en 4 jours
(3 Commentaires)
1.6