Set up trigger

[Jakub Kalinowski]

Hello,

I've got problem with set up trigger in my database.

I first table 'biblioitems' looks like below:

biblionumber
2

Marcxml
<datafield tag="245" ind1="1" ind2="0">
<subfield code="a">Burza piaskowa /</subfield>
<subfield code="c">Roman Samsel.</subfield>
</datafield>



I set up trigger, but it doesn't work correct.


delimiter //
CREATE TRIGGER `title_from_245` AFTER INSERT ON biblioitems
FOR EACH ROW BEGIN

INSERT INTO antykwariat_posts (biblio_id, post_title)

SELECT NEW.biblionumber, ExtractValue(NEW.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]') from biblioitems;

END;
//
delimiter ;



When I add something to table 'biblioitems' my server add row to table 'antykwariat_post', but there is only biblio_id, post_title is still empty.

Could you tell me what is wrong?