MySQL server

[sashhun]

Good afternoon. Please tell me who knows. After installing the MySQL packages, LM5 has its own MySQL server or only allows working with third party MySQL databases.

[admin]

It's only for MySQL client not server.

[sashhun]

It's only for MySQL client not server.

Thanks

[sashhun]

Hello. Please tell me. How can I get the result of a query as a chill, so that a condition can be made to check the result. The query displays the result in tabular form

Code:

count = dbcon:execute('SELECT COUNT(period) FROM total_energy WHERE period = "day"')
row = count:fetch({}, 'a')
log(row)

Query Result

Code:

* table:
["COUNT(period)"]
  * string: 9

[admin]

Try this:

Code:

cur = dbcon:execute('SELECT COUNT(period) AS cnt FROM total_energy WHERE period = "day"')
row = cur:fetch({}, 'a')
cur:close()

count = tonumber(row.cnt)
log(count)

[sashhun]

Try this:

Code:

cur = dbcon:execute('SELECT COUNT(period) AS cnt FROM total_energy WHERE period = "day"')
row = cur:fetch({}, 'a')
cur:close()

count = tonumber(row.cnt)
log(count)

Many thanks