Importing Data with Field Names
| From: | revDAVE | Date: | Fri, 20 Mar 2009 20:46:39 +0000 |
| Subject: | Importing Data with Field Names | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-290439@lists.php.net to get a copy of this message | ||
Newbie...
I have phpmyadmin...
I'm basically looking for a quick way to import records and avoid hand-
typing many field names.... (I can set the field types later)
Is there a way to import into mySql with let's say a csv file - (or Tab
delimited file) and have the first row be the field names. Then might you be
able to import into a mysql database table (with / or without it's own
preexisting field names) and have the import auto-setup the field names from
the 1st row....?
BTW: let's assume the file has many fields and a small amount of records....
(no timeout issues)
I could use some help getting started with this....
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09]