If you don't want to make any changes in your current query then follow the below steps -
sudo vim /etc/mysql/my.cnf
A
to enter insert modeCopy and paste
[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Type esc
to exit input mode
:wq
to save and close vim.sudo service mysql restart
to restart MySQL.