Вопросы Разработчикам Скриптов с SQL, вопросы по скриптам (мелкие вопросы)

local tMsg = DoFirstSelect("SELECT msg FROM table WHERE ip = 'ip2'")
Core.SendToAll(tostring(tMsg.ip))

Version sqlite: 3.6.11
CREATE TABLE test (id INTEGER PRIMARY KEY, content Text): true
CREATE TABLE test2 (id INTEGER PRIMARY KEY, content Text): true
INSERT INTO test (content) VALUES('value'): true
INSERT INTO test (content) VALUES('value2'): true
INSERT INTO test2 (content) VALUES('value'): false
SELECT * FROM test: true
SELECT * FROM test2: true
DROP TABLE test2: false
SELECT * FROM test2: false
UPDATE test SET content='val' WHERE id='1': true
SELECT content FROM test WHERE id='1': val

[23:40:44] Version sqlite: 3.2.7
[23:40:44] CREATE TABLE test (id INTEGER PRIMARY KEY, content Text): true
[23:40:44] CREATE TABLE test2 (id INTEGER PRIMARY KEY, content Text): true
[23:40:44] INSERT INTO test (content) VALUES('value'): true
[23:40:44] INSERT INTO test (content) VALUES('value2'): true
[23:40:44] INSERT INTO test2 (content) VALUES('value'): true
[23:40:44] SELECT * FROM test: true
[23:40:44] SELECT * FROM test2: true
[23:40:44] DROP TABLE test2: true
[23:40:44] SELECT * FROM test2: false
[23:40:44] UPDATE test SET content='val' WHERE id='1': true
[23:40:44] SELECT content FROM test WHERE id='1': val

function OnStartup()
  DoSql"CREATE TABLE test (id INTEGER PRIMARY KEY, content Text)"
  DoSql"CREATE TABLE test2 (id INTEGER PRIMARY KEY, content Text)"
  DoSql"DROP TABLE test2"
  DoSql"INSERT INTO test2 (content) VALUES('value')"
  db:close()
end

CREATE TABLE test (id INTEGER PRIMARY KEY, content Text): true
CREATE TABLE test2 (id INTEGER PRIMARY KEY, content Text): true
DROP TABLE test2: true
INSERT INTO test2 (content) VALUES('value'): false

[00:29:29] CREATE TABLE test (id INTEGER PRIMARY KEY, content Text): true
[00:29:29] CREATE TABLE test2 (id INTEGER PRIMARY KEY, content Text): true
[00:29:29] DROP TABLE test2: true
[00:29:29] INSERT INTO test2 (content) VALUES('value'): false

local function CheckSelect(request, no)
    local stmt=db:prepare(request)
    if stmt and stmt:first_row() then
      if bDebug then
        Core.SendToAll(request..": "..tostring(not no))
      end
      return true
    end
    if bDebug then
      Core.SendToAll(request..": "..tostring(no or "false"))
    end
    return nil
end

  DoSql"CREATE TABLE test (id INTEGER PRIMARY KEY, content Text)"
  DoSql"CREATE TABLE test2 (id INTEGER PRIMARY KEY, content Text)"
  DoSql"DROP TABLE test2"
  CheckSelect"SELECT * FROM test2"
  DoSql"CREATE TABLE test2 (id INTEGER PRIMARY KEY, content Text)"
  DoSql"INSERT INTO test2 (content) VALUES('value')"
  CheckSelect"SELECT * FROM test2"

CREATE TABLE test (id INTEGER PRIMARY KEY, content Text): true
CREATE TABLE test2 (id INTEGER PRIMARY KEY, content Text): true
DROP TABLE test2: true
SELECT * FROM test2: false
CREATE TABLE test2 (id INTEGER PRIMARY KEY, content Text): true
INSERT INTO test2 (content) VALUES('value'): true
SELECT * FROM test2: false

[12:13:53] DROP TABLE test2: database disk image is malformed
[12:13:53] INSERT INTO test2 (content) VALUES('value'): database disk image is malformed

local tMsg = DoFirstSelect("SELECT msg FROM table WHERE ip = 'ip2'")
Core.SendToAll(tostring(tMsg.msg))

function OnStartup()
    require "luasql.mysql" -- подключаем библиотеку
    env = assert (luasql.mysql()) -- вызываем основную функцию из библиотеки
    con = assert (env:connect("test","root","пароль","localhost"))    -- соединяемся с базой данных
    res = assert (con:execute[[
        CREATE TABLE IF NOT EXISTS MsgTop(
        Nick varchar(50) NOT NULL PRIMARY KEY,
        Msg MEDIUMINT(10) NOT NULL
        )
    ]])
end

function OnExit()
    --cur:close()
    con:close()
    env:close()
end    

function ChatArrival(tUser, sData)
    local cur = assert(con:execute("SELECT Nick, Msg from MsgTop WHERE Nick = '"..tUser.sNick.."'"))
    row = cur:fetch ({}, "a")
    if not row then
        local res = assert(con:execute(string.format("INSERT INTO MsgTop VALUES ('%s', '%s')]], tUser.sNick, 1")))
    else
        local iMsg = row.Msg + 1
        local res = assert(con:execute("UPDATE MsgTop SET Msg = "..iMsg.." WHERE Nick = '"..tUser.sNick.."'"))    
    end
end

      local iMsg = row.Msg + 1
        local res = assert(con:execute("UPDATE MsgTop SET Msg = "..iMsg.." WHERE Nick = '"..tUser.sNick.."'"))

assert(con:execute("UPDATE MsgTop SET Msg = Msg+1 WHERE Nick = '"..tUser.sNick.."'"))

con:execute("SELECT Nick, Msg from MsgTop ORDER BY Msg")

SELECT select_expression FROM table WHERE where_definition ORDER BY col_name [ASC | DESC]

require "luasql.mysql"
local env = assert(luasql.mysql())
local con = assert(env:connect("test","root","пароль","localhost"))

assert(con:execute[[
  CREATE TABLE IF NOT EXISTS `MsgTop`(
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `Nick` VARCHAR(64) NOT NULL,
    `Msg` MEDIUMINT(10) NOT NULL DEFAULT 0,
    PRIMARY KEY(`id`),
    UNIQUE(`Nick`)
  )
]])

function OnExit()
    con:close()
    env:close()
end    

function ChatArrival(tUser, sData)
  con:execute(("INSERT INTO `MsgTop` (`Nick`) VALUES ('%s')"):format(tUser.sNick))
  con:execute(("UPDATE `MsgTop` SET `Msg` = `Msg` + 1 WHERE `Nick` = '%s'"):format(tUser.sNick))
end

assert(con:execute"CREATE TABLE IF NOT EXISTS TABLE(`field` INT)")

assert(con:execute"CREATE TABLE IF NOT EXISTS `TABLE`(`field` INT)")