Re: Importing Data with Field Names
| From: | Jim Lucas | Date: | Sat, 21 Mar 2009 00:34:51 +0000 |
| Subject: | Re: Importing Data with Field Names | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-290458@lists.php.net to get a copy of this message | ||
revDAVE wrote:
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]Navicat will allow you to import and have the table created automagically by using the first row of the file as the column names. http://www.navicat.com/