strange query in mysql.log

Question

I found some strange query in mysql logs(general_log_file)
Query SET SESSION sql_mode = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( @@sql_mode, "STRICT_ALL_TABLES,", ""), ",STRICT_ALL_TABLES", ""), "STRICT_ALL_TABLES", ""), "STRICT_TRANS_TABLES,", ""), ",STRICT_TRANS_TABLES", ""), "STRICT_TRANS_TABLES", "") Can anyone explain what is this? i am using Centos(7) + mariadb(5.5.56) + codeigniter(3.1.4) Thanks

Shadow · Accepted Answer · 2018-06-27 14:49:21Z

3

The query disables strict sql mode in MySQL / MariaDB on session level (e.g. for the current connection), thus reducing MySQL's compliance with the sql standards.

answered Jun 27, 2018 at 14:49

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

strange query in mysql.log

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related