Возможность перехвата ошибки функцией, определенной в set_error_handler():
- Перехватываемые (не фатальные и смешанные)
E_USER_ERROR, E_RECOVERABLE_ERROR, E_WARNING, E_NOTICE, E_USER_WARNING, E_USER_NOTICE, E_STRICT, E_DEPRECATED, E_USER_DEPRECATED.- Не перехватываемые (фатальные)
E_ERROR, E_PARSE, E_CORE_ERROR, E_CORE_WARNING, E_COMPILE_ERROR, E_COMPILE_WARNING.
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
$url = 'http://antonkurilov.ru/russian.xml';
$rss = simplexml_load_file($url);
$i = 1;
foreach ($rss->channel->item as $item) {
echo '<a href="'.$item->guid.'" target="_blank">'.$item->title.'</a>';
if (++$i > 10) break;
}
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