Сообщество IT-специалистов
Ответы на любые вопросы об IT
Профессиональное развитие в IT
Удаленная работа для IT-специалистов
$book = Book::where('author', $author)->firstOrFail();
всегда будут жёстко выдёргивая шнур из розетки
Что можно сделать, что бы продлить ей жизнь?
WHERE macvalue >= NOW() - INTERVAL 1 HOUR GROUP BY hour(macvalue)
WHERE FROM_UNIXTIME(VisitTime) >= NOW() - INTERVAL 1 HOUR GROUP BY hour(FROM_UNIXTIME(VisitTime))
SELECT * FROM messages WHERE receiver = 1 ORDER BY date DESC LIMIT 1
update table1 t1 left join table2 t2 on t2.`name` = t1.`name` set t1.`name` = null where t2.`name` is null
select t1.*, t2.* from (select * from class_ads where class_ads.active=1) as t1 inner join (select * from class_slugs where class_slugs.`type`='listing') as t2 on t1.id = t2.object_id
SELECT * FROM table WHERE id IN (SELECT CONCAT_WS( ",", id1, id2 ) FROM table2)
$s = 921205400655; $arr = str_split($s, 2); $r = $arr[2] . '.' . $arr[1] . '.19' . $arr[0]; echo $r;
while ($itog = mysqli_fetch_assoc($q)) { printf("%s (%s)\n", $itog["name"], $itog["year"]); }
SELECT SUBSTRING_INDEX('some-text||movie_id,bla-bla', '||movie_id', 1) AS xfields;
.... $qr_result = mysql_query("select * from " . $db_table_to_show . " order by cast( Time as unsigned ) desc") or die(mysql_error()); ....
.... ORDER BY sv DESC LIMIT 10
SELECT * FROM T WHERE id = '$curUserId' UNION SELECT * FROM T WHERE id <> '$curUserId' ORDER BY `date` ASC
select t1.* t2.name, t2.surname from reviews t1 left join users t2 on t2.id = t1.user_id
select t1.*, t2.username, t3.username from orders t1 left join users t2 on t2.userid = t1.userid left join users t3 on t3.userid = t1.fromuserid