BestHub
Sign in
Tagged articles
17 articles
Page 1 of 1
Aikesheng Open Source Community
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.

JSONSQL ModeSchema Migration
0 likes · 7 min read
Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix
Java Captain
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.

Character SetConfigurationInstallation
0 likes · 30 min read
Comprehensive Guide to Installing, Configuring, and Managing MySQL on CentOS Linux
php Courses
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 SettingsSQL
0 likes · 4 min read
Introduction to MySQL sql_mode and Its 10 Modes
Full-Stack Internet Architecture
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.

SQLSQL Modedata validation
0 likes · 10 min read
Understanding MySQL 5.7 SQL Mode: Default Values, Usage, and Practical Examples
ZhiKe AI
ZhiKe AI
Jul 2, 2021 · Databases

Fast Migration of Millions of MySQL Rows: Step-by-Step Guide

This article outlines a practical method for migrating MySQL tables with millions of rows by exporting data to an outfile, compressing, transferring, and loading it on the target server, while also addressing strict SQL mode errors that can arise during import.

Data MigrationLOAD DATALarge Tables
0 likes · 2 min read
Fast Migration of Millions of MySQL Rows: Step-by-Step Guide
Liangxu Linux
Liangxu Linux
Mar 16, 2021 · Databases

Master MySQL Transactions, Locks, and Advanced Functions: A Hands‑On Guide

This tutorial walks through MySQL's transaction control, lock statements, autocommit settings, manual commit and rollback, savepoints, differences between transactional and non‑transactional tables, SQL mode configurations, common SQL tricks, regular expressions, and a comprehensive catalog of built‑in functions, all illustrated with step‑by‑step examples and code snippets.

SQL ModeSavepointTransactions
0 likes · 25 min read
Master MySQL Transactions, Locks, and Advanced Functions: A Hands‑On Guide
ITPUB
ITPUB
Jan 26, 2021 · Databases

Master MySQL Transactions, Locks, and Advanced SQL Techniques

This guide walks through MySQL's advanced features, covering lock types, transaction control commands, autocommit handling, savepoints, SQL mode configuration, regular expression usage, common SQL tricks, and a comprehensive overview of built‑in functions with practical code examples.

LocksSQL ModeTransactions
0 likes · 25 min read
Master MySQL Transactions, Locks, and Advanced SQL Techniques
Full-Stack Internet Architecture
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.

SQL Modefunctionsmysql
0 likes · 23 min read
Advanced MySQL Topics: Transaction Control, Locking, SQL Mode, Regular Expressions, and Common Functions
php Courses
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 ConfigurationLaravelONLY_FULL_GROUP_BY
0 likes · 4 min read
Resolving MySQL ONLY_FULL_GROUP_BY Error in Laravel by Adjusting sql_mode and Strict Settings
Programmer DD
Programmer DD
Aug 18, 2020 · Databases

Why SELECT Columns After GROUP BY Are Restricted: MySQL Modes Explained

This article explains the SQL standard limits on SELECT columns after GROUP BY, demonstrates how MySQL's ONLY_FULL_GROUP_BY mode enforces those limits, explores various SQL modes, and clarifies why aggregated queries cannot reference non‑grouped columns directly.

GROUP BYONLY_FULL_GROUP_BYSQL
0 likes · 11 min read
Why SELECT Columns After GROUP BY Are Restricted: MySQL Modes Explained
dbaplus Community
dbaplus Community
Jun 26, 2016 · Databases

What’s New in MySQL 5.7? 16 Essential Features Every DBA Should Know

This article reviews the most important MySQL 5.7 enhancements—including stronger authentication, password expiration, account locking, simplified SSL, safer initialization, updated SQL_MODE, online DDL improvements, CJK full‑text support, temporary‑table optimizations, spatial data types, and NVM‑specific tweaks—providing practical guidance and configuration examples for DBAs.

5.7Database SecuritySQL Mode
0 likes · 11 min read
What’s New in MySQL 5.7? 16 Essential Features Every DBA Should Know