thanks for the reply dan... but is there a better/more efficent way...>????
thanks -----Original Message----- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Friday, August 11, 2006 8:13 AM To: [EMAIL PROTECTED] Cc: [email protected] Subject: Re: replace/temp tbl question... Bruce, seems like this ought to work just fine. Dan On 8/11/06, bruce <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
