Question?
I've created a heap table using the following SQL command.
"create table if not exists ticketitemtemp (ticketid int(11) not null, serviceitemid int(11) not null, colorid int(2), price decimal(5,2), quantity int(1), total decimal(5,2)) type=HEAP"
Ticketitemtemp is where I will store temporary records. When someone cancels out, I want to get rid of all tickets that matches the ticketid field ie. ticketid=2.
I use the following SQL command for that.
"delete from tickettemp where ticketid='$ticketid'"
This should work. However, it only deletes 1 record at a time. Is this an inherent limitation with heap tables or am I doing something wrong. I'm currently running MySQL 3.23.21-beta.
