Jump to content

[Урок] Встроенные функции для работы с MySQL / SQLite


Recommended Posts

Не хватит, ибо тут только базовые принципы. Для начала подойдут эти справочники: MySQL и очень хороший по SQLite.

Кстати, заметил, что вывод таких функций, как count(*), будет находится в таком же виде и в результативной таблице, т.е. resulTable['count(*)'].

используйте оператор "AS" чтобы избежать этого. Например:

SELECT COUNT(*) AS `myCount` FROM `table` 

в итоге получите результат в resultTable.myCount

Link to comment
  • 1 year later...
  • 3 years later...

[2020-03-12 14:44:00] WARNING: [gameplay]\mysql\server.Lua:8: Bad usage @ 'dbConnect' [Can't connect to MySQL server on 'localhost' (10061)]
[2020-03-12 14:44:00] ERROR: [gameplay]\mysql\server.Lua:12: [MYSQL][ERROR] Connection failed!
[2020-03-12 14:44:08] WARNING: [gameplay]\mysql\server.Lua:8: Bad usage @ 'dbConnect' [Can't connect to MySQL server on 'localhost' (10061)]
[2020-03-12 14:44:08] ERROR: [gameplay]\mysql\server.Lua:12: [MYSQL][ERROR] Connection failed!
[2020-03-12 14:44:08] WARNING: [gameplay]\mysql\server.Lua:35: Bad argument @ 'dbQuery' [Expected db-connection at argument 3, got boolean]
[2020-03-12 14:44:15] WARNING: [gameplay]\mysql\server.Lua:8: Bad usage @ 'dbConnect' [Can't connect to MySQL server on 'localhost' (10061)]
[2020-03-12 14:44:15] ERROR: [gameplay]\mysql\server.Lua:12: [MYSQL][ERROR] Connection failed!
[2020-03-12 14:44:22] WARNING: [gameplay]\mysql\server.Lua:8: Bad usage @ 'dbConnect' [Can't connect to MySQL server on 'localhost' (10061)]
[2020-03-12 14:44:22] ERROR: [gameplay]\mysql\server.Lua:12: [MYSQL][ERROR] Connection failed!

 

 

 

Ribiata Spasite 

Link to comment
  • Other Languages Moderators
On 12/03/2020 at 16:07, Maladoy.16 said:

[2020-03-12 14:44:00] WARNING: [gameplay]\mysql\server.Lua:8: Bad usage @ 'dbConnect' [Can't connect to MySQL server on 'localhost' (10061)]
[2020-03-12 14:44:00] ERROR: [gameplay]\mysql\server.Lua:12: [MYSQL][ERROR] Connection failed!
[2020-03-12 14:44:08] WARNING: [gameplay]\mysql\server.Lua:8: Bad usage @ 'dbConnect' [Can't connect to MySQL server on 'localhost' (10061)]
[2020-03-12 14:44:08] ERROR: [gameplay]\mysql\server.Lua:12: [MYSQL][ERROR] Connection failed!
[2020-03-12 14:44:08] WARNING: [gameplay]\mysql\server.Lua:35: Bad argument @ 'dbQuery' [Expected db-connection at argument 3, got boolean]
[2020-03-12 14:44:15] WARNING: [gameplay]\mysql\server.Lua:8: Bad usage @ 'dbConnect' [Can't connect to MySQL server on 'localhost' (10061)]
[2020-03-12 14:44:15] ERROR: [gameplay]\mysql\server.Lua:12: [MYSQL][ERROR] Connection failed!
[2020-03-12 14:44:22] WARNING: [gameplay]\mysql\server.Lua:8: Bad usage @ 'dbConnect' [Can't connect to MySQL server on 'localhost' (10061)]
[2020-03-12 14:44:22] ERROR: [gameplay]\mysql\server.Lua:12: [MYSQL][ERROR] Connection failed!

 

 

 

Ribiata Spasite 

Проверь MySQL соединение.

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...