Update and select in one query

Question

I found similar questions with correct answers. But they're a bit complicated for me. I just want a simple basic statement.

I have:

string sql = "UPDATE tblPopUp 
                 SET PopUp = 'False' 
               WHERE DisplayNo = 1"

...and:

string sql1 = "SELECT Period  
                 FROM tblPopUp 
                WHERE DisplayNo = 1"

How can I combine them?

Answer 1

UPDATE tblPopUp  
SET PopUp = 'False', Period = Period  
OUTPUT DELETED.Period
WHERE DisplayNo = 1

For more information about OUTPUT clause please check this post.

Answer 2

You can't.

There's no convention in a SQL UPDATE statement for returning data. And vice versa -- a SELECT statement doesn't write information to a table.

If you've found questions/answers that you feel are similar to what you want, please provide links.

Answer 3

The correct way to do this (now for MySQL 5+), would be with a stored procedure.