Slava Rozhnev

UPDATE winka SET losse = losse + 1 WHERE user_id = 1;

UPDATE winka SET win = win + 1 WHERE user_id = 1;

create table users (
    id integer primary key autoincrement,
    mute_time int not null default 0
);

CREATE TABLE test (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  s TEXT,
  t TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO test(s) VALUES ('string');

SELECT * FROM test;

SELECT `user_id` FROM `users` WHERE `is_active` = 1

select * from users
order by case 
	when v1 > 0 then v1 
	when v2 > 0 then v2
	else v3
end desc;

$sql = "CREATE TABLE таблица1(
    id INTEGER PRIMARY KEY,
    col1 INT,
    col2 TEXT
);";
 
$db->exec($sql);

$sql = "INSERT INTO таблица1(col1, col2) VALUES 
	('aaaa', 'bbbbb'),
	('xxx', 'yyy');";

$db->exec($sql);

$sql = "SELECT * FROM таблица1;";  

$result = $db->query($sql);

while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
	$array[] = $row;
}
print json_encode($array);

insert into Main (Name, LongCode, ShortCode, Price) values 
(1,1,1,1),
(2,2,2,2),
-- --------
(100,100,100,100);

UPDATE `users` SET `time_sub` = `time_sub` + ? WHERE `user_id` = ?

const stmt = db.prepare("INSERT INTO users (user_id, user_nick, password) VALUES(?,  ?, ?)");
stmt.run(user_id,  req.body.username, req.body.passwd);
stmt.finalize();