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:

123

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

Query Result

Code:

123

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

[admin]

Try this:

Code:

123456

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:

123456

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