Hopefully someone will be able ot help me with a MYSQL batch command. My colleague has just finished listing 100 new prodcuts on the website but I've just reviewed them and she's use the wrong attribute for all of them (3mm 50m Roll) instead of (3mm 30m Roll).

The product ID's start at 5045 and go all the way through to 5145. I have edited the attributes in 5045 so that these ones are correct. Can anyone help with a way to bath copy attributes to all the other products, so copy attributes to product Id's 5046-5145, replacing them with the attributes from 5045?

Please, there must be a way :)