How to access mysql database using shell script?

This link seems to have the information you want.

http://www.cyberciti.biz/faq/using-mysql-in-shell-scripts/

mysql -u user -p dbnane

mysql database shell

try this

#!/bin/bashecho "show all tables"mysql -uroot -p'password' dbname<<EOFMYSQLshow tables;EOFMYSQLecho "Count of all records"mysql -uroot -p'password' dbname<<EOFMYSQLselect count(*) from tbname;EOFMYSQL

mysql database shell

You can use the mysql command-line tool, from your shell-script.

CodeHunter

How to access mysql database using shell script?

Recent Posts

How can I color dots in a xy scatterplot according to column value?

How to update a claim in ASP.NET Identity?

What does {0} mean when initializing an object?

Accessing members of items in a JSONArray with Java

How to log SQL statements in Spring Boot?

Powershell Get-WebSite name parameter is ignored

How to detect scroll to bottom of html element

Java synchronized method

How to test controllers with CodeIgniter?

Detect Visual Composer

Matplotlib: Specify format of floats for tick labels

Rails join a list of strings with commas and "and" before the last