old squul

TorgoX on 2002-10-02T23:17:34

Dear Log,

On the mp3-trola: Grieg's "Ballade (Variations on a Norwegian Melody)"

So last night I worked sat down and finally learned some proper SQL -- I had been avoiding it for literally years. I figured out just enough to do what I need for my current little project:

create table foo ( ... );
insert into foo (field1, field2) values ("val1", "val2");
select * from foo;
update foo field1=null where uid = 4;
update foo set field1="thing" where uid = 4;
replace into foo (uid,field2) values (val1,val2);
delete from foo where uid = val1;
lock tables foo write;
lock tables foo read;
unlock tables;

And that's the fact, Jack.

As a language, SQL seems eerily COBOL-like. Not a language I'd want to use to target missiles with, but passable for what it is -- just an interaction layer.