2 messages in com.mysql.lists.javaRe: iterate and delete through a HEAP...
FromSent OnAttachments
Alan Ezust16 May 2005 12:14 
Alan Ezust18 May 2005 07:08 
Subject:Re: iterate and delete through a HEAP table - updatable result sets
From:Alan Ezust (alan@gmail.com)
Date:05/18/2005 07:08:14 AM
List:com.mysql.lists.java

My workaround was to make a composite key of all the columns, and that made it possible for me to iterate and delete each element.

thanks --alan

On 5/18/05, Clayburn Juniel <clay@yahoo.com> wrote:

You didn't describe how you got data into the heap table.

Is there some reason why you can't make a primary key of the state and tlid as befor.