Shell - one line query

mysql shell command-line freebsd
Cyclone picture Cyclone · Feb 27, 2012 · Viewed 34.9k times · Source

I need to execute a mysql query in one line using bash.

It should be something like this:

mysql database --user='root' --password='my-password' < query.file

But instead of the < query.file it would like to use a raw query like this:

mysql database --user='root' --password='my-password' < UPDATE `database` SET `field1` = '1' WHERE `id` = 1111;

Is that possible?

Answer

Nishant picture Nishant · Feb 27, 2012

Did you try 

 mysql -u root -pmy_password -D DATABASENAME -e "UPDATE `database` SET `field1` = '1' WHERE `id` = 1111;" > output.txt

(the > output.txt part can be ignored but, it will be useful to see what was returned by the statement executed by looking at the file.)

Related questions

How to create a database from shell command?

I'm looking for something like createdb in PostgreSQL or any other solution that would allow me to create database with a help of a shell command. Any hints?

Read More
How do I set MySQL temporarily to read-only through the command line?

I'm creating a bash script which, among other things, gathers some data from a MySQL database. My MySQL user has write privileges, but for safety reasons I would like to temporarily set it to a read only state. Is it …

Read More
Access mysql remote database from command line

I have a server with Rackspace. I want to access the database from my local machine command line. I tried like: mysql -u username -h my.application.com -ppassword But it gives an error: ERROR 2003 (HY000): Can't connect to MySQL …

Read More