title: SQL - Syntax error near ','
body: <p>I can't for the life of me figure out why this query won't work no matter which one of my local databases I try (oracle, mysql, microsoft sql). </p>
  
  <pre><code>INSERT INTO testtable
  VALUES ( 'testvalue' , 12345678, 123.04, 0, '1950-01-03' )
  </code></pre>
  
  <p>For example, with Microsoft SQL Server I get an Error near ','. </p>
  
  <p>With MySQL I get </p>
  
  <p>You have an error in your SQL syntax near '12345678, 123.04, 0, )' at line 2.</p>
  
  <p>I've tried playing with it, I've looked at W3 school for the syntax of INSERT INTO. Everything looks good. What could it be?</p>
  
  <p>Thank you!</p>
  
  <p>EDIT:</p>
  
  <p>As requested: here's the layout for mysql</p>
  
  <pre>
  +------------+--------------+------+-----+---------+-------+
  | Field      | Type         | Null | Key | Default | Extra |
  +------------+--------------+------+-----+---------+-------+
  | TestString | varchar(600) | NO   |     | NULL    |       |
  | TestInt    | int(11)      | NO   |     | NULL    |       |
  | TestDouble | double       | NO   |     | NULL    |       |
  | Testbool   | tinyint(1)   | NO   |     | NULL    |       |
  | TestDate   | date         | NO   |     | NULL    |       |
  +------------+--------------+------+-----+---------+-------+</pre>
  
  <p>Also, it should be noted I can run a parameterized query using these values and it will work just fine. It's only when I go to manually create the query that it's a problem.</p>