SELECT c.date_time, COUNT(*) as cnt
FROM calendar c -- таблица о которой я написал выше
LEFT JOIN leave_people p ON c.date_time BETWEEN p.start_date AND IFNULL(p.end_date, c.date_time)
GROUP BY c.date_time
SELECT d.*, j.jobname
FROM _documents d
LEFT JOIN _jobs j ON j.id_doc = d.id
START TRANSACTION;
INSERT INTO tabl1 VALUES ('column1', 'column2');
INSERT INTO tabl2 VALUES ('column1', 'column2');
COMMIT;
mysql -u root -p
\u databasename
\. full-path-to-dump.sql
SELECT
f.app_id as app1
,s.app_id as app2
,count(*) as cnt
FROM app_technologies f
INNER JOIN app_technologies s ON s.technology_id = f.technology_id AND s.app_id <> f.app_id
GROUP BY f.app_id, s.app_id
ORDER BY cnt DESC
LIMIT 1
$changelog = $_POST['changelog'];
$changelog = preg_match('/^\s*$/', $changelog) ? 'NULL' : "'" . mysqli_real_escape_string($link, $changelog) . "'";
mysqli_query($link, "INSERT INTO tbl_name (changelog) VALUES ({$changelog)}");
PHPGeo — простая библиотека для измерения расстояния между двумя координатами с высокой точностью. Она использует формулу Гаверсинуса и Винсента для вычисления расстояния. Вы можете интегрировать ее с любым приложением, связанным с картами или местоположениями.
mysql -u root -p
SELECT user, host, password FROM mysql.user WHERE user='Вася';
UPDATE mysql.user SET password=PASSWORD('Noviy Passw0Rd, ik') WHERE user='Вася' AND host='locahost';
SELECT h.*, count(*) as comfort_cnt
FROM `hotels` h
INNER JOIN `comfort` c ON c.`hotelId` = h.`id` AND c.`comfortId` IN ('1', '2', '3', '4')
WHERE h.`type` IN ('1', '2')
GROUP BY h.`id`
HAVING comfort_cnt = 4
INSERT INTO `billings` (user_id, billing_type, currency_id)
SELECT
b.user_id
,b.billing_type
,c.id as currency_id
FROM (
SELECT 11 as user_id, 1 as billing_type UNION
SELECT 11 as user_id, 2 as billing_type UNION
SELECT 11 as user_id, 3 as billing_type
) b
INNER JOIN `currency` c ON c.name='usd'