help me with sql

[DiGiTal]

How can i create a row with many data in it(like in items) i think it should be with JSON

[itHyperoX]

Yes, you correct. With JSON.

https://wiki.multitheftauto.com/wiki/ToJSON

https://wiki.multitheftauto.com/wiki/FromJSON

Edited July 28, 2018 by TheMOG

[DiGiTal]

14 minutes ago, TheMOG said:

Yes, you correct. With JSON.

https://wiki.multitheftauto.com/wiki/ToJSON

https://wiki.multitheftauto.com/wiki/FromJSON

an example ??

[JeViCo]

34 minutes ago, DiGiTal said:

an example ??

script code:

sometable = {1, 2, 3}
toJSON(sometable)

-- OR
toJSON({1, 2, 3})

in database (with toJSON)

[[1, 2, 3]]

it gives additional box brackets

[DiGiTal]

3 minutes ago, Juuve said:

script code:

sometable = {1, 2, 3}
toJSON(sometable)

-- OR
toJSON({1, 2, 3})

in database (with toJSON)

[[1, 2, 3]]

it gives additional box brackets

what i writte in SQL  ?

in database (with toJSON)

?

1.  
2. [[1, 2, 3]]

 

this is the result in my db you mean?

 

[JeViCo]

2 hours ago, DiGiTal said:

this is the result in my db you mean?

uhhhh

Here better example.

script:

dbExec(db, "UPDATE Vehicles SET Number = ? WHERE ID = ?", toJSON(newplate), vehid)

database: