Re: Export from a spreadsheet to mysql
To export all the tables in a database as tab-separated files do this:
mysqldump -u username -p -T /directory_name db_name
Data for each table will be stored in a file named "table_name.txt" in the "directory_name" directory. The appropriate table file can be imported into a spreadsheet programme. Some programmes, like OpenOffice Calc, require that you first change the file extension to "csv" before importing.
Subject
Views
Written By
Posted
73568
August 25, 2006 09:50AM
42589
August 28, 2006 02:14PM
29178
December 07, 2006 03:39PM
21088
March 08, 2007 06:00AM
Re: Export from a spreadsheet to mysql
22410
April 06, 2007 02:20PM
15579
April 06, 2007 03:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.