Mark W's SQL Blog

Opinions, experiences and information about SQL and the databases that process it, from a guy who's been at it for over 20 years.

Sunday, August 22, 2010

Oww...My Brain!

http://thedailywtf.com/Articles/A-Confusing-SELECTion.aspx

No need for further comment.
on August 22, 2010 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Pages

  • Home
  • Privacy Policy
  • Cookie Policy

About Me

My photo
MWrynn
DBA/Developer working with a slew of databases, but most passionate about Postgres and Oracle. Big proponent of maximizing your database investment by taking advantage of the powerful features it has to offer. Big opponent of using your database as a generic, lowest common denominator bit bucket.
View my complete profile

Blog Archive

  • ►  2024 (5)
    • ►  December (2)
    • ►  September (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2023 (4)
    • ►  November (4)
  • ►  2021 (1)
    • ►  May (1)
  • ►  2020 (3)
    • ►  August (2)
    • ►  January (1)
  • ►  2019 (9)
    • ►  October (1)
    • ►  June (4)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2018 (12)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (3)
    • ►  August (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2017 (6)
    • ►  May (1)
    • ►  April (1)
    • ►  March (4)
  • ►  2016 (17)
    • ►  November (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (1)
    • ►  April (2)
    • ►  March (4)
    • ►  February (3)
    • ►  January (1)
  • ►  2015 (11)
    • ►  December (1)
    • ►  May (1)
    • ►  March (5)
    • ►  February (4)
  • ►  2014 (8)
    • ►  September (1)
    • ►  August (2)
    • ►  March (3)
    • ►  February (2)
  • ►  2013 (12)
    • ►  December (1)
    • ►  November (3)
    • ►  September (2)
    • ►  August (2)
    • ►  April (1)
    • ►  March (3)
  • ►  2012 (4)
    • ►  August (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2011 (24)
    • ►  December (1)
    • ►  November (3)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (4)
    • ►  May (3)
    • ►  April (3)
    • ►  March (2)
    • ►  February (2)
    • ►  January (2)
  • ▼  2010 (8)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ▼  August (1)
      • Oww...My Brain!
    • ►  June (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2009 (2)
    • ►  December (1)
    • ►  March (1)
  • ►  2008 (1)
    • ►  December (1)
  • ►  2007 (6)
    • ►  July (2)
    • ►  May (1)
    • ►  April (3)

Labels

  • 10
  • 11g
  • 12c
  • 12cR2
  • add column
  • alert log
  • Amazon
  • analytics
  • apgdiff
  • api
  • argh
  • AskTom
  • auditing
  • awesome
  • AWS
  • big data
  • bind
  • bind variables
  • bonkers
  • BoobyTrap
  • Books
  • bug
  • caching
  • cartoon
  • cern
  • character sets
  • chat
  • clone
  • cluster
  • clustered
  • clustering
  • collations
  • column
  • column store
  • columns diffs
  • common table expressions
  • comparison
  • connor mcdonald
  • crazy
  • CTE
  • CTEs
  • danger
  • database of the year
  • db-engines
  • db2
  • ddl
  • default
  • diff
  • distinct on
  • dynamic columns
  • EC2
  • emacs
  • errors
  • evil
  • Evil MySQL Feature
  • example
  • expdp
  • export
  • features
  • foreign keys
  • game
  • generate series
  • generation
  • history
  • IGNORE
  • impdp
  • import
  • in
  • incremental refresh
  • independence
  • index
  • indexes
  • inheritance
  • INSERT IGNORE
  • installation
  • Java
  • JDBC
  • join
  • joins
  • JOOQ
  • JSON
  • just bind
  • key-value
  • length
  • limitation
  • linux
  • lisp
  • load balancing
  • locking
  • locks
  • logging
  • lol
  • mandelbrot
  • maria
  • mariadb
  • MATCH_RECOGNIZE
  • materialized views
  • merge
  • microsoft
  • missing comma
  • MODIFY
  • MS SQL
  • MSSQL
  • mwrynn
  • MySQL
  • MySQL.com
  • newlines
  • News
  • numeric
  • odd
  • online recovery
  • optimization
  • optimizations
  • optional
  • oracle
  • parallel
  • parameter
  • parameterization
  • parameters
  • paramterization
  • partitioned aggregates
  • partitioning
  • performance
  • pgpool
  • pgpool-ii
  • pi
  • pi day
  • pivot
  • pl/sql
  • postgres
  • postgresql
  • preparedstatement
  • query
  • query rewrite
  • quiz
  • r/sql
  • random
  • rant
  • RDS
  • recovery
  • recursive
  • recursive query
  • reddit
  • reference
  • refresh
  • release
  • REPLACE
  • REPLACE INTO
  • reporting
  • retrosheet
  • rewrite
  • row pattern matching
  • schema
  • scripts
  • sequences
  • series
  • shared memory
  • shmmax
  • sparkfun
  • speed
  • SQL
  • SQL injection
  • SQL Server
  • sqlplus
  • sucks
  • Sybase
  • syntax
  • table
  • test
  • Tom Kyte
  • trick
  • unpivot
  • upgrade
  • upgrading
  • upsert
  • usebindvariables
  • version
  • versioning
  • weird
  • whygod
  • window
  • window functions
  • windowing
  • with
  • with recursive
  • wonky

Report Abuse

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

Followers

Search This Blog

Evil MySQL Feature: REPLACE INTO

Popular Posts

  • Arrays vs. IN-lists in SQL Using JDBC: Techniques and a Glance Under the Hood
    Intro: Alright, so say you want to run a query that has the WHERE clause WHERE id IN (...) from your Java program, using JDBC, where the co...
  • Pgpool-II Load Balancing
    I've been trying, so far unsuccessfully, to get load balancing working in a pgpool-II replication environment with two nodes. This is su...
  • Yet another performance problem solved...OR...Yet another weird MySQL quirk of lameness
    My coworker recently came up to me asking me why his index wasn't being used for a particular query (this is on MySQL) - it was just loo...
Watermark theme. Powered by Blogger.