$sql = "{$action} * FROM {$table} WHERE {$field} {$operator} ?";
DELETE * FROM ...
. Круто. Не знал, что так можно. Или всё-таки нельзя? $ta = mysqli_connect($link,"SELECT * FROM name_table");
$link = mysqli_connect($host, $user, $pass, $db_name); ... $link = "https://td.com/topic-$zam2";
SELECT t1.time, t1.value AS temp_val, t2.value AS hum_val
FROM topics t1
JOIN topics t2 ON t2.time = t1.time
WHERE
t1.topic = 'tempinroom' AND
t2.topic = 'huminroom'
SELECT table_name
FROM information_schema.columns
WHERE column_name = 'type_vendor'
SELECT *, price * ((100 - discount) / 100) AS discounted
FROM prices
ORDER BY discounted
LIMIT 10
NOT IN я так понял https://w3resource.com/mysql/comparision-functions... работает начиная с 5.6
CREATE TABLE users (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
login VARCHAR(255) NOT NULL,
password VARCHAR(255) NOT NULL
);
SELECT COUNT(*)
FROM `logs_ip`
WHERE
`date` > NOW() - INTERVAL 3 SECOND AND
`user_ip` = '127.0.0.1'