Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql update from select on same table

UPDATE users SET status = 1
WHERE id = (
  SELECT id FROM (
    SELECT id FROM users WHERE id = 10
  ) u
)
Source by www.inforbiro.com #
 
PREVIOUS NEXT
Tagged: #mysql #update #select #table
ADD COMMENT
Topic
Name
1+9 =