title: How to rename a column name in maria DB
body: <p>I am new to SQL, I was trying to change column name in my database's table. I am using 'xampp' with 'maria DB' (OS - Ubuntu 18.04)  </p>
  
  <p>I tried all of the followings:  </p>
  
  <pre><code>ALTER TABLE subject RENAME COLUMN course_number TO course_id;
  ALTER TABLE subject CHANGE course_number course_id;
  ALTER TABLE subject CHANGE 'course_number' 'course_id';
  ALTER TABLE subject  CHANGE COLUMN 'course_number'  course_id varchar(255);
  ALTER TABLE subject CHANGE 'course_number' 'course_id' varchar(255);
  </code></pre>
  
  <p>But the only output I got was:  </p>
  
  <blockquote>
    <p>ERROR 1064 (42000): 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 'column course_number to course_id' at line 1  </p>
  </blockquote>
  
  <p>Could someone please tell me what is the correct answer. I have no idea what to do further.</p>