Re: Trigger

[tobi münich]

Sorry, public and not Public but thats not the problem.

snmptt.snmptt
CREATE TABLE `snmptt` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`eventname` varchar(50) DEFAULT NULL,
`eventid` varchar(50) DEFAULT NULL,
`trapoid` varchar(100) DEFAULT NULL,
`enterprise` varchar(100) DEFAULT NULL,
`community` varchar(20) DEFAULT NULL,
`hostname` varchar(100) DEFAULT NULL,
`agentip` varchar(16) DEFAULT NULL,
`category` varchar(20) DEFAULT NULL,
`severity` varchar(20) DEFAULT NULL,
`uptime` varchar(20) DEFAULT NULL,
`traptime` varchar(30) DEFAULT NULL,
`formatline` varchar(255) DEFAULT NULL,
`trapread` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=226 DEFAULT CHARSET=latin1


the table snmptt.test is just a copy of snmptt.snmptt

I want to put new entrys from an externel Program (snmptt) to different tables by using this Trigger.