Usefull Mysql Commands (Shell)

Run Query from Linux Shell

To run a single MySQL query from your regular shell instead of from MySQL’s interactive command line you would do this:

mysql -u [username] -p [dbname] -e [query]