[MySQL] Trigger

I want to ask someone? This is right or wrong trigger... Cause i use this syntax and get error result..
I want if i delete 1 row in table item then in table itemchild where item.itemcode=itemchild.itemchildcode deleted too..

CREATE TRIGGER test BEFORE DELETE ON item
FOR EACH ROW BEGIN
DELETE FROM itemchild WHERE itemchildcode = NEW.itemcode;
END;

If wrong, please tell me the right way... Thanks...

Mysql doesn't work like php.
[php]
<?php
if($_GET['delete']==true){
$query=mysql_query("DELETE FROM items WHERE field='something'");

zzzz, this not php sir, this trigger for mysql.... I ask how to use delete trigger for above example...

Quote:

---

Originally Posted by myliquid

zzzz, this not php sir, this trigger for mysql.... I ask how to use delete trigger for above example...

---

"If wrong, please tell me the right way... Thanks..."
Mysql can't be used like that.

CREATE TRIGGER test1 BEFORE INSERT ON item
FOR EACH ROW BEGIN
INSERT INTO itemchild SET itemcode = NEW.itemcode;
UPDATE itemchild SET qty = NEW.quantity;
END;

this my mysql trigger for insert is work.

But for delete :

CREATE TRIGGER test BEFORE DELETE ON item
FOR EACH ROW BEGIN
DELETE FROM itemchild WHERE itemchildcode = NEW.itemcode;
END;

this not work... Anybody know how to use delete trigger?

Hidden: that is how MySQL does work in fact, triggers can in fact be very powerfull and usefull.

That being said, wouldn't it be a lot easier to simply use a foreign key constraint with a cascading action set to it's children?

mmm, i don't how use cascade and but i have another table has related to that table and must use delete trigger.. But i don't why that delete trigger can't use, and this the error :
"There is no NEW row in on DELETE trigger"

i solved my problem,
my error in here "NEW.itemcode"..
must change to OLD.itemcode not NEW... NEW for new record. Thanks all..