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]
