Learning MySQL - UPDATE Statements

This tutorial covers how to update the data in your MySQL tables by using a SQL UPDATE statement.

[stachowi]

hands down, you're the best web dev tutorials out there... I'm looking forward to taking all of your courses.

[AlexDaCT]

Still relevant, thank you Professor! Nice to see you showing good practices to newbies too.

[scottgonzalez]

Steve!! Thanks so much for your videos. Knowledge delivered via the friendliest voice on the interwebs.

[ajipboy]

Thank you so much! I've been following these tutorials since last night and it helped me tremendously

[yevgeniydiriyenko]

was stuck on a question and this showed me how to figure it out

[_V__.]

I didn’t even know about sub-queries! Thank you!

[guyfinkelshtein]

''ANOTHA ONE'' - DJ KHALED VOICE, best teacher on the

[ndeas]

I have a question that I can't understand. It is:
-- decrease the rents of the properties whose rent is above the average by 5% --
In my table that I'm trying to update, I have the columns "propertyNo, street, city, postcode, propertyType, rooms, rent, ownerNO, staffNo, branchNo". The table name is "propertyforrent".
I tried this,
{
update propertyforrent
set rent = rent * .95 where rent > (select avg(rent) from propertyforrent);
}
but it says -- Error Code: 1093. You can't specify target table 'propertyforrent' for update in FROM clause
I also tried,
{
update propertyforrent
set rent = rent * .95 where rent > avg(rent);
}
but got -- Error Code: 1111. Invalid use of group function

[alternativeenergyresearch]

Hello make java pusher so yhat every one minute MySQL is updated from Excel since my excel is updated every one minute

[alternativeenergyresearch]

Make step by step video by java pusher