Lindsey Kuper (lindseykuper) wrote,
Lindsey Kuper
lindseykuper

The type of arrant pedantry up with which I will not put!

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.

Tags: programming
Subscribe

  • Marathon (Part the First)

    On race day, I got up at 3:30 a.m. I was in Evanston and needed to be at the starting line at McCormick Place before six, and I didn't have a car. I…

  • Marathon logistics

    On a brighter note, the marathon is tomorrow morning, and I went down to McCormick Place to get my Marathon Packet, which consists of a bib number…

  • I feel like all my journal entries lately have been of epic length

    ...and yet there's all this stuff that I haven't been covering. I barely wrote about graduation, and I didn't say much about iD training or the…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 7 comments