On 20 Jun 2002, at 11:35, Richard DeWath wrote: > Just a thought on something I was reading with temp tables: > > 1. extract the records you want to change the date on from your existing > table to a temp table. > 2. update the date in the temp table > 3. insert the "new" records back into the original table. > > This avoids the csv extract and changing then reinserting.
You don't need a separate step to update the date. When extracting the records into the temporary table, just change "SELECT Code, Model, Units, Year" to "SELECT Code, Model, Units, 2003" in your SQL. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php