Insert sql record by command line ssh for use in grafana worldmap

Grafana
#1

i try to execute this command line:

 ssh root@ip "mysql -u login -ppassword zabbix -e 
'INSERT INTO worldmap_latlng (lat,lng,name,value,timestamp) 
 VALUES (48.891198, 2.2465829, "'test'", 0, now())'"

but i have this response :

ERROR 1054 (42S22) at line 1: Unknown column 'test' in 'field list'

i try with ’ and " but not work

#2

Try escaping the inner " with \ and removing the inner ’

ssh root@ip “mysql -u login -ppassword zabbix -e ‘INSERT INTO worldmap_latlng
(lat,lng,name,value,timestamp) VALUES (48.891198, 2.2465829, “test”, 0,
now())’”

Antony.