Let us take a closer look at how to set sql_mode in my.cnf for MySQL in detail. With the assistance of our MySQL support services at Bobacres, we can give you a step-by-step guide on how to set it up
Windows & MySQL
Its easy for windows users, There you might have XAMPP or WAMPP. Within it C:/xampp/mysql/mysqld.conf . And do the same of linux and add the sql_mode=”;
Other Modes
Here you can set other modes as well. Some of the modes I have listed here.
ALLOW_INVALID_DATES
ANSI_QUOTES
ERROR_FOR_DIVISION_BY_ZERO
HIGH_NOT_PRECEDENCE
IGNORE_SPACE
NO_AUTO_CREATE_USER
NO_AUTO_VALUE_ON_ZERO
NO_BACKSLASH_ESCAPES
NO_DIR_IN_CREATE
NO_ENGINE_SUBSTITUTION
NO_FIELD_OPTIONS
NO_KEY_OPTIONS
NO_TABLE_OPTIONS
NO_UNSIGNED_SUBTRACTION
NO_ZERO_DATE
NO_ZERO_IN_DATE
ONLY_FULL_GROUP_BY
PAD_CHAR_TO_FULL_LENGTH
PIPES_AS_CONCAT
REAL_AS_FLOAT
STRICT_ALL_TABLES
STRICT_TRANS_TABLES
TRADITIONAL
May be I have missed some modes. But you can refere with mysql site to get it.
2020-07-08Varadharaj V
Share:
About Varadharaj V
The founder of Kvcodes, Varadharaj V is an ERP Analyst and a Web developer specializing in WordPress(WP), WP Theme development, WP Plugin development, Frontaccounting(FA), Sales, Purchases, Inventory, Ledgers, Payroll & HRM, CRM, FA Core Customization, PHP and Data Analyst. Database Management Advance Level