SELECT A.row_id, A.name FROM A
INNER JOIN B ON (B.table_a_id = A.row_id)
WHERE B.status_id = 1 OR B.status_id = 2
GROUP BY A.row_id, A.name
HAVING SUM(1) = 2
SELECT st.id AS id, st.name AS name, MONTH(st.date_time) AS Month
FROM stat as st
LEFT JOIN bonus as bs ON st.date_time = bs.date_time
WHERE st.name IN('lol', 'strange')
GROUP BY st.id, st.name, MONTH(st.date_time)
1 | 1024 | record1
2 | 2048 | record2
3 | 4096 | record3
1 | 3072 | record1
2 | 2048 | record2
3 | 4096 | record3
таким образом мы поменяли только одну записьSELECT DATE_FORMAT(date, "%d.%m.%Y") as dayOrder,
CASE WHEN status = 0 THEN COUNT(*) ELSE 0 END as new,
CASE WHEN status = 1 THEN COUNT(*) ELSE 0 END as confirmed,
CASE WHEN status = 2 THEN COUNT(*) ELSE 0 END as refusal
FROM orders
GROUP BY DATE_FORMAT(date, "%d.%m.%Y")
product(id, manufactured_id, name)
manufactured (id, name)
SELECT *
FROM manufactured
LEFT JOIN product ON product.manufactured_id = manufactured.id
WHERE product.id IS NULL
SELECT *
FROM manufactured
LEFT JOIN product ON product.manufactured_id = manufactured.manufactured_id
WHERE product.product_id IS NULL
<form ...>
<div ...><input name="values[]" ...></div>
</form>
<form ...>
<div ...><input name="values[]" ...></div>
<div ...><input name="values[]" ...></div>
</form>
<?php
//скрипт в который происходит submit
...
$values = implode(";", $_POST["values"]);
//сохранить в базу строку $values
?>
//скрипт отображения form-ы
<form ...>
<?php
//достать $values из базы
$arr = explode(";", $values);
for ($arr as $value)
{
echo "<div><input name=\"values[]\" value=\"$value\" /></div>";
}
?>
<imput type="submit" />
</form>
TABLE POST {id, text}
TABLE CATEGORY {id, name}
TABLE CATEGORY_POST {id, category_id, post_id}
SELECT POST.id, POST.text, GROUP_CONCAT(CATEGORY.name SEPARATOR ', ') AS categories FROM POST
JOIN CATEGORY_POST ON (POST.id = CATEGORY_POST.post_id)
JOIN CATEGORY ON (CATEGORY.id = CATEGORY_POST.category_id)
GROUP BY POST.id, POST.text
select * from mails where name = "name";
илиselect * from mails where name = 'name';
mysql_query("SELECT * FROM mails WHERE name='$template'");
0000000000000000000000000
псевдо код
bool write(f, char[2][2] data, start_x, start_y, width)
{
f_seek(f, start_y * width + start_x);
f_write(f, data[0]);
f_seek(f, (start_y + 1) * width + start_x);
f_write(f, data[1]);
return true;
}
char[2][2] read(f, start_x, start_y, width)
{
char[2][2] result;
f_seek(f, start_y * width + start_x);
result[0] = f_read(f, 2); // читаем два элемента
f_seek(f, (start_y + 1) * width + start_x);
result[1] = f_read(f, 2); // читаем два элемента
}