mariadb 10 입력시 Incorrect integer value: '' for column
mysql> set @@global.sql_mode = 'ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
my.ini
sql_mode="ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
추가
================================================================ 유저 만들기
CREATE USER 'ins_n3'@'%' IDENTIFIED BY '1234';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'ins_n3'@'%' WITH GRANT OPTION;
set password for 'ins_news4'@'localhost' = password('1111');
|
여행
윈도우서버 
