Hi, I download a csv file from Yahoo in this format:
ABIAX
20.63
2006-08-3
ACEIX
8.78
2006-08-3
CIGAX
10.08
2006-08-3
FSCTX
22.25
2006-08-3
GGOAX
20.55
2006-08-3
HWLAX
23.3
2006-08-3
HWMAX
28.74
2006-08-3
MLEIX
96.37
2006-08-3
NBPBX
18.98
2006-08-3
PSVIX
32.43
2006-08-3
PTRAX
10.3
2006-08-3
RGACX
30.89
2006-08-3
^DJI
11242.6
2006-08-3
^IXIC
2092.34
2006-08-3
^GSPC
1280.27
2006-08-3
My table for this data is in this format
| 2006-08-02 | 20.72 | 8.81 | 10.08 | 22.19 | 20.48 | 23.19 | 28.52 |
96.21 | 18.87 | 32.14 | 10.31 | 30.95 | 11199.93 | 2078.81 | 1278.55 |
Is there a way to get mysqlimport to pull the data from specific
column/row to insert into a specified field? Trying to find an easier
way than typing all of the data into a text file for import.
Thanks,
--
Jim Seymour <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
