UPDATE business b, people p
SET b.email = p.email
WHERE b.business_id = p.business_id
AND p.sort_order="1"
AND b.email=""
More Related Contents:
- MySQL – UPDATE query based on SELECT Query
- MySQL, update multiple tables with one query
- MySQL update table based on another tables value
- UPDATE multiple rows with different values in one query in MySQL
- Multiple Updates in MySQL
- mysql update column with value from another table
- UPDATE multiple tables in MySQL using LEFT JOIN
- MySQL error code: 1175 during UPDATE in MySQL Workbench
- MySQL – UPDATE query with LIMIT
- mysql after insert trigger which updates another table’s column
- update multiple rows using limit in mysql?
- How to prepend a string to a column value in MySQL?
- MySQL update a joined table
- MySQL/SQL: Update with correlated subquery from the updated table itself
- MySql update two tables at once
- MySQL: update a field only if condition is met
- What are differences between INSERT and UPDATE in MySQL?
- Table is ‘read only’
- MySql – Way to update portion of a string?
- MySQL Error: Incorrect usage of UPDATE and LIMIT
- Does MySQL overwrite a column of same value on update?
- MySQL UPDATE syntax with multiple tables using WHERE clause
- mySQL UPDATE query returns “0 rows affected”
- MySQL UPDATE and SELECT in one pass
- How to create and insert a JSON object using MySQL queries?
- The best way to remove value from SET field?
- MySQL: How do I use delimiters in triggers?
- Update MySQL with if condition
- Update multiple rows with multiple ‘where’ clauses for each individual row
- MySQL update statement to store ranking positions