At 19:58 +0100 7/29/03, David Otton wrote:
Hi, small but disturbing oddity, this.
I have a simple table:
CREATE TABLE musician (
musicianid int(10) unsigned NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
PRIMARY KEY (musicianid)
) Type=MyISAM;
There are 50
Hi, small but disturbing oddity, this.
I have a simple table:
CREATE TABLE musician (
musicianid int(10) unsigned NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
PRIMARY KEY (musicianid)
) Type=MyISAM;
There are 50 or so lines in the table. I inserted 2 new
While the subject sounds counter-intuitive, I think I'm trying to do something simple
and I can't figure it out.
I have a simple table, "lookup", with two columns, id and decode. I want to write a
simple query that retrieves the decode if there, and the id if the row is missing for
a given lit
