Home > IT Answers > Linux > How to import simple spreadsheet into mysql database?
Ingram87
1,285 pts.
 How to import simple spreadsheet into mysql database?
Linux databases, MySQL, MySQL Community Edition, MySQL Database
I have a simple spreadsheet (only 2 columns) that I need imported into a mysql database. I can convert the spreadsheet into whatever format I need to (comma delimited), but I need the mysql commands that will import it. Does anybody know how to do this?

Software/Hardware used:
mysql, linux
ASKED: February 11, 2011  2:49 AM
UPDATED: February 12, 2011  2:16 AM
RELATED QUESTIONS
Answer Wiki:
You could use the <a href="http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html">LOAD DATA statement</a>. Alternatively, you could use the <a href="http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html">mysqlimport client</a>.
Last Wiki Answer Submitted:  February 11, 2011  2:52 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Yes, that’s what I’m looking for. Thanks

Ingram87
 1,285 pts.