mysql sql_ mode=only_ full_ group_ The problem is solved temporarily

Boring ape 2022-02-13 07:44:15 阅读数:942

mysql sql_ sql mode only_

Execute code

set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

Only temporarily valid , restart sql after , Or it doesn't work

image.png

Tried to modify the configuration file

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

useless ! my sql Version is 8.0.20

Big guys with solutions , Welcome to leave a message !

copyright:author[Boring ape],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130744139456.html