Simple CSV import to MySQL

[johnsmith153]

I am simply importing a CSV file to MySQL.

 

Somebody has given me a CSV file and imagine fields are Name and Age it is like this:

 

jim-brown,32

dave-smith, 25

bob-roberts,19

 

...surely it would be easier to do

 

"Jim Brown", 32

"Dave Smith", 25

"Bob Roberts", 19

 

..or am I missing something, would these be capitalised and the dash removed on import??

 

Thanks.

[WebStyles]

CSV files are comma seperated, so you can have spaces too:

 

Jim Brown,32

Dave Dmith,25

Bob Roberts,19

 

would be perfectly valid

[johnsmith153]

So what with the jim-brown thing?

[TOA]

The dash may or may not be needed depending on your setup. If you need to store first name in one field and last in another, the dash is needed to parse out the pieces, otherwise if you are storing them in one field, it would not.