Discussion :

[bza88]

salut,

comment mettre respectivement a jour les colonnes "name_nearest_place" et "distance_nearest_place" avec les colonnes "name" et "distance" de la table gs_object_data_xxxxxxxx.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
 
CREATE TRIGGER `t_gs_object_data_xxxxxx` AFTER INSERT ON `gs_object_data_xxxxxx`
 FOR EACH ROW BEGIN
INSERT INTO nearest_marker(name,distance)
SELECT get_distance_nearest(new.lat, new.lng, marker_lat, marker_lng) as distance, marker_name
FROM gs_user_markers_share ORDER BY distance DESC LIMIT 1;
UPDATE gs_object_data_xxxxxx
SET name_nearest_place  = xxxxx,
distance_nearest_place  = yyyyy ;
END

merci