update statements problem

I am trying to update a table with a file that has more than one update statements like this: UPDATE products set products_price=22.00 WHERE products_model=5217-01 OR products_model=521701 AND products_um=CS; UPDATE products set products_price=3 WHERE products_model=5217-01 OR

Re: update statements problem

-01 OR products_model=5217-01) AND products_um=CS and the same for PK and EA. The way you have you'll get an update as soon as products_model=5217-01 /Johan cybermalandro cybermalandro wrote: I am trying to update a table with a file that has more than one update statements like

another update error

Ok now I am running this statement UPDATE products INNER JOIN products_ums ON products.products_id = products_ums.products_id SET products_ums.products_ums_price=552 WHERE ( products.products_model=2420-01 OR products.products_model=242001) AND products_ums.products_ums_um=EA; and I am getting

Re: Migration of DB from MySQL 4.0.20 to 4.0.24

. Kuai cybermalandro cybermalandro wrote: Sorry about that -- -- Table structure for table `dealer_type` -- CREATE TABLE `dealer_type` ( `dealer_type_id` int(11) NOT NULL auto_increment, `dealer_type_type` varchar(40) NOT NULL default '', `dealer_type_name` varchar(40

Migration of DB from MySQL 4.0.20 to 4.0.24

I have a dump from a database in a FreeBSD box with MySQL version 4.0.20 and I am trying to import this dump to a mysql DB server which runs gentoo and a MySQL version of 4.0.24 but when I tried to do mysql dbname dbname.mysql I get this error: ERROR 1060 at line 574: Duplicate column name