INSERT INTO result(name) VALUES (ilya)- cur.execute(f'INSERT INTO result(name) VALUES ({data["Name"]})')
- db.commit()
- cur.execute(f'INSERT INTO result(name) VALUES({data['School_class']})')
+ cur.execute('INSERT INTO result(name, class) VALUES (?, ?)', (data["Name"], data['School_class']))document: InputFile | str
File to send. Pass a file_id as String to send a file that exists on the Telegram servers (recommended), pass an HTTP URL as a String for Telegram to get a file from the Internet, or upload a new one using multipart/form-data. More information on Sending Files »
- cursor.execute("INSERT INTO messages(message) VALUES (?)", ('text'))
+ cursor.execute("INSERT INTO messages(message) VALUES (?)", ('text',))CREATE TABLE IF NOT EXISTS STAFF_DATE(
id INTEGER PRIMARY KEY FIO,
DATE timestamp NOT NULL,
staff_id INTEGER,
FOREIGN KEY(staff_id) REFERENCES STAFF(id)
);SELECT *
FROM `table` AS `t1`
JOIN `table` AS `t2`
ON `t2`.`key` = `t1`.`key`
AND `t1`.`domain` = 'первый'
AND `t2`.`domain` = 'второй'
AND `t2`.`value` != `t1`.`value`stations (id, name);
events (card, event, station_id, sum, timestamp)