Re: 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 conventions, though. :-)

By formatting it, I noticed an apparent mistake (in this case,
functionally the same).
You had time_type = 'Lap' rather than t.time_type = 'Lap'.

SELECT
t.time_index
FROM
table_ebscb_spa_log04 t
WHERE
t.fn_name = NEW.fn_name
AND
(
t.time_type = 'Start'
OR
t.time_type = 'Lap'
)
ORDER BY
t.stmtserial DESC
LIMIT 1
INTO t_ix;