Could not update from table1 to table2 in 1 statement (MySQL limit: Pls see
manual)
try select what you want to update in buffer then put it in loop (look
slower than 1 statement but try to see how it fast enough)
Sommai Fongnamthip
At 04:34 30/7/2001 -0400, Steve Prior wrote:
>Here are some t
Here are some table definitions:
CREATE TABLE x10_device_types
(
device_typename VARCHAR(20) NOT NULL,
respondstoalloff enum('TRUE','FALSE') NOT NULL,
respondstoalllightson enum('TRUE','FALSE') NOT NULL,
respondstoalllightsoff enum('TRUE','FALSE') NOT NULL,
respondstoallunitsoff enum('T
Here are some table definitions:
CREATE TABLE x10_device_types
(
device_typename VARCHAR(20) NOT NULL,
respondstoalloff enum('TRUE','FALSE') NOT NULL,
respondstoalllightson enum('TRUE','FALSE') NOT NULL,
respondstoalllightsoff enum('TRUE','FALSE') NOT NULL,
respondstoallunitsoff enum('T
