这样是不行的 UPDATE`table_name`SET`column_1`=valueWHERE`column_2`IN(SELECT*FROM`table_name`WHERE`column`=value) 必须得这样: UPDATE`table_name`ASalias_1INNERJOIN(SELECT*FROM`table_name`WHERE`column`=value)ASalias_2SETalias_1.column_1=valueWHEREalias_1.id=alias_2.id...
UPDATE`WarningSendMail`ASalias_1INNERJOIN(SELECT*FROM`WarningSendMail`WHEREflag=1ANDtopic_idLIKE"%2267%")ASalias_2SETalias_1.topic_id =REPLACE(alias_1.topic_id,'|2267','')WHEREalias_1.id = alias_2.id DELETE a FROM settle_merchant_sku_goods a, ( SELECT max( id ) id FROM settle_mer...
SQL Select选择 2019-12-05 11:25 − ## SQL Select(选择) 语法 SELECT 语法用于从数据库中选择数据。 返回的数据存储在结果表中,称为结果集。 --- ## SQL SELECT 语法 ```sql SELECT column1, column2, ... FROM table_name; ``` 这里,colu... 长颈鹿的脖子 0 806 SQL SELECT TOP, LIMI...
UPDATE`WarningSendMail`ASalias_1INNERJOIN(SELECT*FROM`WarningSendMail`WHEREflag=1ANDtopic_idLIKE"%2267%")ASalias_2SETalias_1.topic_id =REPLACE(alias_1.topic_id,'|2267','')WHEREalias_1.id = alias_2.id updateWarningSendMailsettopic_id=REPLACE(topic_id,'|2267','')WHEREidIN(SELECTidFROMWa...