On Mon, Sep 20, 2010 at 7:36 AM, Shawn Green (MySQL)
wrote:
> Hello Hank,
>
> On 9/18/2010 9:35 PM, Hank wrote:
>>
>> I have the following pseudo code running on mysql 4.x:
>>
>> set @cnt:=0;
>> insert ignore into dest_table
>> select t1.field1, t1.field2, t1.field3, t2.field1,
>> t1.fiel
Hello Hank,
On 9/18/2010 9:35 PM, Hank wrote:
I have the following pseudo code running on mysql 4.x:
set @cnt:=0;
insert ignore into dest_table
select t1.field1, t1.field2, t1.field3, t2.field1,
t1.field3, t2.ts, @cnt:=...@cnt+1
from table1 as t1 left join table2 as t2 using (f
