Re: table row result spool to file

2003-02-26 Thread g gnanaraj
>mysql -e "select * from baa;" test -u username -ppassword >/home/godson/run.sh > >also can finish what you want! > >- Original Message - >From: "g gnanaraj" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> &g

re: Re: table row result spool to file

2003-02-25 Thread Victoria Reznichenko
On Tuesday 25 February 2003 15:50, g gnanaraj wrote: > Thanks but I'm not getting the expected result. See the following: > > [quote] > [EMAIL PROTECTED] godson]$ cat chk5.sh > mysql -e "select * from baa into outfile \"/home/godson/run.sh\";" test > [EMAIL PROTECTED] godson]$ ./chk5.sh > ERROR 1

Re: table row result spool to file

2003-02-25 Thread g gnanaraj
Hi Thanks but I'm not getting the expected result. See the following: [quote] [EMAIL PROTECTED] godson]$ cat chk5.sh mysql -e "select * from baa into outfile \"/home/godson/run.sh\";" test [EMAIL PROTECTED] godson]$ ./chk5.sh ERROR 1045 at line 1: Access denied for user: '@localhost' (Using pass

table row result spool to file

2003-02-25 Thread g gnanaraj
Hi I need to create a file from the row of a table. I have done the following but it does not create a file but only display it on screen. What am I missing? Thanks. [EMAIL PROTECTED] godson]$ mysql -e "select * from baa;" --pager=t.sh test +--