azamka wrote:
I am trying to right sql statement on the shell prompt but its not going through.
Here is the statement:
[EMAIL PROTECTED] usr]# mysql security < select * from machine; -bash: select: No such file or directory
echo "select * from machine" | mysql security
or put your select statement in a file and: mysql security < sqlfile
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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]