MySql Geeks

I need a bit of help. I am importing a CSV list into a new table using phpmyadmin. How can I tell it to use the first row as the header column names?

never mind, by the time I get an answer, I can just manually enter the headers and reimport the file... Thanks anyway though. If you wanna go ahead and tell me for the next time?

This is not a MySQL specific thing as you can't tell mysql to do that. Thats the job of the program that is doing the importing. In your case, phpMyAdmin.

When you select CSV as the file type to import, there should be a option to do that. In my copy of phpMyAdmin, it is a check box that reads. The first line of the file contains the table column names (if this is unchecked, the first line will become part of the data)

Ok, I looked for that. If you have a specific table open in a db, then select import, you can create a new table .. BUT .. the option to use the first row as a header is not there. If you click on the import button from the initial database menu, the line appears.  go figger. Thanks Deano

Not sure if this will help in your case, but I've used this a lot recently.

http://www.withdata.com/csv/csv-to-sql/index.html

My newest problem is the date isn't converting properly. I'm ending up with all zeros on 3 date fields I have in the data. I think I got it worked out though. I'm changing the column to varchar to get the data into the table, then I can use a script to correct the date info. Once that's done, I can change the data type back to datetime.

Frikkin learnin way too much today but I found a very cool new app for building web application websites. It's called the Iron Speed Designer. Very powerful (and expensive, but what the hell). I've been playin around with it a bit... damned impressive.