Dec 19, 2023 · Databases

Why sysdate() Cannot Use Indexes While now() Can in MySQL

The article explains that MySQL's sysdate() returns the exact execution time of a statement, making it non‑deterministic and preventing index usage, whereas now() returns a constant timestamp at statement start, allowing the optimizer to treat it as a constant and use indexes effectively.

NOWSQLmysql

0 likes · 10 min read

Why sysdate() Cannot Use Indexes While now() Can in MySQL

ITPUB

Dec 24, 2022 · Databases

Master MySQL: 13 Essential Functions and Commands Every Developer Should Know

This guide walks you through 13 practical MySQL techniques—from aggregating values with GROUP_CONCAT and measuring string length with CHAR_LENGTH, to locating substrings, replacing text, retrieving timestamps, bulk inserting data, handling duplicate keys, inspecting table structures, and using diagnostic commands like EXPLAIN and SHOW PROCESSLIST—complete with ready‑to‑run SQL examples and visual results.

GROUP_CONCATInsertNOW

0 likes · 13 min read

Master MySQL: 13 Essential Functions and Commands Every Developer Should Know