what is equivalent of MySQL of DBMS_OUTPUT

mysql oracle dbms-output
ckl picture ckl · Nov 3, 2013 · Viewed 24.7k times · Source

I try to write a MySQL strored procedure, and want to send some output to console, or stdout. Oracle use DBMS_OUTPUT.PUTLINE to debugginf.

Is there an equivalent of DBMS_OUTPUT in MySQL stored procedures?

Answer

Iswanto San picture Iswanto San · Nov 3, 2013

In Oracle : 

DBMS_OUTPUT.put('Hello World');

In MySQL : 

SELECT 'Hello World!';

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
update columns values with column of another table based on condition

I have two tables... table1 ( id, item, price ) values: id | item | price ------------- 10 | book | 20 20 | copy | 30 30 | pen | 10 ....table2 ( id, item, price) values: id | item | price ------------- 10 | book | 20 20 | book | 30 Now I want to: update table1 set table1.Price = table2.price where table1.…

Read More