ALTER TABLE command not working in MYSQL
<p>I am using the following code to correct a spelling mistake made during creation of the table trips.</p>

<pre><code>   ALTER TABLE trips CHANGE store_and_fwd_flad TO  store_and_fwd_flag varchar(3);
</code></pre>

<p>However, I get the following error message:</p>

<blockquote>
  <p>ERROR 1064 (42000): 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 'TO store_and_fwd_flag varchar(3)' at line 1</p>
</blockquote>

<p>Where am I going wrong? I have tried using single inverted commas as well but it gives an error.</p>