Help with Shell Script

felipefls · 09-06-2010, 09:39 AM

I did a select on my db and now I need that this if consult return true for me salve the columns information in file.

How I do this in Shell?!

slakmagik · 09-06-2010, 04:04 PM

We'll probably need a lot more, clearer information. Maybe something like

Code:

if my_var=$(my_db_command 2>/dev/null); then
    echo "$my_var" > my_file
fi

but I'm not sure if that's what you're asking.

AnanthaP · 09-06-2010, 07:43 PM

If you can see the select results in your shell by running the sql at the shell prompt, then you should be able to redirect the output to a file.

felipefls · 09-17-2010, 08:41 AM

Hi guys, today I return with my tests and I see that I was wrong way.
Is better to copy the select to file. Well, I try but my code copy everything, since "select....." until "1 row in set....".
How I do to copy only result of select?

I hope you can understand me.

Bellow my code:

mysql -vv -u root -pcolorado -e "select email from birt\
where date_format(dn,'%dd%') = date_format(Current_date,'%dd%')\
and date_format(dn,'%mm%') = date_format(Current_date,'%mm%');"\
birthday >> teste

thank's.

Att.
Felipe Lima