How can I change my existing column in MariaDB to Not Null?
<blockquote>
  <p>Message    : 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 ''country_of_residence_id' INTEGER NOT NULL' Statement  :
  ALTER TABLE address ALTER COLUMN 'country_of_residence_id' INTEGER NOT
  NULL</p>
</blockquote>

<p>In my table 'address' I want to set an already existing column 'country_of_residence_id' to NOT NULL.</p>

<p>I tried it this way:</p>

<pre><code>ALTER TABLE address
ALTER COLUMN 'country_of_residence_id' INTEGER NOT NULL;
</code></pre>

<p>My IDE underlines INTEGER and says: DROP or SET expected, got "INTEGER"</p>

<p>When I add SET before INTEGER it doesn't work either.</p>