?

Log in

No account? Create an account
The type of arrant pedantry up with which I will not put! - Lindsey Kuper [entries|archive|friends|userinfo]
Lindsey Kuper

[ website | composition.al ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

The type of arrant pedantry up with which I will not put! [Mar. 2nd, 2006|05:36 pm]
Lindsey Kuper
[Tags|]

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.

LinkReply

Comments:
[User Picture]From: jes5199
2006-03-03 03:11 am (UTC)
today i was letting my mind wander over the crazy things that too-human-readable syntaxes make you do, design wise, a whole thought process triggered when i saw this in the spec:
| ALTER [COLUMN] col_name
(Reply) (Thread)
[User Picture]From: flaccus
2006-03-03 04:30 am (UTC)

Well, just to be persnickety

Isn't 'put up' the verb? Up's not a preposition in that construction, so (to put accuracy over tact) you should really say "The type of arrant pedantry with which I will not put up!"

You know.

Just to be an arrant pedant.
(Reply) (Thread)
[User Picture]From: lindseykuper
2006-03-03 05:03 am (UTC)

Re: Well, just to be persnickety

Yes. That's the joke.

Sheesh. You of all people.
(Reply) (Parent) (Thread)
[User Picture]From: flaccus
2006-03-03 07:03 pm (UTC)

Re: Well, just to be persnickety

HA HA HA HA HA

Double-secret probation!
(Reply) (Parent) (Thread)
[User Picture]From: lindseykuper
2006-03-03 09:39 pm (UTC)

Re: Well, just to be persnickety

Exactly.

I think.
(Reply) (Parent) (Thread)
[User Picture]From: leadsynth
2006-03-04 04:23 am (UTC)

Re: Well, just to be persnickety

s/arrant/errant
(Reply) (Parent) (Thread)
[User Picture]From: lindseykuper
2006-03-04 06:25 pm (UTC)

Re: Well, just to be persnickety

Nuh uh.
(Reply) (Parent) (Thread)