$ mysql -u mysqlusername -e '<insert your sql here>' On Mon, 1 Nov 2004, 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? > > -- > ------------------------------------------------------------- > Scott Haneda Tel: 415.898.2602 > <http://www.newgeo.com> Fax: 313.557.5052 > <[EMAIL PROTECTED]> Novato, CA U.S.A. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]