SELECT d.*, j.jobname
FROM _documents d
LEFT JOIN _jobs j ON j.id_doc = d.idSTART 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