0

I have a table with field name image_field. I want to change it to simply image.

I tried 

alter table permit change image_field image varchar(200);

I get error 

ERROR 1067 (42000): Invalid default value other field

I tried alter ignore table ... and didn't work. Help me ignore the error.

tapaljor
  • 237
  • 1
  • 6
  • 21
  • Think a simular question was asked here: [https://stackoverflow.com/questions/36882149/error-1067-42000-invalid-default-value-for-created-at](https://stackoverflow.com/questions/36882149/error-1067-42000-invalid-default-value-for-created-at) – zip4ever Aug 14 '17 at 13:54
  • I cannot change date as there are already thousands of mistaken date format. I want to skip that error. – tapaljor Aug 14 '17 at 14:03

0 Answers0