On Feb 29, 2012, at 10:43 AM, Ed Patterson wrote:
> Be kind, I am by no means any type of DB expert.
>
> I would like to eventually move this to a stored procedure but for now I am
> using the \. to fire it off.
>
> Here is what I have so far (generating a list of machines missing software)
>
By using your shell's variable substitution, I'm afraid.
export outfile='/path/to/file'
mysql -e "select blah into outfile '$outfile'"
You'll have to build a shell script or something that generates your filename,
and then do an interactive call.
Maybe you could write a stored procedure tha
2012/02/29 11:43 -0500, Ed Patterson
The select concat() works from the command line
I can manually add the file name but would like to automate the process
Lastly, if it makes a difference, I don't use any graphical tools for DB stuff.
Look up the command! http://dev.mysql.com/
Be kind, I am by no means any type of DB expert.
I would like to eventually move this to a stored procedure but for now I
am using the \. to fire it off.
Here is what I have so far (generating a list of machines missing software)
select last_logon.host_name_short
from last_logon
left join mca
