Hello,
I am trying to get a better understanding of how to change options
during a session.
tee is a perfect example.
I have tried :
'select * from users' tee MIke .txt

'select * from users tee MIke .txt';

ect...

What is the correct format for this?
Thanks
Mike

On Dec 31, 4:29 pm, AMP <ampel...@gmail.com> wrote:
> Hello,
> I am trying to get a better understanding of how to change options
> during a session.
> tee is a perfect example.
> I have tried :
> 'select * from users' tee MIke .txt
>
> 'select * from users tee MIke .txt';
>
> ect...
>
> What is the correct format for this?
> Thanks
> Mike

mysql> ?

For information about MySQL products and services, visit:
http://www.mysql.com/
For developer information, including the MySQL Reference Manual,
visit:
http://dev.mysql.com/
To buy MySQL Network Support, training, or other products, visit:
https://shop.mysql.com/

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `'.
clear (\c) Clear command.
connect (\r) Reconnect to the server. Optional arguments are db and
host.
delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the
line as new delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to mysql server, display result
vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
(\h) Display this .
nopager (\n) Disable pager, print to stdout.
notee (\t) Don't write into outfile.
pager (\P) Set PAGER [to_pager]. Print the query results via
PAGER.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute an SQL script file. Takes a file name as an
argument.
status (\s) Get status information from the server.
system (\!) Execute a system shell command.
tee (\T) Set outfile [to_outfile]. Append everything into given
outfile.
use (\u) Use another database. Takes database name as argument.
charset (\C) Switch to another charset. Might be needed for
processing binlog with multi-byte charsets.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.

For server side , type ' contents'

mysql>

mysql> \T my_outfile.txt
mysql> select * from users;
mysql> quit

bash> cat my_outfile.txt

faulkes

On Dec 31, 5:02pm, faulkes <michael.behr...@gmail.com> wrote:
> On Dec 31, 4:29 pm, AMP <ampel...@gmail.com> wrote:
>
> > Hello,
> > I am trying to get a better understanding of how to change options
> > during a session.
> > tee is a perfect example.
> > I have tried :
> > 'select * from users' tee MIke .txt
>
> > 'select * from users tee MIke .txt';
>
> > ect...
>
> > What is the correct format for this?
> > Thanks
> > Mike
>
> mysql> ?
>
> For information about MySQL products and services, visit:
> http://www.mysql.com/
> For developer information, including the MySQL Reference Manual,
> visit:
> http://dev.mysql.com/
> To buy MySQL Network Support, training, or other products, visit:
> https://shop.mysql.com/
>
> List of all MySQL commands:
> Note that all text commands must be first on line and end with ';'
> ? (\?) Synonym for `'.
> clear (\c) Clear command.
> connect (\r) Reconnect to the server. Optional arguments are db and
> host.
> delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the
> line as new delimiter.
> edit (\e) Edit command with $EDITOR.
> ego (\G) Send command to mysql server, display result
> vertically.
> exit (\q) Exit mysql. Same as quit.
> go (\g) Send command to mysql server.
> (\h) Display this .
> nopager (\n) Disable pager, print to stdout.
> notee (\t) Don't write into outfile.
> pager (\P) Set PAGER [to_pager]. Print the query results via
> PAGER.
> print (\p) Print current command.
> prompt (\R) Change your mysql prompt.
> quit (\q) Quit mysql.
> rehash (\#) Rebuild completion hash.
> source (\.) Execute an SQL script file. Takes a file name as an
> argument.
> status (\s) Get status information from the server.
> system (\!) Execute a system shell command.
> tee (\T) Set outfile [to_outfile]. Append everything into given
> outfile.
> use (\u) Use another database. Takes database name as argument..
> charset (\C) Switch to another charset. Might be needed for
> processing binlog with multi-byte charsets.
> warnings (\W) Show warnings after every statement.
> nowarning (\w) Don't show warnings after every statement.
>
> For server side , type ' contents'
>
> mysql>
>
> mysql> \T my_outfile.txt
> mysql> select * from users;
> mysql> quit
>
> bash> cat my_outfile.txt
>
> faulkes

How do I change something like -H or -X midsession?
Or can I?
Thanks
Mike

AMP wrote:
> On Dec 31, 5:02 pm, faulkes <michael.behr...@gmail.com> wrote:
> How do I change something like -H or -X midsession?
> Or can I?
> Thanks
> Mike
There are commands and there are command line options. In some cases they
overlap. In others they do not.