Mysql profiles and watched status

  Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
armss001 Offline
Junior Member
Posts: 4
Joined: May 2015
Reputation: 1
Post: #76
Okay problem solved, after digging about, I needed to add delimiter.

Code is as follows when ran from the phpmyadmin page.

Code:
delimiter //
CREATE TRIGGER insert_new_watched AFTER INSERT ON myvideos90.files
    FOR EACH ROW BEGIN
        INSERT INTO kodi_ben90.watched_history(idFile) VALUES (NEW.idFile);
        INSERT INTO kodi_dan90.watched_history(idFile) VALUES (NEW.idFile);
        INSERT INTO kodi_dem90.watched_history(idFile) VALUES (NEW.idFile);
        INSERT INTO kodi_nath90.watched_history(idFile) VALUES (NEW.idFile);
        INSERT INTO kodi_hannah90.watched_history(idFile) VALUES (NEW.idFile);
     END; //
delimiter ;
find quote
Walhalla Offline
Junior Member
Posts: 45
Joined: Apr 2009
Reputation: 1
Post: #77
Good to know. Thanks for posting the solution.
find quote
Post Reply