Also, I have been googling for other methods or scripts; several described
php solutions, but I'm running mysql locally on my machine without php, and
the mysql command:
LOAD DATA INFILE 'data.txt' INTO TABLE table2 FIELDS TERMINATED BY ',';
merely responded with
ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using
password: YES)
Those are the methods I've attempted thus far, if you can correct my form or
suggest a different strategy I would welcome it.
-jordan
On 5/9/06, Jordan Peacock <hewhocutsdown at gmail.com> wrote:
>
> I have an OpenDocument spreadsheet file which I've been using as a very
> (very very) basic personal database, and I'm trying to expand some of the
> features (namely being able to bring up different sets of matching records
> at my whim).
>
> I've exported the data to a .csv text file but I'm at a loss as to how to
> parse the file to get it into the right format. I've been following
> http://www.webdevelopersnotes.com/tutorials/sql/mysql_course_inserting_data_in_mysql_tables.php3and the sample table works great. The author used a .dat text file with the
> data in this format;
>
> INSERT INTO employee_data (f_name, l_name, title, age, yos, salary, perks,
> email) values ("John", "Hagan", "Senior Programmer", 32, 4, 120000, 25000, "
> john_hagan at bignet.com");
> INSERT INTO employee_data (f_name, l_name, title, age, yos, salary, perks,
> email) values ("Ganesh", "Pillai", "Senior Programmer", 32, 4, 110000,
> 20000, " g_pillai at bignet.com");
>
> For me to do the same (for thousand of records by hand) is ludicrous and
> error-prone. But I'm not sure how I am to automate the process of separating
> each record and then pulling it back together into a 'INSERT INTO data ()
> values ();' format.
>
> Any suggestions as to what to use?
>
> -jordan
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mn-linux.org/pipermail/tclug-list/attachments/20060509/a81a9616/attachment.htm