1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| INSERT INTO hosts(host,lastseen,seen) VALUES (NEW.host,NEW.lo,1) ON DUPLICATE KEY UPDATE seen=seen + 1, lastseen=GREATEST(NEW.lo,lastseen), hidden=false;
ERROR 1064 (42000): 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 7
mysql> UPDATE mne SET seen=seen + 1, lastseen=NEW.lo, hidden= false WHERE crc=NEW.mne;
ELSE
ERROR 1054 (42S22): Unknown column 'NEW.mne' in 'where clause'
INSERT INTO hosts(host,lastseen,seen) VALUES (NEW.host,NEW.lo,1) ON DUPLICATE KEY UPDATE lastseen=GREATEST(NEW.lo,lastseen), hidden= false;
mysql> UPDATE snare_eid SET seen=seen + 1, lastseen=NEW.lo, hidden=false WHERE eid=NEW.eid;
END IF;
ERROR 1054 (42S22): Unknown column 'NEW.eid' in 'where clause'
END;mysql> UPDATE programs SET seen=seen + 1, lastseen=NEW.lo, hidden=false WHERE crc=NEW.program;
ERROR 1054 (42S22): Unknown column 'NEW.program' in 'where clause'
mysql> INSERT INTO cache (name,value,updatetime) VALUES ('msg_sum',1,NEW.lo) ON DUPLICATE KEY UPDATE value=value + 1,updatetime=NEW.lo;
ERROR 1054 (42S22): Unknown column 'NEW.lo' in 'field list'
mysql> ELSE
-> INSERT INTO hosts(host,lastseen,seen) VALUES (NEW.host,NEW.lo,1) ON DUPLICATE KEY UPDATE lastseen=GREATEST(NEW.lo,lastseen), hidden= false;
ERROR 1064 (42000): 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
INSERT INTO hosts(host,lastseen,seen) VALUES (NEW.host,NEW.lo,1) ON' at line 1
mysql>
mysql> END IF;
ERROR 1064 (42000): 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 IF' at line 1
mysql>
mysql> END;
ERROR 1064 (42000): 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 |
Partager