insert delayed on partitioned table

insert delayed on partitioned table

am 26.06.2009 09:01:15 von Ujang Jaenudin

--0016362853de1130d1046d3ae80e
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

lists,
I have tried utilizing partitioning (mysql 5.1.35 advanced version)

from mysql docs, it has been said that insert delayed on partitioning table
isn't supported.

and when perform insert like this:
insert delayed into tbla values(...);

the error that mentioned by documents is coming.

but when insert like this:
insert delayed into tbla select * from tbla_tmp;

it is working....

please let me know is it ok to use insert delayed on partitioning table?


--
thanks and regards
ujang | oracle dba | mysql dba
jakarta - indonesia

--0016362853de1130d1046d3ae80e--