hello, could you make a video how to dynamically pick a color for my bar chart? ie: if the value of my bar chart is less than 10, it will be green, above 10 it will be red. thank you in advance
I find from node to write data into db sensor_values have 2 columns, "timestamp" and "value", but in your video, there is a column "id", but when I edit db to add this column, it will cause error when write data. what is the exact structure of this db? your video is very good.
You can see the structure of the Database after the query which gets the column names. It has "id", "timestamp" and "value". The "id" is an auto_incremented primary key. This is also the reason, why you can't write this data.
Good tutorial. But so far there's only 1 problem on my side. In my csv contain string like value (like device name), while my MySQL database column was created with varchar (255) type. But every time when I tried to insert, in the debug will give error: "Error: Unknown column 'DDC_1' in 'field list'". *DDC_1 here is for the device name column in MySQL. Is there any way to upload string/varchar value via CSV? Thank you for attention.
Sir please upload a video. how to import the csv file and send the datas to MSSQL server
hello, could you make a video how to dynamically pick a color for my bar chart? ie: if the value of my bar chart is less than 10, it will be green, above 10 it will be red. thank you in advance
I find from node to write data into db sensor_values have 2 columns, "timestamp" and "value", but in your video, there is a column "id", but when I edit db to add this column, it will cause error when write data. what is the exact structure of this db? your video is very good.
You can see the structure of the Database after the query which gets the column names. It has "id", "timestamp" and "value". The "id" is an auto_incremented primary key. This is also the reason, why you can't write this data.
Good tutorial. But so far there's only 1 problem on my side.
In my csv contain string like value (like device name), while my MySQL database column was created with varchar (255) type.
But every time when I tried to insert, in the debug will give error: "Error: Unknown column 'DDC_1' in 'field list'".
*DDC_1 here is for the device name column in MySQL.
Is there any way to upload string/varchar value via CSV?
Thank you for attention.
Seems like your insert command is wrong as DDC_1 should be the value and not the column name