Top "Sql-update" questions

An SQL UPDATE statement is used to change existing rows in a table.

Update or Insert (multiple rows and columns) from subquery in PostgreSQL

I'm trying to do something like this in postgres: UPDATE table1 SET (col1, col2) = (SELECT col2, col3 FROM othertable WHERE …

sql postgresql sql-update
Bulk Record Update with SQL

I have two tables in a SQL Server 2008 environment with the following structure Table1 - ID - DescriptionID - Description …

sql sql-server sql-update
How to handle-escape both single and double quotes in an SQL-Update statement

I have this sample T-SQL query and trying this on SQL-Server-2008. DECLARE nvarchar(1000) @wstring = "I asked my son's teacher, "How …

sql-server-2008 sql-update
Update Multiple Rows in Entity Framework from a list of ids

I am trying to create a query for entity framework that will allow me to take a list of ids …

c# sql asp.net-mvc entity-framework sql-update
SQL Update Multiple Fields FROM via a SELECT Statement

This works, but i would like to remove the redundancy. Is there a way to merge the update with a …

sql sql-server stored-procedures sql-update
NULL value for int in Update statement

Is it possible to set NULL value for int column in update statement? How can I write the update statement …

sql sql-update
Insert the same fixed value into multiple rows

I've got a table with a column, lets call it table_column that is currently null for all rows of …

mysql sql sql-update sql-insert
How to update MySql timestamp column to current timestamp on PHP?

I want to update the columns of data type timestamp manually through my PHP code. Can you please tell me …

php mysql database timestamp sql-update
Update some specific field of an entity in android Room

I am using android room persistence library for my new project. I want to update some field of table. I …

android sql-update android-room
SQL Inner join 2 tables with multiple column conditions and update

I am using this script, trying to join 2 tables with 3 conditions and update T1: Update T1 set T1.Inci = T2.…

sql sql-update inner-join