Re: How do I export a set of data nightly

[ian douglas]

There are lots of ways to do it. My personal favorite is to write it in 
Perl with the DBI library and tell cron to run that Perl script ... your 
Perl script could then write the data in any format you see fit, even 
send it somewhere else using Net::FTP or whatever.

Just my $0.02...
-id
Scott Haneda wrote:
My query works:
(version 4)
SELECT u.id, r.user_id,
       u.first_name, u.middle_name, u.last_name,
       u.company, u.department, u.address, u.address2,
       u.city, u.state, u.country, u.zip,
       u.phone, u.fax, u.email,
       DATE_FORMAT(u.updated, '%m/%d/%Y'), DATE_FORMAT(u.added, '%m/%d/%Y'),
       r.serial, r.product, DATE_FORMAT(r.added, '%m/%d/%Y')
FROM user as u 
INNER JOIN registered_serials as r
WHERE u.id = r.user_id LIMIT 10

However, I need to run this once a day on schedule via cron, but I am not
sure how to feed this statement into mysql from bash, can someone point me
to the correct way?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]