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

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