mysql两个表插入触发器_MySQL如何利用触发器于联立的两表自动插入数据

同一个数据库下的gorder表与goods表，我想给gorder表中的字段Money自动触发插入数据为goods表中的Price与gorder表Cust_Count的乘积

代码如下

CREATE TRIGGER tri_1 AFTER UPDATE ON gorder FOR EACH ROW BEGIN

IF (gorder.Cust_Count!=NULL)AND(gorder.Cust_Count!=0)

THEN

UPDATE gorder

SET gorder.Money=goods.Price*gorder.Cust_Count

WHERE (id=gorder.Money) AND (goods.Gid=gorder.Gid);

ELSE SELECT E001 INTO gorder;

ELSE IF;

END;

错误提示如下

Query : CREATE TRIGGER tri_1 AFTER Update ON gorder FOR EACH ROW BEGIN if (gorder.Cust_Count!=null)and(gorder.Cust_Count!=0) then update...

Error Code : 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : else SELECT E001 INTO gorder

Error Code : 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'else SELECT E001 INTO gorder' at line 1

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : else if

Error Code : 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'else if' at line 1

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : END

Error Code : 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 1

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

求助！！！