Query Not working in MySQL 5.6 - [MYSQL 5.1 (Master) to MYSQL 5.6 (Slave) Replication Error]

Question

MYSQL 5.1 (Master) to MYSQL 5.6 (Slave) Replication Error

Below Query not working in MYSQL 5.6 which is working fine with MYSQL 5.1

mysql> alter table MY_DATA add column test enum('0','1') default 0 after channel_id;

ERROR 1067 (42000): Invalid default value for 'test'

Thanks. What is the difference between '0' & 0 Is there any syntax issue with 5.6 because the same query is working fine with 5.1 — Bhagwat Singh Adhikari, Jul 08 '16 at 10:00

score 0 · Answer 1 · answered Jul 08 '16 at 10:20

0

The same is resolved after running below query alter table MY_DATA add column test enum('0','1') default '0' after channel_id;

(Used '0' instead of 0 after default)

answered Jul 08 '16 at 10:20

1 Answers1