mysql insert variabla

/* SQL Error (1062): Duplicate entry '2-0' for key 'PRIMARY' */

SET @a:=0;

INSERT INTO tezaver_taxonomy (id_tezaver,`level`,level_name,term,source)

SELECT a.id_tezaver,@a:=@a-1,'genus extra',a.genus,'automatic by script dodatni genus/i' from
(SELECT id_tezaver,LEFT(term,POSITION(' ' IN term)) AS genus
FROM tezaver
WHERE trim(term) LIKE '% %' AND l2 = 'la'
GROUP BY id_tezaver,LEFT(term,POSITION(' ' IN term)) ) AS a
LEFT JOIN tezaver_taxonomy tt ON tt.id_tezaver = a.id_tezaver AND tt.term = a.genus
WHERE tt.term IS NULL;

Ahim je 19. dec 2020 ob 21:53 izjavil:

BRBR je 18. dec 2020 ob 18:11 izjavil:

Bah, zdaj vidim. Če insertaš v INT unsigned, vse kar je negativno postane 0 before insert, zato tak neinformativen/confusing error message.

Ce to pocnes, potem si najbrz zasluzis tak error message