HelloCho

- Create Table CREATE TABLE `tblDataTest` ( `seq` bigint(20) NOT NULL AUTO_INCREMENT, `data` varchar(2048) NOT NULL DEFAULT '', ); - Insert Data insert into tblDataTest(`seq`, `data`) values(1, '{"id":1,"level":1,"players":[123, 456]}'), (3, '{"id":2,"level":2,"players":[789, 1112]}'), (2, '{"id":2,"level":2,"players":[1112, 123]}'); - Result seq data 1 {"id":1,"level":1,"players":[123, 456]} 2 ..

MySql ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS mysql 설정 문제로 인해 발생 문제가 되는 database 에서 쿼리를 실행해보자 SET GLOBAL log_bin_trust_function_creators='ON';