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 g

Re: update statements problem

you need is probably: > (products_model="5217-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

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 produ

Re: Migration of DB from MySQL 4.0.20 to 4.0.24

ted you mail to the list as well. > > > > > Kuai > cybermalandro cybermalandro wrote: > > Sorry about that > > > > -- > > -- Table structure for table `dealer_type` > > -- > > > > CREATE TABLE `dealer_type` ( > > `dealer_ty

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 'deal