SQL: How to get all tables in database

[Piorun]

Srsly in the name of topic is everything so:

What query i should use to get all tables in database?

[Castillo]

For SQLite, you can try with this query:

local query = executeSQLQuery ( "SELECT * FROM sqlite_master WHERE type='table'" ) 

[Piorun]

Thanks mate

[Castillo]

You're welcome.

[Piorun]

Ok one more i need - how to get list of columns in table?

[Castillo]

local query = executeSQLQuery ( "SELECT * FROM sqlite_master WHERE type='column' WHERE tablename = ?", "accounts" ) 

Try something like that, not sure if the table name column is "tablename".

[Piorun]

Another proble i have that i dont get any outputed message i dont know why:

local query = dbQuery ( database, "SELECT * FROM characters" ) 
    local result, num_affected_rows, errmsg = dbPoll ( query, -1 ) 
    for _, row in ipairs(result) do 
        for k, v in ipairs(row) do 
            outputChatBox(tostring(k)..", "..tostring(v)) 
        end 
    end 

I have "something" in this table (3 rows are - i checked it using program) but nothing happen. Why?

[Castillo]

What does "num_affected_rows" return?

[Piorun]

3 - its number of rows in table.

[Castillo]

local query = dbQuery ( database, "SELECT * FROM characters" ) 
    local result, num_affected_rows, errmsg = dbPoll ( query, -1 ) 
    for _, row in ipairs(result) do 
        for k, v in pairs(row) do 
            outputChatBox(tostring(k)..", "..tostring(v)) 
        end 
    end 

Try that.

[Piorun]

Yo - those codes aren't same?

@EDIT

Aaaaw ... pairs. Ok bro thanks.

[Castillo]

Did it work? or didn't test it yet?

[Piorun]

Forget to write - ofc its working but could you tell me what is difrence between pairs and ipairs?