Mark a single row?

Hallo, I would like a single row in a table, and not more than one, to be used as a preferred value in another application. Is this possible, and, if yes, how? Groetjes, Hans. --- GoldED+/LNX 1.1.5/050823 * Origin: The Wizard is using MBSE/Linux (2:280/1018) -- MySQL General

Re: Mark a single row?

[EMAIL PROTECTED] wrote: Hallo, I would like a single row in a table, and not more than one, to be used as a preferred value in another application. Is this possible, and, if yes, how? add a column 'preferred', tinyint(1) NOT NULL. To change the preferred value: START TRANSACTION UPDATE

Re: Mark a single row?

Hallo Jasper, Op 29 Aug 05 schreef Jasper Bryant-Greene aan mysql: I would like a single row in a table, and not more than one, to be used as a preferred value in another application. JBG add a column 'preferred', tinyint(1) NOT NULL. Thank you! Groetjes, Hans. ---

Re: Mark a single row?

[EMAIL PROTECTED] wrote: Hallo Jasper, Op 29 Aug 05 schreef Jasper Bryant-Greene aan mysql: I would like a single row in a table, and not more than one, to be used as a preferred value in another application. JBG add a column 'preferred', tinyint(1) NOT NULL. Thank you! Groetjes,

Re: Mark a single row?

Hallo Michael, Op 29 Aug 05 schreef Michael Stassen aan [EMAIL PROTECTED]: I would like a single row in a table, and not more than one, to be used as a preferred value in another application. JBG add a column 'preferred', tinyint(1) NOT NULL. MS It's hard to say without knowing just