SELECT answers.*, count(*) as cnt
FROM answers
LEFT JOIN likes ON likes.answerID = answer.id
GROUP BY answer.idSELECT TABLE_SCHEMA, TABLE_NAME, MAX(CREATE_TIME) created FROM information_schema.tables
GROUP BY TABLE_SCHEMA
ORDER BY createdSELECT TABLE_SCHEMA, TABLE_NAME, MAX(CREATE_TIME) created FROM information_schema.tables
GROUP BY TABLE_SCHEMA
HAVING created < (NOW() - INTERVAL 1 MONTH)
ORDER BY created$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);$connectionParams = array(
'dbname' => 'mydb',
'user' => 'user',
'password' => 'secret',
'host' => 'localhost',
'driver' => 'pdo_mysql',
);
$conn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams);near 'FROM... указывает в точности на причину. В запросах UPDATE ... не должно быть никакого FROM
UPDATE images SET src = REPLACE(src, '/images\\', '/images/')select * from orders
where id not in (
select distinct order_id from applications
)и делаем двойное хешированиеерунда это.
$name = $_POST['name'];
...
mysqli_query($db,"INSERT INTO users SET name='".$name."', ...Каждый раз, когда необходимо использование БД я подключаю файл: