Sql

[./BlackBird#]

Can i insert table into Sql Cloumn ?

[botder]

No, and why?

[./BlackBird#]

i mean like this

local t = {"Test"} 
executeSQLQuery("INSERT INTO TestSql(value) VALUES(?)", t) 

[Tete omar]

You can use the pair of the JSON functions;

toJSON 
fromJSON 

They can be used to store a Lua table into SQL tables.

[./BlackBird#]

Thanks TeTe

[Tete omar]

No problem.

['LinKin]

@Tete: Can you give an example of it?

[Tete omar]

Alright,

local informative_table = { foo = "bar", green = { 0, 255, 0 }, table_name = "informative_table" } 
local JSON_structure    = toJSON ( informative_table ) 
  
--[[ 
    JSON_structure is a variable that contains a string containing a copy of 'informative_table', 
    whenever we need this table, we can produce it using fromJSON ( JSON_structure ), e.g: 
    local informative_table_2 = fromJSON ( JSON_structure ) 
    and here we have another copy of 'informative_table' 
--]]