Horje
join in update query in mysql Code Example
inner join in update query mysql 
UPDATE business AS b
INNER JOIN business_geocode AS g ON b.business_id = g.business_id
SET b.mapx = g.latitude,
  b.mapy = g.longitude
WHERE  (b.mapx = '' or b.mapx = 0) and
  g.latitude > 0
Source: stackoverflow.com
join in update query in mysql 
UPDATE employees
    LEFT JOIN
    merits ON employees.performance = merits.performance 
SET 
    salary = salary + salary * 0.015
WHERE
    merits.percentage IS NULL;Code language: SQL (Structured Query Language) (sql)
Source: www.mysqltutorial.org



Sql

Related
postgre query date Code Example postgre query date Code Example
postgres extract date from timestamp Code Example postgres extract date from timestamp Code Example
opening xampp mysql in cmd ubuntu Code Example opening xampp mysql in cmd ubuntu Code Example
psql check tables command Code Example psql check tables command Code Example
sql limit order by Code Example sql limit order by Code Example

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



 

Horje