Gauge field from Mysql table

Dear forum members, I need someone to help me with node red v3.02, I need to graph with gauge a field called Temperature from a mysql table as this field is referenced in gauge node.

Add a debug to the sql node, then use the copy path icon/button, it appears when you hover the mouse over property name. Copy the path to the value you want to display. Then in the gauge node use {{msg.copied_path}} in the value format field.
You should end up with something like {{msg.payload[0].Temperature}}

I don't have the value format field.

With the limited info you gave i assumed you meant ui-gauge. Use the copied path in the input field of the artless gauge.

thanks friend gauge worked very well.