0

I am using the following code to correct a spelling mistake made during creation of the table trips.

   ALTER TABLE trips CHANGE store_and_fwd_flad TO  store_and_fwd_flag varchar(3);

However, I get the following error message:

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

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

Barmar
  • 669,327
  • 51
  • 454
  • 560
Suhita Goswami
  • 1
  • 1

1 Answers1

1

"TO" is not part of sql syntax try

ALTER TABLE trips CHANGE store_and_fwd_flad store_and_fwd_flag varchar(3);
Neothorn
  • 339
  • 1
  • 7