title: MySQL query works in phpMyAdmin but not in java
body: <p>I have the query</p>
  
  <pre><code>INSERT INTO tests2 (`name`, `val1`, `val2`, `val3`, `rotation~time`, `rotation~messages~countdown_format`, `rotation~messages~messages`) VALUES ('Testing', 'Test', 'false', '0', '21', 'Value', '[[Value 1,  Value 2]]')
  </code></pre>
  
  <p>which works fine in phpMyAdmin, but it gives a exception:</p>
  
  <pre><code>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ')' at line 1
  </code></pre>
  
  <p>when called in java using</p>
  
  <pre><code>statement.execute(query);
  </code></pre>
  
  <p>(I create the connection using this method:)</p>
  
  <pre><code>        connection = DriverManager.getConnection(getJDBCString(settings.host(), settings.port(), settings.database()), settings.username(), settings.password());
          statement = connection.createStatement();
  </code></pre>
  
  <p>What is wrong?</p>
  
  <p><strong>EDIT</strong>:</p>
  
  <p><em>It is my intention to have ints and booleans saved as Strings</em></p>
  
  <p><em>I also tried swapping the graves (`) for ' and "</em></p>