mysql触发器循环遍历_Mysql触发器循环,用于包含许多行的查询结果

嗨我有一个包含许多表和外键的数据库

CREATE TABLE IF NOT EXISTS `articulos` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`nombre` varchar(63) NOT NULL,

`contenido` text NOT NULL,

`normas_id` int(11) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=138 ;

CREATE TABLE IF NOT EXISTS `aspectosambientales` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`nombre` varchar(63) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;

CREATE TABLE IF NOT EXISTS `aspectosambientales_articulos` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`aspectosambientales_id` int(11) NOT NULL,

`articulos_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

KEY &#