How to login to MySQL and execute a select from command line

Question

I am logging in to an sql server using the following command:

mysql -u root

Then I selected the sql database:

use mysql

After this I wanted to see everything in the users table using the following command:

select * FROM user;

But how do I combine all of these three single commands into one?

I tried:

mysql -u root; use mysql; select * FROM user;

But this did not work, it just logged me into the sql server.

Giles · Accepted Answer · 2014-10-02 10:35:51Z

1

try this:

mysql -u root -e"use mysql; select * FROM user;"

answered Oct 2, 2014 at 10:35

Giles

1,69713 silver badges17 bronze badges

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

Comments

user3963491 · Accepted Answer · 2014-10-02 10:39:06Z

0

Please Try This:

$ mysql -u root -p -e 'SELECT * FROM quotes' cbzquotes

answered Oct 2, 2014 at 10:39

user3963491