title: Laravel 5 DB::statement return SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check
body: <p>Here is statement:</p>
  <pre><code>    $statement = &quot;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;&quot;;
  
              try {
                  DB::statement($statement);
              } catch (\Exception $e) {
                  echo $e-&gt;getMessage();
              }
  </code></pre>
  <p>Code is working in Mysql Workbench but not inside laravel.
  Please help, this is my first question on Stackoverflow :)</p>
  <p>full error:<br/></p>
  <pre><code>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;)
  </code></pre>