batch mode

[azamka]

I am trying to right sql statement on the shell prompt but its not going 
through.
Here is the statement:

[root@localhost usr]# mysql security < select *  from machine;
-bash: select: No such file or directory

It is asking for the text file. And it works fine with the text file. I am 
wondering how can we write a sql statement on the command prompt. I looked 
into the manual but didnt find it. Is there anyone who can tell me the exact 
syntax. Please help