|By M. Crane (Craniac) on Tuesday, April 19, 2005 - 05:04 pm:|
Anyone want to walk me through using "mysqlimport" to do the above? Where's our crazy swedish mysql expert????
I tried using LOAD INFILE but got strange errors.
|By John Massaglia (Mrklaw) on Thursday, April 21, 2005 - 12:28 pm:|
ick, I would export the excel spreadsheet into a tab or comma-delimited file. Once you have a delimited text file, I'm sure that it's much easier to import into mysql.
|By John Massaglia (Mrklaw) on Thursday, April 21, 2005 - 12:30 pm:|
you've probably searched, but here is a tutorial on how to import excel into mysql
How to import Excel Access or XML data into MySQL database by using a MySQL Client Tool – Navicat?
|By M. Crane (Craniac) on Saturday, April 23, 2005 - 12:15 am:|
I used the following mysql command from the prompt. I had forgotten to convert the file to unix line endings, which through me off, but it's something like:
basically, the LOAD INFILE LOCAL DATA imports it correctly. With phpmyadmin running to mod the table, the searches you can do are awesome!
|By M. Crane (Craniac) on Saturday, April 23, 2005 - 08:25 pm:|
Here's the actual line, which I'll put here for future reference some day:
LOAD DATA LOCAL INFILE "f2.txt" INTO TABLE f2005 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';
I totally want to be a database/php geek now.
|By Tim Tate (Tatertot) on Monday, April 25, 2005 - 11:09 am:|
them's good referencin' thangs.
|By M. Crane (Craniac) on Monday, April 25, 2005 - 01:26 pm:|
Hey Tim, I'll be in Portland in early May. I've never posted the last two ST projects that I took pictures of in Portland, I just realized. Hopefully Wacky Willy's is still around. I'll keep an eye out for you and try to give any scooter riders a wide berth.
|By Tim Tate (Tatertot) on Monday, April 25, 2005 - 05:23 pm:|
that reminds me:
|By M. Crane (Craniac) on Tuesday, April 26, 2005 - 05:53 pm:|
You are a rock star!
200cc seems like a lot of engine for a scooter.
|By John Massaglia (Mrklaw) on Tuesday, April 26, 2005 - 11:59 pm:|
sweet pics. I wish I could blow it up more. I like the rack on the back of your Lambretta and that fenderlight is hot!
|By Larry Smilg (Larrys) on Friday, April 29, 2005 - 12:23 am:|
Tim, we are very different places - That's my house on the left in the picture.
Me, not so much a rock star.
|By Tim Tate (Tatertot) on Friday, April 29, 2005 - 11:18 am:|
But your house is!
Yes, 200cc is a large scooter engine, but I need it to haul my fat ass around. I'm hoping one day to add a 235cc kit and performance pipe to it.
|By Jay Townsend (Artdog) on Friday, April 29, 2005 - 01:21 pm:|
Good lord man, in the Washington DC area that house would sell for $1M...