[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    Re: loading mysql data
From:       Corey Schuhen <cschuhen () ozemail ! com ! au>
Date:       2001-07-01 0:12:30
[Download RAW message or body]


I think there is  You can use mysqldum that comes with the mysql clients like:

mysqldump --tab=. -u MySQL_User -pMySQL_Password Database
  
This will create a .sql and .txt file for each table in the database. By 
default this will be Tab seperated which I think Kspread can import but this 
can be changed to coma seperated etc. look at mysqldump --help It is quite 
powerful.

Corey


On Fri, 29 Jun 2001 19:34, Michael Baxter wrote:
> Dear koffice,
>                   Thanks for the k system - its great.
>
>                   My only problem with it is that I need to load data
> output from a mysql select -> file into a spreadsheet. Kspread would be
> terrific. Is there a way to do this?
>
>                         Thanks,
>                               mickb.

[prev in list] [next in list] [prev in thread] [next in thread]