Bash script to MySql

[Scott Haneda]

I need to to the following
Select serial from serials;

Problem is I need to run this from a script which cron will call once a day,
how do you pass a select statement to mysql with user and pass so it can all
happen in one go?
-- 
-------------------------------------------------------------
Scott Haneda                                Tel: [phone]
http://www.newgeo.com                       Fax: [phone]
scott@stripped                            Novato, CA U.S.A.