I can't create trigger in compound statement whe use phpmyadmin but use comman line prompt I don't have trouble.
Code to create trigger
delimiter //
CREATE TRIGGER Capital_bu
BEFORE UPDATE
ON Capital
FOR EACH ROW
BEGIN
SET @country = OLD.Country;
SET @capital_old = OLD.Capital;
SET @capital_new = NEW.Capital;
END;
//
delimiter;
----------------------------------------------
ERROR
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 11
STR: //
SQL: delimiter //
CREATE TRIGGER Capital_bu2
BEFORE UPDATE
ON Capital
FOR EACH ROW
BEGIN
SET @country = OLD.Country;
SQL query:
delimiter // CREATE TRIGGER Capital_bu2 BEFORE UPDATE ON Capital FOR EACH ROW BEGIN SET @country = OLD.Country;
MySQL said: Documentation
#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 'delimiter //
CREATE TRIGGER Capital_bu2
BEFORE UPDATE
-----------------------------------
IN COMMAND PRONT LIN NO PROBLE IS ALL OK
Logged In: YES
user_id=210714
Originator: NO
This feature has been merged for version 2.11.
https://sourceforge.net/tracker/index.php?func=detail&aid=1647868&group_id=23067&atid=377410
You can test the development version on our demo server.