Answers for "mysql execute query from bash"

mysql bash execute sql file

mysql -u user -p data_base_name < sql_file.sql
# execute sql file in target database or juste in mysql

Posted by: Guest on March-22-2021

automate mysql cli query

#!/bin/bash
mysql -u root -psecret <<MY_QUERY
USE mysql
SHOW tables
MY_QUERY

Posted by: Guest on October-26-2020

Code answers related to "mysql execute query from bash"