View Single Post

   
  #6 (permalink)  
Old 02-28-2008, 10:22 AM
Jerry Stuckle
 
Posts: n/a
Default Re: Moving row to different table, and changing value at same time

Jason wrote:
>> INSERT INTO table_b (id, cola, colb, colc, cold) SELECT 17238m cola,
>> colb, colc, cold FROM table_a where id=477

>
> Just so that I can understand this...
>
> When you wrote SELECT 17238m, was the "m" a typo, or does it have a
> special meaning that I'm not aware of?
>
> TIA,
>
> Jason
>


A typo - should be a comma (17238,)

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Reply With Quote