Андрей Ежгуров

INSERT INTO table3
SELECT table1.*
FROM table1
LEFT JOIN table2
  ON table1.id = table2.id
WHERE table2.id IS NULL

SELECT * FROM `products` WHERE `available`='1' AND `sex` IN ('0', '2') ORDER BY `order`

$data = $db->query("SELECT `price` FROM `price` WHERE `name` IN(test,test2,test3)");

var_dump("SELECT `price` FROM `price` WHERE `name` IN(".implode(',', $name_id).")");

SELECT a.* FROM Apartment a
  LEFT JOIN Apartment_Dates ad
    ON ad.apartment_id=a.id AND ? BETWEEN ad.arrival_time AND ad.departure_time
  WHERE ad.id IS NULL

DELIMITER $$

CREATE DEFINER = 'root'@'%' TRIGGER answers_after_insert
AFTER INSERT ON answers FOR EACH ROW
BEGIN
  UPDATE questions
  SET questions.count = questions.count + 1
  WHERE questions.question_id = NEW.question_id;
END

$$

CREATE DEFINER = 'root'@'%' TRIGGER answers_after_delete
AFTER DELETE ON answers FOR EACH ROW
BEGIN
  UPDATE questions
  SET questions.count = questions.count - 1
  WHERE questions.question_id = old.question_id;
END

$$

DELIMITER;