Re: How to echo sql stmts on mysql?

[Josh Chamas]

ummatix wrote:
> How to make the mysql command prompt display (i.e.
> echo) the sql statement that I just ran. For
> example, I ran the following at the mysql prompt:
>

Try running with -v, this is what I get:

$ ./mysql -v -e 'select now()';
--------------
select now()
--------------

+---------------------+
| now() |
+---------------------+
| 2004-11-16 17:00:11 |
+---------------------+

Regards,

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting