Вот заявление:
$statement = "CREATE TEMPORARY TABLE homestead.temp_table
AS
SELECT title,content, feed, link, 'date', created_at, updated_at FROM homestead.news ORDER BY 'date' ASC LIMIT 5;
TRUNCATE homestead.news;
INSERT INTO homestead.news (title, content, feed, link, 'date', created_at, updated_at)
SELECT title, content, feed, link, 'date', created_at, updated_at FROM homestead.temp_table;
DROP TEMPORARY TABLE homestead.temp_table;";
try {
DB::statement($statement);
} catch (\Exception $e) {
echo $e->getMessage();
}
Код работает в Mysql Workbench, но не внутри laravel. Пожалуйста, помогите, это мой первый вопрос на Stackoverflow :)
полная ошибка:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUNCATE homestead.news; INSERT INTO homestead.news (title, content, feed, l' at line 4 (SQL: CREATE TEMPORARY TABLE homestead.temp_table AS SELECT title,content, feed, link, `date`, created_at, updated_at FROM homestead.news ORDER BY `date` ASC LIMIT 5; TRUNCATE homestead.news; INSERT INTO homestead.news (title, content, feed, link, `date`, created_at, updated_at) SELECT title, content, feed, link, `date`, created_at, updated_at FROM homestead.temp_table; DROP TEMPORARY TABLE homestead.temp_table;)