SQL Antipatterns, Volume 1 (Pragmatic Bookshelf)
Most Active This Week
Most Active This Month
Most Active This Year
Most Active Last Three Years

@billkarwin
You say partitioning by date_reported but in the example there is a partition by hash ( bug_id ).
New

REPLACE INTO PasswordResetRequest (account_id, token, account_id, expiration)
VALUES (123, @token, CURRENT_TIMESTAMP + INTERVAL 1 HOUR);
New

PlanetScale Vitess 14 is a great technology to supporting sharded architecture with MySQL, but it has does not support stored procedures ...
New

“illustation” should be “illustration”
New

“feature in in version 8.0”
New

Found in first printing (P 1.0). The text reads “certain verions” instead of “certain versions”.
New

@billkarwin
On page 176 , the derived-table-no-duplicates.sql code would not get the correct result if multiple product_id with the same...
New

@billkarwin
On page 186,both the rand-limit-offset.py and rand-row-number.py code uses round function, which will possibly get the total...
New
Most Active Over Three Years
Publisher:
Pragmatic Bookshelf
Latest in SQL Antipatterns, Volume 1
Get money off!

The Pragmatic Bookshelf
35% off any eBook
Use the coupon code "devtalk.com" to get 35% off any eBook published by PragProg!
Filter by Type:
Related Portals
-
None added yet