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

  • Chicago to San Juan: 4 hrs 40 mins

    The marathon went better than I could have imagined. I got to hang out with Amanda and Sean all weekend, see San Juan Island, eat lots of delicious…

  • Krazy West Koast Travel Month

    From the 15th-18th, I'll be in Los Angeles with much of my mom's side of the family for a combination of Father's Day celebration for my grandpa and…

  • East until we're west

    Yesterday afternoon I played hooky from work to go hiking with Amanda, Brian, and Amanda's friend Scott. We drove east of the city to the Columbia…

  • 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