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:<br>
<br>
LOAD DATA INFILE 'data.txt' INTO TABLE table2 FIELDS TERMINATED BY ',';<br>
<br>
merely responded with <br><br>ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES)<br><br>Those are the methods I've attempted thus far, if you can correct my form or suggest a different strategy I would welcome it.
<br><br> -jordan<br><br><div><span class="gmail_quote">On 5/9/06, <b class="gmail_sendername">Jordan Peacock</b> <<a href="mailto:hewhocutsdown@gmail.com">hewhocutsdown@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>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).
<br><br>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 <a href="http://www.webdevelopersnotes.com/tutorials/sql/mysql_course_inserting_data_in_mysql_tables.php3" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.webdevelopersnotes.com/tutorials/sql/mysql_course_inserting_data_in_mysql_tables.php3</a> and the sample table works great. The author used a .dat text file with the data in this format;<br><br>INSERT INTO employee_data (f_name, l_name, title, age, yos, salary, perks, email) values ("John", "Hagan", "Senior Programmer", 32, 4, 120000, 25000, "
<a href="mailto:john_hagan@bignet.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">john_hagan@bignet.com</a>");
<br>INSERT INTO employee_data (f_name, l_name, title, age, yos, salary, perks, email) values ("Ganesh", "Pillai", "Senior Programmer", 32, 4, 110000, 20000, "<a href="mailto:g_pillai@bignet.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
g_pillai@bignet.com</a>");<br><br>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.
<br><br>Any suggestions as to what to use?<br></div><div><span class="sg"><br> -jordan<br>
</span></div></blockquote></div><br>