title: SQL error #1064. Alter table with default values
body: <p>I tried to do an <code>ALTER TABLE</code> to add some columns with a default value. Why I do I have this error?</p>
  
  <p>I tried with:</p>
  
  <pre><code>column_name varchar(255) NOT NULL DEFAULT '0',
  </code></pre>
  
  <p>and also with</p>
  
  <pre><code>column_name varchar(255) NOT NULL DEFAULT 0,
  </code></pre>
  
  <p>but it didn't work in both.</p>
  
  <pre><code>ALTER TABLE utenti
  ADD
  missileBalistico varchar(255) NOT NULL DEFAULT 1,
  missileBalisticoPotenza varchar(255) NOT NULL DEFAULT 60,
  ...,
  aiuti varchar(255) NOT NULL DEFAULT 0;
  </code></pre>
  
  <p>It gaves me 31 same errors:</p>
  
  <pre><code>Unrecognized alter operation. (near "," at position ...)
  </code></pre>
  
  <p>And MySQL said:</p>
  
  <pre><code>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(255) NOT NULL DEFAULT 60,
  basi varchar(255) NOT NULL DEFAULT 1,
  vitaBa' at line 4
  </code></pre>