[SC.LUG] More MySQL (than you'd care to shake a stick at!

[nev]

hi

i found this lil program on the net which will connect to a mysql database AND
let you import a csv file!

hopefully this will do what you need :) its trial version software though,
limited to 30 days, and its for windoze only, but i seem to remember thats
what you wanted. you can download it from www.webyog.com

hope this helps

nev


> 
> I thought of doing it that way, but unfortunately the table in 
> question has about 6000 rows of data in it and not a sql file itself 
> but instead the raw data to be inserted into the (already created) 
> table. Therefore, unless there's a really quick and automated way of 
> converting to the above, I'd rather not have to amend the file for 
> all records! eg the first couple of records:
> 
> "Abbey Dore","Herefs","Holy Trinity & S Mary",6.00,,,"9¼cwt in 
> Aflat. Anti-clockwise. SO387303" "Abbots Bromley","Staffs","S 
> Nicholas",8.00,,,"11-1-5 in G. Tue SK079245" "Abbots Langley",
> "Herts","S Lawrence",6.00,,,"9-2-25 in F#. Mon TL095022" "Abbots 
> Leigh","Som","Holy Trinity",6.00,,,"14cwt in F#. Thu ST544740" 
> "Abbotsbury","Dorset","S Nicholas",6.00,,,"9-3-1 in G#. Wed 
> SY577852" "Abbotsham","Devon","S Helen (GF)",6.00,,,"10-3-22 in G. 
> Wed SS424264"
> 
> (this is just a practice exercise, I don't actually need to upload 
> this table as I've done this form the commandline - I just want to 
> know how I can take the same data in via phpmyadmin as this is how 
> my ISP works (or doesn't in this instance!!!)
> 
> Any ideas?
> 
> Ta Simeon
> 
> _______________________________________________
> SC mailing list
> SC at mailman.lug.org.uk
> http://mailman.lug.org.uk/mailman/listinfo/sc