To run a mysql query directly from command line, without entering the interactive mode, use -e flag, like below
$ mysql -u user -p -e 'show tables;' mydbname
In the above example, the output would be, a list of tables inside mydbname, displayed on the command line, after you have put in the mysql user password.
No comments:
Post a Comment