MySQL queries the limit subquery and obtains all records of a specific day.

Write MySQL today and use limit in subqueries when there is a requirement. If you are depressed, you cannot go through it. But you only need to convert it. It is a tragedy.

Update TBL

Set isoption = 1 where userguid = 'sss' PID in (select PID from TBL where activeid = 1 and isoption = 0 limit 3)

Update tblp set isoption1 where userguid = 'ss' and PID in (select T. PID from (select PID from tblpromotion where activeid = 1 and isoption = 0 limit 3) as t)

You can. So I don't understand how SQL statements are optimized internally.

Obtain information about the current day

Select count (1) as num from tblcdkey where date_format (providetime, '% Y-% m-% D') = date_format (now (), '% Y-% m-% D ')

It is more convenient than T-SQL.