Awesome MySQL behavior of the day
Tuesday, March 18th, 2008Consider this table schema and data:
CREATE TABLE `foo` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`up` INT UNSIGNED NOT NULL DEFAULT ‘0′,
`down` INT UNSIGNED NOT NULL DEFAULT ‘0′,
PRIMARY KEY (`id`)
);
INSERT INTO `foo` (`up`, `down`) VALUES(0, 1);
Now, consider this query:
mysql> SELECT (`up` [...]
