In article <[EMAIL PROTECTED]> , [EMAIL PROTECTED] says... > Can I UPDATE an int record with MySql and add 1 to it? without extracting it > into a variable first? If so, what am I looking for in the www.mysql.com > manual. Seems it only deals with SELECT and WHERE. > > Thanks, > > John
UPDATE table SET field = field + 1 WHERE 1 (or something very like that) should work. BTW did you know your mailer adds a swag of blank lines before the disclaimer? Cheers -- Quod subigo farinam A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? A: Top-posting. Q: What is the most annoying thing on usenet? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
