Re: Importing Data with Field Names

On Fri, 2009-03-20 at 13:46 -0700, 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] > > > > Not really, Unless you opt for a generic text type for every field, as mysql requires the field type to be specified when you create the table or add the field to an existing table Ash www.ashleysheridan.co.uk