Re: [PHP] Upload a CSV file to MySQL

2002-03-04 Thread Steven Deaton 

You may want to take a look at phpmyadmin, as it has this functionality.

- Original Message -
From: Philip J. Newman <[EMAIL PROTECTED]>
To: DL Neil <[EMAIL PROTECTED]>; Ben C. <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 11:15 AM
Subject: Re: [PHP] Upload a CSV file to MySQL


>
> - Original Message -
> From: "DL Neil" <[EMAIL PROTECTED]>
> To: "Ben C." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, March 05, 2002 8:04 AM
> Subject: Re: [PHP] Upload a CSV file to MySQL
>
>
> > Ben,
> >
> > > Is there an easy way to upload a CSV file into a MySQL table?  Is
> > there also
> > > a way to export the MySQL file into a CSV file?  I would like to make
> > a form
> > > using PHP to do import a CSV file into an existing table.  Any advise
> > would
> > > be appreciated.
> >
> >
> > Manual: 6.4.9 LOAD DATA INFILE Syntax
> >
> > Regards,
> > =dn
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Upload a CSV file to MySQL

2002-03-04 Thread Philip J. Newman 


- Original Message - 
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Ben C." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 8:04 AM
Subject: Re: [PHP] Upload a CSV file to MySQL


> Ben,
> 
> > Is there an easy way to upload a CSV file into a MySQL table?  Is
> there also
> > a way to export the MySQL file into a CSV file?  I would like to make
> a form
> > using PHP to do import a CSV file into an existing table.  Any advise
> would
> > be appreciated.
> 
> 
> Manual: 6.4.9 LOAD DATA INFILE Syntax
> 
> Regards,
> =dn
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 
> 




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Upload a CSV file to MySQL

2002-03-04 Thread DL Neil 

Ben,

> Is there an easy way to upload a CSV file into a MySQL table?  Is
there also
> a way to export the MySQL file into a CSV file?  I would like to make
a form
> using PHP to do import a CSV file into an existing table.  Any advise
would
> be appreciated.


Manual: 6.4.9 LOAD DATA INFILE Syntax

Regards,
=dn


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Upload a CSV file to MySQL

2002-03-04 Thread Dan Vande More 

I'm not sure if you're talking just PHP, but this is the best database tool
I've ever used:
http://anse.de/mysqlfront/
/*
Key-Features
With MySQL-Front you can...  
create/drop databases 
create/drop tables 
edit/add/delete fields 
edit/insert/delete records 
edit BLOBs and MEMOs with Bitmap/GIF/JPEG-Support 
view a list of server-variables 
view and kill other user-processes 
execute (large) SQL-scripts 
view advanced table-properties, such as Type, Comment, Key_Length and so on 
export table-structure and data into SQL-scripts or other databases 
replicate databases between two hosts ("Export tables...") 
save data to CSV-Files (ideal for working with MS-Excel ®) or HTML-tables 
copy CSV-data/HTML-Tables to clipboard 
copy tables to new table-names 
manage users (new in 2.0: edit existing users) 
flush Host/Logs/Privileges/Tables 
write SQL-queries with syntax-highlighting 
import data from ODBC-datasources 
do table-diagnostics (check, optimize, repair, analyze) 
and a lot more... 
*/

Dan
-Original Message-
From: Ben C. [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 11:30 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Upload a CSV file to MySQL


Is there an easy way to upload a CSV file into a MySQL table?  Is there also
a way to export the MySQL file into a CSV file?  I would like to make a form
using PHP to do import a CSV file into an existing table.  Any advise would
be appreciated.

Ben


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php