hi...
can someone tell me if this should work in theory...
basically, i'm looking to get a bunch of rows from my initial table, based
on the value of a given column/field. i'd then like to do a complete
replace/update on the values in the temp table. finally, i'd like to write
everything in the replaced/updated tmp table back to the orignal tbl...
i'm essentially using 3 steps to get this accomplished...
create tmp table temp
select a.appName, a.universityID
from appTBL a
where a.complete = 0
replace into temp
(appName, universityID)
values(%s,%s)
replace into appTBL
select t.appName, t.universityID
from temp t
thoughts/comments/etc...
-thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
