lol i have again problem with triggers saving skills ... skills of new characters dont save and when i want to add
Code:
Błąd
zapytanie SQL:
CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players`
FOR EACH
ROW
BEGIN
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 0, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 1, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 2, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 3, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 4, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 5, 10
);
INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` )
VALUES (
NEW.`id` , 6, 10
);
END
MySQL zwrócił komunikat: Dokumentacja
#1235 - This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'