Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Can I get a stdout of basic MySQL commands in BASH?

Tags:

bash

mysql

Can I get a stdout of basic MySQL commands in BASH? show, describe for starters. I'm troubleshooting a problem with several databases and I want to compare them with increasing specificity. The dump is just too much information.

like image 750
xtian Avatar asked Mar 25 '12 02:03

xtian

People also ask

How do I get out of MySQL prompt?

To exit from mysql type quit at the mysql> command-prompt.

What is shell script in MySQL?

The Workbench Scripting Shell provides a means for entering and executing Python scripts. Through the use of the scripting shell, MySQL Workbench can support new behavior and data sources using code written in Python. The shell can also be used to explore the current Workbench Generic RunTime (GRT) facilities.

1 Answers

echo "command" | mysql -u username -ppassword -h host database_name

not only basic command but full SQL can be run this way

like image 62
dhchen Avatar answered Oct 12 '22 22:10

dhchen
Sign in to Comment

Related questions

One database vs many databases [closed]
Can I do a Parameterized Query containing Geometry Function?
Qt/QSqlQuery: Binary data is interpreted as string when binding to BLOB field
Update mysql table with same values and still get a timestamp update
Convert mysql regex to java regex (and/or vice versa)
Get all objects without loop in OOP MySQLi
How to calculate a third monday of every month using SQL statement?
SQL performance searching for long strings
mySql to get last records of duplicate entries [duplicate]
Add table privileges to user using mySQL Workbench
mysql.user table on mySQL
last_insert_id with multiple threads
Is MongoDB a good choice for storing JSON structures?
MIN() in WHERE clause
Decimals in MySQL Polygon Geometry
Is single sql statement always atomic in innodb?
SQL query to find Nth highest salary from a salary table
How to build simple reviewing and 5-star rating system? [closed]
Calculating distance between zip codes in PHP
Flask-SQLAlchemy: Can't reconnect until invalid transaction is rolled back

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!