construct a sql , assign it to a variable and execute inside shell script

Posted on

Question :

I am trying to execute a mysql query inside my shell script, which is not executing .
Here is what i am trying to do

query=""select count(*) from information_schema.tables where TABLE_SCHEMA not in ('mysql','performance_schema','information_schema') and engine!='INNODB'

Answer :


Leave a Reply

Your email address will not be published. Required fields are marked *