Tagged articles

SQL Tips

2 articles · Page 1 of 1
liandk
liandk
Aug 14, 2026 · Databases

Safe SQL UPDATE Practices: Changing Phone Numbers, Statuses, and Prices Without Risk

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 ModificationDatabaseSQL
0 likes · 2 min read
Safe SQL UPDATE Practices: Changing Phone Numbers, Statuses, and Prices Without Risk
21CTO
21CTO
Jun 5, 2019 · Databases

12 Proven SQL Tricks to Supercharge Your Database Performance

This article presents twelve practical SQL optimization techniques—from using proper comparison operators and LIMIT clauses to indexing strategies and query consistency—to dramatically improve database query speed and overall application performance.

Query PlanningSQLSQL Tips
0 likes · 5 min read
12 Proven SQL Tricks to Supercharge Your Database Performance