Re: [GENERAL] Re: INSERT a real number in a column based on other columns OLD INSERTs

On 25/06/15 16:06, litu16 wrote: SELECT t.time_index FROM table_ebscb_spa_log04 t WHERE t.fn_name = NEW.fn_name AND (t.time_type = 'Start' OR time_type = 'Lap') ORDER BY t.stmtserial DESC LIMIT 1 INTO t_ix; Please format your SQL, as it makes it easier to read! But, you don't have to follow my c

[GENERAL] Re: INSERT a real number in a column based on other columns OLD INSERTs

Thanks to everybody I already solved, the correct syntax was... SELECT t.time_index FROM table_ebscb_spa_log04 t WHERE t.fn_name = NEW.fn_name AND (t.time_type = 'Start' OR time_type = 'Lap') ORDER BY t.stmtserial DESC LIMIT 1 INTO t_ix; Thanks for all again. -- View this message in context: h