SQL Statement for changing an Attribute in the Database?
Attributes are in JSON format. You have to use JSON functions, if your database even supports that.
Yes that what i googled. But i have after that no idea how to do that
Any hint?
Attributes are in JSON format. You have to use JSON functions, if your database even supports that.
Yes that what i googled. But i have after that no idea how to do that
Any hint?
Hello
after getting it to work to get driver names in DB i have to correct some entries.
But i am not familiar with the statement i have to use.
I try to change in 'tc_psotions' within the field 'attributes' just drivername:
from: "driverUniqueId":"Anton" to "driverUniqueId":"Maksym"
Because the field is very long i dont no how to change this with sql
Something Like:
UPDATE `tc_positions` SET `attributes`= Maksym WHERE `attributes`=Antonis not enough
Some body some help?