sql_mode | BestHub

Aikesheng Open Source Community

Jun 3, 2025 · Databases

Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix

The article details a MySQL 5.7 bug where rollback SQL generated for a JSON NOT NULL column produces an empty string instead of NULL, explains the underlying binlog behavior, reproduces the issue with sample tables, and provides a practical workaround by converting the JSON column to TEXT before re‑importing the data, while recommending strict SQL_MODE for production.

Database TroubleshootingJSONMySQL

0 likes · 7 min read

Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix

Java Captain

May 12, 2025 · Databases

Comprehensive Guide to Installing, Configuring, and Managing MySQL on CentOS Linux

This tutorial walks through preparing the environment, installing and uninstalling MySQL on CentOS 7, configuring firewalls, setting up remote access, handling character sets, adjusting security policies, managing SQL modes, and best practices for case sensitivity and version‑specific password policies.

ConfigurationInstallationLinux

0 likes · 30 min read

Comprehensive Guide to Installing, Configuring, and Managing MySQL on CentOS Linux

Aikesheng Open Source Community

Sep 10, 2024 · Databases

Understanding MySQL SQL_MODE: Values, Settings, and Migration Practices

This article explains MySQL's SQL_MODE system variable, its default values for different versions, common configuration options, how it influences data validation and migration, and provides practical code examples for adjusting and testing SQL_MODE settings.

MySQLSQL Settingsdata validation

0 likes · 13 min read

Understanding MySQL SQL_MODE: Values, Settings, and Migration Practices

php中文网 Courses

Mar 21, 2023 · Databases

Introduction to MySQL sql_mode and Its 10 Modes

This article explains the MySQL sql_mode setting, details each of its ten modes—including STRICT_TRANS_TABLES, STRICT_ALL_TABLES, and ONLY_FULL_GROUP_BY—provides a command to view the current mode, and also includes a brief promotion for a PHP training class.

Database ConfigurationDatabase SettingsMySQL

0 likes · 4 min read

Introduction to MySQL sql_mode and Its 10 Modes

Aikesheng Open Source Community

Oct 9, 2022 · Databases

Understanding MySQL Timestamp Default Values and Zero‑Date Handling

This article explains how MySQL determines default values for TIMESTAMP columns, the effect of the explicit_defaults_for_timestamp parameter, when zero‑date values are permitted via sql_mode, and demonstrates the behavior through four test scenarios with corresponding SQL statements and results.

MySQLdefault valueexplicit_defaults_for_timestamp

0 likes · 5 min read

Understanding MySQL Timestamp Default Values and Zero‑Date Handling

Full-Stack Internet Architecture

Jul 19, 2021 · Databases

Understanding MySQL 5.7 SQL Mode: Default Values, Usage, and Practical Examples

This article explains MySQL's SQL Mode concept, lists the default mode values for MySQL 5.7, demonstrates how to view and change the mode with SQL commands, describes the impact of common modes such as STRICT_TRANS_TABLES and ONLY_FULL_GROUP_BY, and provides a complete reference table of all supported mode values and predefined mode combinations.

Database ConfigurationMySQLSQL

0 likes · 10 min read

Understanding MySQL 5.7 SQL Mode: Default Values, Usage, and Practical Examples

Full-Stack Internet Architecture

Jan 26, 2021 · Databases

Advanced MySQL Topics: Transaction Control, Locking, SQL Mode, Regular Expressions, and Common Functions

This article provides a comprehensive guide to advanced MySQL concepts, covering transaction control, various lock levels, lock and unlock statements, autocommit settings, savepoints, SQL security issues, SQL mode configurations, regular expression usage, and a collection of useful string, numeric, date‑time, and flow functions with practical examples.

FunctionsMySQLTransaction

0 likes · 23 min read

Advanced MySQL Topics: Transaction Control, Locking, SQL Mode, Regular Expressions, and Common Functions

php中文网 Courses

Jan 25, 2021 · Databases

Resolving MySQL ONLY_FULL_GROUP_BY Error in Laravel by Adjusting sql_mode and Strict Settings

This article explains how to troubleshoot and fix the MySQL 5.7 ONLY_FULL_GROUP_BY error in a Laravel application by inspecting sql_mode, understanding Laravel's strict mode behavior, and customizing the framework's mode configuration to remove the problematic setting without changing global MySQL settings.

Database ConfigurationLaravelMySQL

0 likes · 4 min read

Resolving MySQL ONLY_FULL_GROUP_BY Error in Laravel by Adjusting sql_mode and Strict Settings

Top Architect

Sep 14, 2020 · Databases

Why SELECT Columns Not in GROUP BY Cannot Be Referenced After Aggregation in MySQL

This article explains the SQL standard restriction that only grouped keys, aggregate functions, or constants may appear in the SELECT clause of a GROUP BY query, demonstrates the resulting error in MySQL, and discusses how SQL modes like ONLY_FULL_GROUP_BY enforce this rule.

AggregationGROUP BYMySQL

0 likes · 11 min read

Why SELECT Columns Not in GROUP BY Cannot Be Referenced After Aggregation in MySQL

Aikesheng Open Source Community

Apr 16, 2019 · Databases

MySQL 5.7 to 8.0 Upgrade Guide: Requirements, Steps, and Precautions

This article outlines the practical experience of upgrading MySQL from version 5.7 to 8.0, detailing version requirements, the specific upgrade tasks, step‑by‑step procedures, and important considerations such as deprecated sql_mode settings, character set handling, and lower_case_table_names consistency.

MySQLUpgradeVersion Migration

0 likes · 7 min read

MySQL 5.7 to 8.0 Upgrade Guide: Requirements, Steps, and Precautions