[CLUE-Tech] MySQL questions

[Jeffery Cann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

1.  How do I turn off the pretty print of results sets?  i.e.,  I do not want 
the pipes:

2.  Is there another way to input data instead of command line redirection?  
For example, to run the bob.dat sql file:

$ mysql -u jccann -p < bob.dat

This is highly annoying because I must continuously restart the mysql command 
line client.  In most command-line SQL clients that I have used, one can 
normally execute a file with the 'input' or '@' command.  Is there a mysql 
equivalent to this?

$ mysql -u jccann -p
mysql> input bob.dat

Thanks
Jeff
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAjsbiRsACgkQw3/GBQk72kDbegCfWQi7LyKWUxNByo/hKKbuhRL9
lE4AniieZ0AlTvW2y4Ia3TggUiisUBQ7
=IMxk
-----END PGP SIGNATURE-----