On 24 Apr, 10:24, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> On Thu, 24 Apr 2008 10:20:43 +0200, Manuele Piastra <manu...@gmail.com>
> wrote:
>
>
>
> > I'm trying to create a trigger on a mysql 5 database. Here follows the
> > script:
>
> > CREATE TRIGGER awbparposinsert AFTER INSERT ON awbparzialipos
> > FOR EACH ROW BEGIN
> > INSERT INTO tabdogins(awbparzialeId, house, colli, peso, data,
> > posmag, origId, origtipo) values( new.awbparzialeId, new.house,
> > new.colli, new.peso, CURDATE(), new.codPosMagazzino, new.id, 'P');
> > INSERT INTO tabdoggia(awbparzialeId, house, colli, peso, data,
> > posmag) values(new.awbparzialeId, new.house, new.colli, new.peso,
> > CURDATE(), new.codPosMagazzino);
> > END;
>
> > I get this error message:
>
> > Unknown column 'new.awbparzialeId' in 'field list'
>
> What columns does the table awbparzialipos have?
> --
> Rik Wasmus

adding SET NAMES utf8; on top of the create trigger command
it works....thank you so much