Very Computer

hi list

Can I also execute mysql commands from the shell.

Something like this:

% mysql -u root -pmypass --execute=use mydb; select * from mytable;

Thanks..

ilyas

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

IK> hi list
IK> Can I also execute mysql commands from the shell.
IK> Something like this:
IK> % mysql -u root -pmypass --execute=use mydb; select * from mytable;

You can do something like this i think :
% mysql -u root -pmypass mydb --execute='select * from mytable'

David

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php