Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Jan 162010
 

How to execute SQL using command line

Answer:

Use the mysql client and -e option to execute query in shell

# mysql -e 'select now()' -u root -p

+---------------------+
| now()               |
+---------------------+
| 2010-01-16 20:22:38 |
+---------------------+

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>