SQL Antipatterns, Volume 1 (Pragmatic Bookshelf)

Most Active This Week Top

Most Active This Month Top

Most Active This Year Top

Most Active Last Three Years Top

crash
@billkarwin You say partitioning by date_reported but in the example there is a partition by hash ( bug_id ).
New
crash
REPLACE INTO PasswordResetRequest (account_id, token, account_id, expiration) VALUES (123, @token, CURRENT_TIMESTAMP + INTERVAL 1 HOUR);
New
billkarwin
PlanetScale Vitess 14 is a great technology to supporting sharded architecture with MySQL, but it has does not support stored procedures ...
New
New
New
doblebis
Found in first printing (P 1.0). The text reads “certain verions” instead of “certain versions”.
New
blabla_bingo
@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
blabla_bingo
@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 Top

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!

Related Portals

    None added yet