I have a mysql database with different tables. Depending on the name of the parameter, I first need to lookup it’s ID. With this ID, I can then find the values in another table. For example, I want to get the values for parameter “OPPSM001”. To get these values, I need to look in table t_par_ref and…

select va.* from ( select param_id , gentime, value, 't_par_dbl ’ as t_raw from t_par_dbl union select param_id , gentime, value, ‘t_par_u16’ as t_raw from t_par_u16 ) va join t_par_ref ref on va.t_raw = ref.t_raw and va.param_id = ref.param_id WHERE ref.name = ‘OPPSM001’

Mysql variables

Grafana MySQL

stijnilsen February 17, 2025, 6:31pm 11

Some more info. Example of t_par_ref values:

Example of one of my tables (t_par_dbl):

Handling selection from 10k+ parameters

Topic		Replies	Views
Variables in MySQL MySQL templating , mysql	4	4647	September 29, 2020
Grafana MySQL Query Variable MySQL templating , mysql	2	12691	April 12, 2018
Nested queries MySQL MySQL mysql	1	2203	June 8, 2019
Metrics based on variable value mysql	2	922	June 5, 2019
Query for each value in template variable in table panel Grafana	2	2595	February 18, 2019

Mysql variables

Related topics