Need to connect database mysql from shell script (linux centos7)

Question

#!/bin/bash
date +'%F %T'
echo "Show Database"
mysql -u [user] -p[password] -e 'SHOW DATABASES,USE eventime,SELECT * FROM dt;'

output :

2016-09-22 16:01:33
Show Database
Warning: Using a password on the command line interface can be insecure.
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USE eventime,SELECT * FROM dt' at line 1

I don't know why not select data need to connect and select data and delete data eveytime 90 day ago thx for help.

Nishant Kumar · Accepted Answer · 2016-09-22 09:16:03Z

2

Try semicolon instead of comma in command -

mysql -u [user] -p[password] -e  'SHOW DATABASES;USE eventime;SELECT * FROM dt;'

answered Sep 22, 2016 at 9:16

Nishant Kumar

2,1793 gold badges23 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Need to connect database mysql from shell script (linux centos7)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related