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
http://jdb
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 :) I
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 DA
gt;
Sent: Friday, August 20, 2004 13: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 CREA
TED]>; <[EMAIL PROTECTED]>;
<[EMAIL 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/my
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:
- 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 DBMana
ly and delete the message.
-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
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: "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. I
10 matches
Mail list logo
