Tagged articles
Update
64 articles · Page 1 of 1
The article examines a MySQL experiment where three transactions (A, B, C) interact on the same row, showing why transaction B’s UPDATE on a primary‑key field proceeds without waiting while transaction C’s UPDATE of the primary key blocks, due to the interplay of row‑level locks, gap locks, and the internal delete‑plus‑insert transformation of indexed updates.
B+TreeInnoDBLocks
0 likes · 9 min read


liandkAug 14, 2026 · Databases
This article explains how the SQL UPDATE statement modifies existing rows, emphasizes the necessity of a WHERE clause to avoid full‑table changes, provides single‑row, batch, and multi‑column examples, and advises verifying data with SELECT before executing updates in production.
Data ModificationSQLSQL tips
0 likes · 2 min read

The SLS LogStore team explains why they introduced native update and delete capabilities to the traditionally append‑only log service, detailing the design trade‑offs, the enableModify flag, row‑level addressing, API usage, practical scenarios such as billing corrections, risk label refreshes, LLM feedback, and operational edits, and the limits of the new feature.
Cloud LoggingDELETELogStore
0 likes · 14 min read


ITPUBJun 22, 2026 · Databases
The article explains how an UPDATE without an indexed WHERE clause triggers InnoDB’s next‑key locks, effectively locking the entire table, shows transaction examples that cause blocking, and recommends enabling sql_safe_updates or using FORCE INDEX to ensure the statement uses an index scan.
InnoDBMySQLUpdate
0 likes · 8 min read

The article explains how running an UPDATE without an indexed WHERE clause in InnoDB under repeatable‑read can trigger full‑table next‑key locks that block other statements, halt the service, and how using indexed predicates, checking execution plans, enabling sql_safe_updates, or forcing an index can avoid the disaster.
IndexInnoDBMySQL
0 likes · 8 min read

The mandatory Windows 11 KB5074109 January 2026 update caused severe frame‑rate drops, visual glitches, black screens, and even boot failures for many NVIDIA GeForce users, and the only confirmed remedy so far is to uninstall the update or apply the optional KB5074105 patch.
KB5074109NVIDIAUpdate
0 likes · 4 min read

A developer wrote an UPDATE statement that unintentionally used AND inside the SET clause and omitted a WHERE clause, causing MySQL to silently update every row in the table without raising any syntax errors.
MySQLSET clauseSQL
0 likes · 3 min read

When MySQL executes an UPDATE or DELETE that uses a column without an index, it must scan the entire table and acquires a combination of row, gap, and intention locks, which effectively blocks all other write operations and behaves like a table‑level lock, so adding proper indexes is essential.
IndexInnoDBMySQL
0 likes · 20 min read

The article explains that Windows 10 support ends on October 14, 2025 with the final KB5066791 patch, describes a bug and a special group‑policy rollback fix, and analyzes Microsoft's shift to a yearly Windows 11 update cadence culminating in the exclusive 26H1 preview for Snapdragon X2 ARM devices.
MicrosoftUpdateWindows
0 likes · 4 min read

This article explains why recent Windows updates can cause a reboot instead of a shutdown, details the new KB5067036 fix for Win11, describes the lingering Task Manager process bug that drains resources, and provides step‑by‑step PowerShell commands and command‑line tricks to permanently resolve the issues.
KB5067036PowerShellTask Manager
0 likes · 7 min read

The article analyzes Windows 11’s declining stability, explains how a flawed patch broke the ZeroCID activation method, details Microsoft’s clumsy fix, and offers workarounds such as offline updates and the Media Creation Tool while highlighting broader security and reliability concerns.
ActivationSecurityUpdate
0 likes · 5 min read

This article explains how MySQL 8.0.32 InnoDB generates and stores Update undo logs, detailing the log format, the meaning of each field, how to interpret the log address, and provides concrete SQL examples and shell calculations for practical insight.
Database InternalsInnoDBMySQL
0 likes · 11 min read

A security advisory warns that malicious mining code was injected into certain Vant component versions, targeting users from specific regions, and urges developers to verify their Vant version and upgrade immediately to the safe release v4.9.15.
SecurityUpdateVant
0 likes · 2 min read

Debian 12.7, the latest Bookworm update, focuses on critical security patches—including a new Shim 15.8 for UEFI boot, microcode enhancements, and updates to Ansible, Apache2, Calibre, and systemd—while providing simple upgrade commands for users of both Debian 12 and the older Debian 11 releases.
DebianPackageManagementUEFI
0 likes · 4 min read

This article dissects Python’s built‑in set type, explaining how add, pop, remove, copy, update, union and other set operations map to low‑level C functions, how the hash table handles collisions, dummy entries, resizing, and the finger optimization that speeds up element removal.
ADDCOPYPython
0 likes · 30 min read

This article investigates whether MySQL re‑executes an UPDATE statement that sets a column to its current value, comparing behavior under binlog_format=ROW and binlog_format=STATEMENT with binlog_row_image=FULL, and presents test steps, results, and conclusions.
InnoDBRowStatement
0 likes · 12 min read

This guide explains how Watchtower can automatically monitor, pull, and restart Docker containers when their images are updated, covering basic usage, scheduling, cleanup options, and manual update commands to keep deployments up‑to‑date without manual intervention.
Updateautomationcontainer
0 likes · 7 min read

This article explains the complete execution process of a MySQL UPDATE statement, covering InnoDB page structures, tablespaces, buffer pool caching, redo/undo logs, binlog, and the two‑phase commit mechanism, helping readers understand how MySQL ensures data consistency and durability.
Buffer PoolInnoDBMySQL
0 likes · 21 min read


21CTOOct 12, 2023 · Information Security
The new curl 8.4.0 release on October 11 patches a severe SOCKS5 heap buffer overflow (CVE‑2023‑38545), urging all developers and users to upgrade immediately to mitigate the dangerous vulnerability.
CVE-2023-38545SOCKS5Security
0 likes · 2 min read

This article examines how InnoDB processes UPDATE statements on a table with primary and secondary indexes, analyzes three scenarios to determine which index blocks are modified, explains the internal filtering steps, and validates the behavior by inspecting LSN changes of the affected blocks.
Database InternalsIndexInnoDB
0 likes · 14 min read

This article explains why an UPDATE statement that separates column assignments with AND fails in MySQL, how the misuse turns values into 0, and shows the correct comma‑separated syntax with examples and code snippets to reliably update multiple fields.
MySQLSQLUpdate
0 likes · 3 min read

This article explains how an UPDATE without indexed WHERE conditions can trigger full‑table next‑key locks in InnoDB, causing business downtime, and provides practical safeguards such as enabling sql_safe_updates and using FORCE INDEX to ensure safe execution.
InnoDBMySQLUpdate
0 likes · 8 min read

This article explains how to perform relational updates in MySQL using JOINs, subqueries, and multi‑table UPDATE statements, demonstrating table creation, sample data insertion, and the differences between INNER, LEFT, and RIGHT joins for keeping dependent tables in sync.
MySQLSQLUpdate
0 likes · 7 min read

The article explains why an UPDATE on the same row in MySQL can block in one transaction but not in another, by analyzing the types of row‑level locks (record, next‑key, gap) acquired during SELECT … FOR UPDATE, normal updates, and updates that modify primary‑key values, illustrating the lock behavior with B+‑tree examples.
B+TreeInnoDBMySQL
0 likes · 8 min read

This article explains MySQL row‑level locking by analyzing three transactions—A, B, and C—to show why an UPDATE on a primary‑key column can block while an UPDATE on a non‑indexed column proceeds without waiting.
B+TreeMySQLUpdate
0 likes · 7 min read


ITPUBNov 15, 2022 · Databases
This article walks through the complete lifecycle of a MySQL UPDATE statement, covering InnoDB page structure, tablespaces, the buffer pool, redo and undo logs, binlog, and the two‑phase commit process, illustrating each step with examples and command outputs.
Buffer PoolInnoDBMySQL
0 likes · 19 min read

Microsoft's Linux on Windows team announced the public rollout of WSL 0.65.1 to all Windows Insiders, introducing performance improvements, enhanced time synchronization, kernel upgrades, and numerous WSLg and compositor enhancements for a smoother cross‑platform development experience.
SubsystemUpdateWSL
0 likes · 3 min read

PHP 8.1.6, a maintenance release of the popular server‑side language, has been made available, bringing numerous bug fixes across core, date handling, FFI, FPM, hash, iconv, intl, mbstring, MySQLi, SPL, streams, and zlib components, and the PHP team encourages all 8.1 users to upgrade.
Updatebug-fixversion
0 likes · 4 min read

In MySQL, an UPDATE that modifies no actual data returns an affected‑rows count of zero, making it unreliable for business logic that distinguishes between unchanged rows and non‑existent records, so developers should avoid using this count for critical decisions.
AffectedRowsMySQLSQL
0 likes · 3 min read

A developer noticed an UPDATE statement that appeared to run without effect, discovered that using AND between column assignments is invalid in MySQL, learned the correct comma‑separated syntax, and saw how logical AND expressions can produce unexpected zero values.
Logical expressionsMySQLSQL syntax
0 likes · 3 min read

This article explains why a MySQL UPDATE statement can appear to have no effect when using AND between assignments, shows the correct comma‑separated syntax, and provides visual verification of the fix.
Data ManipulationMySQLSQL syntax
0 likes · 3 min read

The article explains that using the logical operator AND between column assignments in a MySQL UPDATE statement causes unexpected results, demonstrates the issue with sample data, and shows that multiple columns must be separated by commas to update them correctly.
MySQLSQLUpdate
0 likes · 4 min read

This article demonstrates how to use the FunTester framework to benchmark MySQL SELECT and UPDATE statements, providing sample scripts, execution results, and insights into performance tuning for typical workloads and discusses observed QPS values.
FunTesterJavaMySQL
0 likes · 7 min read

Learn the essential MySQL Data Manipulation Language commands—INSERT, UPDATE, DELETE, and TRUNCATE—including syntax variations, best practices, and step‑by‑step command‑line examples that illustrate single‑row, batch, and conditional operations, plus key differences between delete and truncate.
DELETEDMLINSERT
0 likes · 12 min read

The article explains a common MySQL UPDATE mistake where developers use AND between column assignments, shows the unexpected result of owner_code becoming 0, analyzes the logical expression behind it, and provides the correct comma‑separated syntax to reliably update multiple fields.
DebuggingMySQLSQL syntax
0 likes · 4 min read

A careless UPDATE without an indexed WHERE clause can trigger full‑table locking in InnoDB, halting business operations, but by understanding InnoDB's next‑key locks, enabling sql_safe_updates, and using FORCE INDEX you can avoid this costly mistake.
InnoDBMySQLUpdate
0 likes · 8 min read

This article experimentally demonstrates how increasing the number of secondary indexes on MySQL tables progressively degrades write operations—including INSERT, UPDATE, DELETE, and LOAD DATA—by measuring execution times across ten tables with one to ten indexes each.
DELETEINSERTLOAD DATA
0 likes · 14 min read

This tutorial walks through MySQL join techniques—including WHERE, LEFT, and INNER joins—shows how to retrieve specific columns, and provides clear examples of inserting single or multiple rows, updating records, and deleting data, all illustrated with step‑by‑step SQL code and result screenshots.
DELETEINSERTMySQL
0 likes · 7 min read

A developer’s accidental misplacement of quotation marks in UPDATE statements caused all target fields to become zero, and this article explains the MySQL parsing behavior, implicit type conversion, and how to prevent such silent data corruption.
DataIntegrityDebuggingImplicitConversion
0 likes · 5 min read

This article explains how incorrect placement of quotation marks in MySQL UPDATE statements can cause the SET values to be evaluated as boolean expressions, leading to implicit type conversion that updates fields to zero, and offers practical steps to prevent such errors.
Database ErrorsMySQLQuotation Marks
0 likes · 5 min read

A developer’s production fix using dozens of UPDATE statements unintentionally set a column to zero because of misplaced quotation marks, illustrating how MySQL’s implicit conversion and syntax quirks can turn seemingly correct SQL into disastrous data loss.
MySQLSQLUpdate
0 likes · 6 min read

The article explains how incorrectly placed double‑quotation marks in MySQL UPDATE statements change the intended string assignment into a boolean comparison that evaluates to 0, leading to all affected rows being updated with zero values, and shows how to detect and avoid this pitfall.
Database DebuggingMySQLQuote Error
0 likes · 6 min read

The article analyzes a production incident where dozens of MySQL UPDATE statements unintentionally set a column to zero because misplaced quotation marks caused MySQL to interpret the expression as a boolean comparison with implicit type conversion, and it explains how to detect and prevent such errors.
DataRecoveryDatabaseSafetyImplicitConversion
0 likes · 6 min read

The article analyzes a real‑world incident where a series of MySQL UPDATE statements with incorrectly placed quotation marks caused the entire source_name column to be set to zero, explains MySQL's implicit type conversion behavior, and shows how to recover the data using binlog analysis and flashback SQL.
DataRecoveryImplicitConversionMySQL
0 likes · 5 min read

The article explains how incorrectly placed quotation marks in MySQL UPDATE statements can cause expressions like "str_col=\"xxx\" = \"yyy\"" to evaluate to zero, leading to unintended data overwrites and highlights the importance of testing SQL in safe environments.
MySQLSQLUpdate
0 likes · 5 min read

The article explains how MySQL processes SELECT and UPDATE statements, detailing each execution stage—from client authentication and cache lookup to parsing, optimization, and execution—while highlighting the additional redo log and binlog handling required for UPDATE operations and offering practical code examples.
MySQLSQL executionUpdate
0 likes · 14 min read

This guide explains how to upgrade the Laravel installer to the latest version using Composer, covering three methods: composer require, uninstall and reinstall, and editing the global composer.json, with commands and verification steps.
BackendComposerLaravel
0 likes · 5 min read

Unity has launched the public beta of version 2020.2, introducing significant performance boosts, C# 8 support, enhanced editor workflows, and numerous rendering and optimization upgrades, while also outlining future plans for Unity 2021 and the upcoming 2020 LTS release.
2020.2C#8LTS
0 likes · 3 min read

CakePHP 4.1.2 has been released, bringing a series of bug fixes, PHP 8 compatibility improvements, enhanced type checking for validation methods, better module autoloading, millisecond‑level logging, corrected HEAD request handling, and refined database and XML entity processing.
CakePHPPHPUpdate
0 likes · 2 min read

This article investigates whether MySQL re‑executes UPDATE statements that do not change any data, comparing the behavior under binlog_format = ROW and binlog_format = STATEMENT with a full row image setting, and presents test results from two sessions.
MySQLRowStatement
0 likes · 3 min read

This article tests whether MySQL re‑executes an UPDATE statement that does not change any column values, comparing the behavior under binlog_format=ROW and binlog_format=STATEMENT on MySQL 5.7.25 running on CentOS 7.4.
InnoDBMySQLUpdate
0 likes · 3 min read

This article experimentally investigates whether MySQL re‑executes UPDATE statements that set a column to its current value, comparing behavior under ROW and STATEMENT binlog formats and revealing how InnoDB handles redundant updates.
InnoDBMySQLROW format
0 likes · 3 min read

This article investigates how MySQL handles UPDATE statements that set columns to their existing values, comparing the behavior under ROW and STATEMENT binlog formats with binlog_row_image set to FULL, and shows that duplicate updates are skipped in ROW mode but executed in STATEMENT mode.
InnoDBMySQLRow
0 likes · 3 min read

Laravel 7.14 introduces several backend enhancements including view property access in render methods, a new forceDeleted method for SoftDeletes, added filesystem and HTTP client utilities, MessageBag improvements, PSR container support, and PHP 8 reflection API compatibility, along with various bug fixes.
Updateframework
0 likes · 2 min read

This article explains the Kubernetes update mechanism, why an API update can fail due to missing resourceVersion, how patch operations differ, and the internal logic of kubectl apply and edit, providing practical guidance for choosing between update and patch in cloud‑native deployments.
KubernetesOpenKruiseUpdate
0 likes · 14 min read

This article explains how to monitor and estimate the progress of a massive MySQL UPDATE by observing rows_examined in performance_schema, deriving a progress formula, and adjusting the coefficient based on whether primary keys or only data columns are modified.
MySQLProgress MonitoringUpdate
0 likes · 3 min read

This article explains why a syntactically correct MySQL UPDATE statement may seem ineffective, demonstrates the difference between using commas and the AND operator for multi‑column updates, and provides the proper syntax to ensure the intended rows are modified.
MySQLSQL syntaxUpdate
0 likes · 3 min read

This article tests whether MySQL re‑executes an UPDATE that sets a row to its existing values, comparing the behavior under binlog_format=ROW with binlog_row_image=FULL versus binlog_format=STATEMENT, and explains why redundant updates are ignored in ROW mode.
InnoDBMySQLRow
0 likes · 3 min read


21CTODec 23, 2018 · Databases
This article examines a MySQL data‑update mishap caused by misplaced quotation marks, showing how such syntax errors turn intended string assignments into zero values, and explains the underlying expression evaluation that leads to all rows being updated to 0.
MySQLQuote ErrorSQL
0 likes · 6 min read


ITPUBDec 21, 2018 · Databases
A developer ran a series of UPDATE statements that appeared correct, but due to misplaced double‑quotation marks the WHERE clause was parsed incorrectly, causing every row's column to be set to 0; the article explains MySQL's expression evaluation, shows binlog analysis, and offers practical debugging tips.
DebuggingMySQLSQL
0 likes · 7 min read

A developer’s series of MySQL UPDATE statements unintentionally set a column to zero due to misplaced quotation marks, and the article explains how MySQL parses such syntax, the resulting data loss, and best practices to avoid similar errors.
Database ErrorsMySQLSQL
0 likes · 6 min read

This article walks through the fundamentals of SQL Server, covering installation, core SQL concepts, DML and DDL commands, and detailed examples of SELECT, INSERT, UPDATE, and DELETE statements with accompanying syntax illustrations to help beginners master relational database operations.
DELETEDatabase TutorialINSERT INTO
0 likes · 7 min read


ITPUBMay 30, 2016 · Databases
Oracle’s UPDATE and MERGE statements can both modify data, but depending on indexing, join conditions, and query complexity their execution speed varies dramatically; this article explains when each is appropriate, outlines their drawbacks, and provides real‑world examples with execution plans and optimization techniques.
OracleSQLUpdate
0 likes · 5 min read

A front‑end login slowdown was traced to a MySQL UPDATE that ran for 40 seconds because a varchar column’s charset conversion forced a full‑table scan, and the article walks through the logs, tests, and the fix of unifying the column charset to UTF‑8.
CharsetMySQLUpdate
0 likes · 7 min read
