| The type of arrant pedantry up with which I will not put! |
[Mar. 2nd, 2006|05:36 pm]
Lindsey Kuper
|
ALTER TABLE `foo` CHANGE `bar` `baz` TINYINT(1) DEFAULT '0' NOT NULL;
UPDATE TABLE `foo` SET `bar` = '0' WHERE `bar` != '2';
You only need the TABLE keyword with ALTER or DROP, because those statements could apply to either a table or a database. So that means that "UPDATE TABLE" is hypercorrection.
I'm smrt.
|
|
