title: Multiple sql statments (execute all) with eclipse data tools
body: <p>I use the Eclipse SQL Editor (Eclipse Data Tool Platform 1.9.0) in STS 2.7.1 based on Eclipse 3.7. (Database is MySQL 5.5)</p>
  
  <p>If I have the SQL Scrapbook (or any other file) and put some SQL DDL statements in it where every single statement is written on a single line ending with <code>;</code> (that is the configured delimiter in eclipse) then I can execute all statements together (Execute All Ctrl+Alt+X). That works without problems, eclipse execute each statment as a single statement.</p>
  
  <p>But if i have normal insert statements in the same format (each line/statement ending with <code>;</code>) then executing all statements together fails. Eclipse seams to try to handle all the statements in one SQL statement. That fails and MySql report an syntax error.</p>
  
  <pre><code>INSERT INTO `folder` (`id`, `businessId`, `status`, `title`, `parent_Folder_fk`) VALUES(1, 1544565486, 'ACTIVE', 'Root', NULL);
  INSERT INTO `folder` (`id`, `businessId`, `status`, `title`, `parent_Folder_fk`) VALUES(6, 1802811831392782301, 'ACTIVE', 'Ralphz', 1);
  ...
  </code></pre>
  
  <blockquote>
    <p>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 'INSERT INTO <code>folder</code> (<code>id</code>, <code>businessId</code>, <code>status</code>, <code>title</code>, <code>parent_Folder_fk</code>)' at line 2  </p>
  </blockquote>
  
  <p>I can execute each line separate (Select the line and Excecute Selection Alt+X). So I guess there is no failure in the statements, but something is wrong with splitting the statements.</p>
  
  <p>Where is my mistake?</p>