Re: Need help creating mysql trigger

[Peter Brawley]

Sorry, I reversed new and ip_lookup ...

drop trigger if exists access_ins;
delimiter go
create trigger access_ins before insert on access for each row
begin
  declare vcountry, varea, vcity varchar(64);
  select country,area,city into vcountry,varea,vcity
  from ip_lookup
  where NEW.ip_address between ip_lookup.start_ip and ip_lookup.end_ip
  limit 1; /* iplookup table might have multiple rows matching given range */
  if vcountry is not null then
    set NEW.country=vcountry, NEW.area=varea, NEW.city=vcity;
  /* else ... code to handle error */
  end if;
end;
go
delimiter ;