sql-update Archives - Page 2 of 2

How do I (or can I) SELECT DISTINCT on multiple columns?

I need to retrieve all rows from a table where 2 columns combined are all different. So I want all the sales that ...

May 4, 2022
0 Comments

MySQL – UPDATE query based on SELECT Query

I need to check (from the same table) if there is an association between two events based on date-time. One set of data ...

April 29, 2022
0 Comments

How to do an update + join in PostgreSQL?

Basically, I want to do this: update vehicles_vehicle v join shipments_shipment s on v.shipment_id=s.id set v.price=s.price_per_vehicle; I’m pretty sure that would work in ...

April 28, 2022
0 Comments

SQL update query using joins

I have to update a field with a value which is returned by a join of 3 tables. Example: select im.itemid ,im.sku as ...

April 24, 2022
0 Comments

Update a table using JOIN in SQL Server?

I want to update a column in a table making a join on other table e.g.: UPDATE table1 a INNER JOIN table2 b ...

April 18, 2022
0 Comments

MySQL error code: 1175 during UPDATE in MySQL Workbench

I’m trying to update the column visited to give it the value 1. I use MySQL workbench, and I’m writing the statement in ...

April 15, 2022
0 Comments

SQL update from one Table to another based on a ID match

I have a database with account numbers and card numbers. I match these to a file to update any card numbers to the ...

April 15, 2022
0 Comments

How can I do an UPDATE statement with JOIN in SQL Server?

I need to update this table in SQL Server with data from its ‘parent’ table, see below: Table: sale id (int) udid (int) ...

April 12, 2022
0 Comments