appending INT to a column name in a trigger

[Darren White]

In C I mean like
int i = 1;
printf( "Log_%d", i );

= Log_1



This is what I want to do:

FOR EACH ROW
BEGIN
DECLARE rowNum INTEGER;
SELECT id INTO rowNum FROM status_data limit 1;

IF rowNum<25 THEN
INSERT INTO log_"rowNum" (tension) VALUES (NEW.tension) ;

IF rowNum>25 THEN .....


So when row id=1 I would insert data into log_1 table.
when row id=2 I would insert data into the log_2 table.