Help understanding Database.exec(sql)

esferatec

I have a question about the method "Database.exec(sql)": When I execute a "SELECT" statement, it seems that the method returns only one row as a table - is this correct?

If I add a "John, 33" to the example in the documentation, the following „SELECT“ query only returns "John, 32".

db:exec("INSERT` INTO users (name, age) VALUES('John', 32)")
db:exec("INSERT INTO users (name, age) VALUES('John', 33)")

local row = db:exec("SELECT * FROM users WHERE(name == 'John')")

Samir

You should try this :

local row1, row2 = db:exec("SELECT * FROM users WHERE(name == 'John')")

local rows = { db:exec("SELECT * FROM users WHERE(name == 'John')") }

The Database.exec() method returns zero, one or all the rows of the given statement/query as multiple return values

esferatec

Thank you. Both methods will do the trick.

Samir

Great, thank you for the feedback on this Esferatec