Search found 3 matches
- Thu Jun 18, 2009 3:15 am
- Forum: Library
- Topic: MYSQL Logging with Stored Procedure
- Replies: 2
- Views: 39408
- Thu Jun 18, 2009 3:13 am
- Forum: Library
- Topic: MYSQL Logging with Stored Procedure
- Replies: 2
- Views: 39408
so now here comes the view DROP VIEW IF EXISTS `hostmonitor`.`hostmon_complete`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `hostmonitor`.`hostmon_complete` AS select `agent`.`Agent` AS `Agent`,`mastertest`.`mastertest` AS `mastertest`,`servicecomp`.`servicecomp` AS `se...
- Wed Jun 17, 2009 11:43 pm
- Forum: Library
- Topic: MYSQL Logging with Stored Procedure
- Replies: 2
- Views: 39408
MYSQL Logging with Stored Procedure
At the first i will post all the tables that i have created: DROP TABLE IF EXISTS `hostmonitor`.`agent`; CREATE TABLE `hostmonitor`.`agent` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Agent` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_F...