Mysql updating multiple rows
Regards, Tomas Helgi I'm not a mysql guy so that syntax might be iffy, but I thought it was correct. I don't see any logic in this and I believe that this could produce strange issues like this you are dealing with. other than adding "t" to the name column, and aliasing "e" on the inner query what is different from what I posted orginally? Isn't that how you initialize a variable for use within the query to generate row numbers? The challenge are: -there are number of location that needs to be updated (A01 to A40) -each of the location varies in the number of items (A01 might have E01 and E02 for TYPE1 but for A02 there might be only 1 E01) There is a fixed logic that 1 set of 3 rows needs to update the ADDRESS column with 1 then next 3 rows 2 and subsequently. If I'm not seeing something I apologize, please elaborate Thank you expert for the help so far. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. if an alias is all it needs that's easy to fix UPDATE entity t SET address = (SELECT CEIL((@i := @i 1) / 3) FROM (SELECT name FROM entity order by referencekey) s ,(select @i := 0) where = ) x where name like 'A01%TYPE%E%'; Thanks for the reply Tomas Helgi. This code here (select @i := 0) , what is your idea with that ?
The following My SQL statement will update pub_lang column with NULL if purch_price is more than 50.
In the following rows of item table, 'value' column which is marked with red rectangle will be updated.
PHP Script Sample Output: Multiple Updates in My SQL Sample table: table1 Problem If you want to update the val1 with 5,8 and 7 for concerned id 1,3 and 4 and the other val1 will remain same and the val2 will be updated with 13 and 5 for the concerned id 2 and 4 and the other will remain same, the following update statement can be used by using IF and CASE.
My SQL UPDATE with WHERE My SQL UPDATE command can be used with WHERE clause to filter (against certain conditions) which rows will be updated.
The following My SQL statement will update the 'receive_qty' column of newpurchase table with a new value 25 if the value of purch_price is more than 50.