I'm trying to create a simple trigger to copy data from one field (customer_id) to another field (custid) in the same table (customers) on insert..
I've got to this but it doesn't work...
create trigger `fill_custid` AFTER INSERT on `customers`
for each row BEGIN
declare custid varchar(10);
declare customer_id int(7);
set custid = customer_id;
Any ideas what's wrong??