MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Perform UPDATE on rows from a SELECT
Posted by: Peter Brawley
Date: January 30, 2017 12:40AM

Is this what you mean?

update path
join files using(idpath)
set files.playCount = 1, files.lastPlayed = '2017-01-29 12:00:00'
where files.playcount is null and path.strpath like 'smb%_archive_%' and files.strfilename <> ""

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Perform UPDATE on rows from a SELECT
Rick Macdonald
January 29, 2017 10:15PM
Re: Perform UPDATE on rows from a SELECT
Peter Brawley
January 30, 2017 12:40AM
Re: Perform UPDATE on rows from a SELECT
Rick Macdonald
January 30, 2017 03:39PM
Re: Perform UPDATE on rows from a SELECT
Peter Brawley
January 30, 2017 06:05PM
Re: Perform UPDATE on rows from a SELECT
Rick Macdonald
January 30, 2017 06:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.