SELECT answers.*, count(*) as cnt
FROM answers
LEFT JOIN likes ON likes.answerID = answer.id
GROUP BY answer.id
SELECT TABLE_SCHEMA, TABLE_NAME, MAX(CREATE_TIME) created FROM information_schema.tables
GROUP BY TABLE_SCHEMA
ORDER BY created
SELECT 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."', ...
про sql инъекции не слыхал еще? Каждый раз, когда необходимо использование БД я подключаю файл: