mysql update based on select result, How combine?

by Роман Моргунов   Last Updated August 17, 2018 20:06 PM

Here are two SQL statements. One is an select statement and the other is a update statement. I want to combine them.


SELECT * FROM test WHERE `id`='1'


UPDATE test SET `select_count`=`select_count`+'1' WHERE `id`='1'
Tags : select update

Related Questions

Update several values from several ID's

Updated June 29, 2017 14:06 PM

PostgreSQL update and select in one query

Updated December 20, 2018 14:06 PM

using update query with subquery in Oracle sql

Updated May 03, 2016 08:02 AM