Horje
MySQL update with subquery Code Example
MySQL update with subquery 
update Users set Valid = 0
where Id in (
  select Id from (
    select Id from Users where Id < 100
  ) as t
)
Source: www.inforbiro.com



Sql

Related
FIND LOWEST SALARY EARNER IN SQL Code Example FIND LOWEST SALARY EARNER IN SQL Code Example
select true if exists on another table or false sqlserver Code Example select true if exists on another table or false sqlserver Code Example
sql limit to 5 results Code Example sql limit to 5 results Code Example
join in update query in mysql Code Example join in update query in mysql Code Example
postgre query date Code Example postgre query date Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje