List:General Discussion« Previous MessageNext Message »
From:gerald_clark Date:July 29 2003 7:51pm
Subject:Re: batch mode
View as plain text  

azamka wrote:

>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
>

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
>
>
>
>  
>


Thread
batch modeazamka29 Jul
  • Re: batch modegerald_clark29 Jul
  • Re: batch modePeter L. Berghold29 Jul
    • Re: batch modeDan Nelson29 Jul