INSERT IGNORE INTO `table` (`field1`, `field2`, `field3`)
VALUES (`valA1`, `valA2`, `valA3`), (`valB1`, `valB2`, `valB3`)INSERT INTO `table` (`field1`, `field2`, `field3`)
VALUES (`valA1`, `valA2`, `valA3`), (`valB1`, `valB2`, `valB3`)
ON DUPLICATE KEY UPDATE `field2` = VALUES(`field2`), `field3` = VALUES(`field3`)DELETE FROM `table` WHERE `field1` IN (`valA1`, `valB1`)$sql = $construct->query("{$query}")->$fetchType;$sql = $construct->query($query)->$fetchType;
UPDATE `table` SET `updated` = 0 WHERE `user_id` = $uidINSERT INTO `table` (`user_id`, `obj_id`, `updated`) VALUES ($uid, $oid, 1)
ON DUPLICATE KEY UPDATE `updated` = 1DELETE FROM `table` WHERE `user_id` = $uid AND `updated` = 0SELECT @left_key := `left_key`, @right_key := `right_key`
FROM `tree`
WHERE `id` = $id;
SELECT *
FROM `tree`
WHERE `left_key` <= @left_key AND `right_key` >= @right_key
ORDER BY `left_key`;$byFoo = 0; $foo = '';
$byBar = 0; $bar = '';
if (isset($_GET['foo']) {
$foo = $_GET['foo'];
$byFoo = 1;
}
if (isset($_GET['bar']) {
$bar = $_GET['bar'];
$byBar = 1;
}
$query = "SELECT * FROM `baz` WHERE (? = 0 OR `foo` = ?) AND (? = 0 OR `bar` = ?)";
$mysqli->bind_param('isis', $byFoo, $foo, $byBar, $bar);INSERT INTO `table` (`key_field`, `upd_field1`, `upd_field1`)
VALUES ('key1', 'f1_val1', 'f2_val1'), ('key2', 'f1_val2', 'f2_val2')
ON DUPLICATE KEY UPDATE
`upd_field1` = VALUES(`upd_field1`),
`upd_field2` = VALUES(`upd_field2`);SELECT `c`.`name`
FROM `cabinets` AS `c`
WHERE `c`.`id` NOT IN (
SELECT DISTINCT `b`.`cabinet_id`
FROM `busy` AS `b`
WHERE `b`.`date_start` BETWEEN {$s} AND {$e}
OR {$s} BETWEEN `b`.`date_start` AND `b`.`date_end`
)