As for programming skills, I'm pretty familiar with Java so I feel sure I
could write a suitable utility with that. In fact, unless I had a really
urgent need, I would prefer to write my own stuff just because I like
writing code
If you wanted to go the java route I suggest checking out
At 11:02 AM 8/20/2004, you wrote:
Ok. I'm looking into alternatives. I'm trying to figure out an alternative
to mysql exporting into xls file. Is there any another way you can export
into file and make it readable? What format do you use? I'm open to ideas
from experienced database programmers :)
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: 'Mysql ' (E-mail) [EMAIL PROTECTED]
Sent: Friday, August 20, 2004 12:02 PM
Subject: Brainstorming' time!
Ok. I'm looking into alternatives. I'm trying to figure out an alternative
to mysql exporting into xls file. Is there
Use Perl:
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.04/lib/Spreadsheet/WriteExcel.pm
use strict;
use warnings;
use DBI;
use Spreadsheet::WriteExcel;
my ($user, $pass, $db, $table) = ('foo', 'bar', 'test', 'users');
my $dbh = DBI-connect(DBI:mysql:database=$db, $user, $pass);
.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 11:30 AM
To: Scott Hamm; 'Mysql ' (E-mail)
Subject: Re: Brainstorming' time!
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: 'Mysql ' (E-mail) [EMAIL PROTECTED]
Sent: Friday
- Original Message -
From: Freddie Sorensen [EMAIL PROTECTED]
To: 'Rhino' [EMAIL PROTECTED]; 'Scott Hamm'
[EMAIL PROTECTED]; ''Mysql ' (E-mail)' [EMAIL PROTECTED]
Sent: Friday, August 20, 2004 2:28 PM
Subject: AW: Brainstorming' time!
Rhino
| Get the free DBTools DBManager Pro from
|
You could export the file as xml with either '--xml'
or '-X':
mysql --xml -u username -p db_name dbfile.xml
http://dev.mysql.com/doc/mysql/en/mysql.html
HTH,
James
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: 'Mysql ' (E-mail) [EMAIL PROTECTED]
Sent: Friday,
PROTECTED]
Sent: Friday, August 20, 2004 1:24 PM
Subject: RE: Brainstorming' time!
Ok unless I missed something here, wouldn't you just use the SELECT ...
INTO OUTFILE Syntax found here
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Just search for outfile and you can find it faster.
You
:55
Subject: Re: Brainstorming' time!
100 quatloos to Chris for the simplest answer. Do that.
I'll add that you could also use mysqldump:
mysqldump -T /tmp test users
This would create /tmp/users.sql, containing the CREATE
TABLE, and /tmp/users.txt, containing a tab-delimited file
suitable
Scott Hamm wrote:
Ok. I'm looking into alternatives. I'm trying to figure out an alternative
to mysql exporting into xls file.
Gosh, what's wrong with CSV files? Surely Access can export a classic
CSV file format with fields separated by commas and enclosed by ?
Then you can just use
LOAD
10 matches
Mail list logo