hi list,
i have a loop to update my table:
update tbl_idea set col1 = 'text1', col2 = NOW() where ideaID = 1;
update tbl_idea set col1 = 'text2', col2 = NOW() where ideaID = 5;
...
update tbl_idea set col1 = 'textzzz', col2 = NOW() where ideaID = XXX;
my question is can i combine above statements into one statement so i can
only do update only once?
thanks,
T. Hiep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]