[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 table SET preferred=0
UPDATE table SET preferred=1 WHERE column_id=1234
COMMIT
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
If you find my advice useful, please consider donating to a poor
student! You can choose whatever amount you think my advice was
worth to you. http://tinyurl.com/7oa5s
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
