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

[Kernell]

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

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

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

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

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

[rapgod1]

local queryHadle = dbQuery( 
    sqlLink, -- ссылка на коннект с базой 
  
    -- запрос 
    "SELECT * FROM testTable;" 
) 

queryHandle

[Maladoy.16]

[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 

[Disinterpreter]

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 соединение.

[Maladoy.16]

On 19/03/2020 at 21:33, Disinterpreter said:

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

kak podkliuciti mysql?

[Disinterpreter]

6 hours ago, Maladoy.16 said:

kak podkliuciti mysql?

вводишь в свой конфиг айпи логин и пароль