13.2 Date and Time Data Types| dev.mysql.com
Built-In Function Name Parsing| dev.mysql.com
14.3 Type Conversion in Expression Evaluation| dev.mysql.com
ADDDATE(date,INTERVAL| dev.mysql.com
11.2 Schema Object Names| dev.mysql.com
15.1.20.4 CREATE TABLE ... SELECT Statement| dev.mysql.com
ANY_VALUE(arg)| dev.mysql.com
--help, -?| dev.mysql.com
13.2.3 The TIME Type| dev.mysql.com
To define a column that includes a fractional seconds part,| dev.mysql.com
expr| dev.mysql.com
7.1.7 Server Command Options| dev.mysql.com
6.5.4 mysqldump — A Database Backup Program| dev.mysql.com
10.9.3 Optimizer Hints| dev.mysql.com
15.2.7 INSERT Statement| dev.mysql.com
15.2.17 UPDATE Statement| dev.mysql.com
15.2.2 DELETE Statement| dev.mysql.com
13.3.2 The CHAR and VARCHAR Types| dev.mysql.com
13.3.4 The BLOB and TEXT Types| dev.mysql.com
13.3.3 The BINARY and VARBINARY Types| dev.mysql.com
7.1.11 Server SQL Modes| dev.mysql.com
13.2.2 The DATE, DATETIME, and TIMESTAMP Types| dev.mysql.com
NOT,| dev.mysql.com
15.1.20 CREATE TABLE Statement| dev.mysql.com
15.1.9 ALTER TABLE Statement| dev.mysql.com
7.1.8 Server System Variables| dev.mysql.com
Creating JSON Values| dev.mysql.com
Whenever updating a few records in an OLTP table we just use the update command. But what if we have to update millions of records in an OLTP table? If you run a large update, your database will lock those records and other transactions may fail. In this post we look at how a large update can cause lock timeout error and how running batches of smaller updates can eliminate this issue.| www.startdataengineering.com