Re: printing procedure variables to console or log

Hello,

I decided to log everything into a table instead.

//Create source table
CREATE TABLE atable
(
id LONGVARCHAR,
name LONGVARCHAR
);

//Insert source table values
INSERT INTO atable (id,name) VALUES ('0','a');
INSERT INTO atable (id,name) VALUES ('1','b');
INSERT INTO atable (id,name) VALUES ('2','c');

//Create table for output
CREATE TABLE output
(
String LONGVARCHAR
);

//Create print procedure
CREATE PROCEDURE print (
IN v_String LONGVARCHAR
)
MODIFIES SQL DATA BEGIN ATOMIC
INSERT INTO output (
String
) VALUES (
v_String
);
END;

//Create test procedure
CREATE PROCEDURE theprocedure()
--
modifies sql data BEGIN atomic
--
FOR SELECT id,name FROM atable DO
--
call print(id+','+name);
--
END FOR;
--
END;

//Run test procedure
CALL theprocedure();