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

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

Update

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


using update query with subquery in Oracle sql

Updated May 03, 2016 08:02 AM