Hi I am creating a excel csv file to import some data into a table through phpmyadmin.
I have some questions regarding this.
In my excel file do I have to have a column for each table field, I am only inserting to half of the fields as the other half are automatically generated.
The table that I am importing into has a field which automatically generates a unique primary key - do I leave this field out from the csv?
I would appreciate any tips, thanks in advance
creating a csv to import data
Moderator: General Moderators
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact:
- dibyendrah
- Forum Contributor
- Posts: 491
- Joined: Wed Oct 19, 2005 5:14 am
- Location: Nepal
- Contact:
This URL will also help you regarding loading csv and other text files.
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html