I try to update multiple rows in a federated table with one query, where field a=x and field b=x.. There are 4 rows that match these criteria (selecting returns 4 rows) but trying to update using the following query updates only one record. calling the same query 4 times, updates only one record per request.
whats going wrong here, it's a simple basic query.. updates only 1 record (should update 4 records) ----------------------------------------------- update tbl_lager set fld_shopid=0 ,fld_orderid=0 where fld_orderid=10 and fld_shopid=3 repeating this query 4 times updates 1 record/update the 5th update updates no record (correct) a similar query (select instead of update) returns 4 records, as it should .. --------------------------------------------------------------------------------- select * from tbl_lager where fld_orderid=10 and fld_shopid=3 returns 4 records, correct e.g. this query runs correct ans updates 4 records: --------------------------------------------------- update tbl_lager set fld_shopid=0 ,fld_orderid=0 where fld_pid=1911 does anybody have a similar problem/ any tips? The queries are executed on mySql 5.0.18-max, the server containing the physical data is running 4.1.18-nt. (Both servers are running on the same machine (my notebook, running xp home, sp2, mysql 5 on port 3306 and mysql 4.1 on port 3307) heres the structure of the federated table: CREATE TABLE `tbl_lager` ( `fld_autoid` int(11) NOT NULL auto_increment, `fld_pid` int(11) NOT NULL default '0', `fld_hid` int(11) NOT NULL default '0', `fld_ekp` decimal(14,2) NOT NULL default '0.00', `fld_mwst` int(11) NOT NULL default '0', `fld_indatum` datetime NOT NULL default '0000-00-00 00:00:00', `fld_status` int(2) NOT NULL default '0', `fld_orderid` int(11) NOT NULL default '0', `fld_shopid` int(3) NOT NULL default '0', PRIMARY KEY (`fld_autoid`), UNIQUE KEY `fld_autoid` (`fld_autoid`), KEY `fld_pid` (`fld_pid`), KEY `fld_hid` (`fld_hid`), KEY `fld_mwst` (`fld_mwst`), KEY `fld_orderid` (`fld_orderid`), KEY `fld_status` (`fld_status`), KEY `fld_shopid` (`fld_shopid`) ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://user:[EMAIL PROTECTED]:3307/dbname/tbl_lager'; thx -- Sebastian Mork <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
