Connecting Tech Pros Worldwide Forums | Help | Site Map

easiest way to upload a file to a MySql database

windandwaves
Guest
 
Posts: n/a
#1: Jul 17 '05
Hi Folk

I want my clients to load up a file to a MySql database. The file should
contain rows with

name, email, address, city

What would be the easiest way (in terms of the big picture), to get them to
upload it and put it in a mysql database?

Just let me know if you have any hints on how to go about this? (should
they use excel, or a text file, do you reject the whole file if there is an
error, etc... etc....)

TIA

- Nicolaas





Tim Van Wassenhove
Guest
 
Posts: n/a
#2: Jul 17 '05

re: easiest way to upload a file to a MySql database


On 2005-07-17, windandwaves <winandwaves@coldmail.com> wrote:[color=blue]
> Hi Folk
>
> I want my clients to load up a file to a MySql database. The file should
> contain rows with
>
> name, email, address, city
>
> What would be the easiest way (in terms of the big picture), to get them to
> upload it and put it in a mysql database?
>
> Just let me know if you have any hints on how to go about this? (should
> they use excel, or a text file, do you reject the whole file if there is an
> error, etc... etc....)[/color]

Read http://dev.mysql.com/doc/mysql/en/load-data.html

--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>
Closed Thread