Top "Sql-update" questions

Difference between Alter and Update SQL

I am busy studying MySQL and I understand that update is used to update a record or row in a …

sql sql-update alter

Bulk/batch update/upsert in PostgreSQL

I'm writing a Django-ORM enchancement that attempts to cache models and postpone model saving until the end of the transaction. …

sql database postgresql insert sql-update

MySQL: Creating a new table with information from a query

In MySQL, I would like to create a new table with all the information in this query: select * into consultaa2 …

mysql sql insert sql-update

Advanced MySql Query: Update table with info from another table

I would like to update a table in mySql with data from another table. I have two tables "people" and "…

mysql sql-update

SQL update query syntax with inner join

Can anyone find my error in this query? I'm using SQL Server 2000 and I want to update all entries in …

sql sql-server tsql sql-server-2000 sql-update

Update mysql table with data from another table

Is it possible to run an UPDATE command on mysql 5.0 with a sub select. The command I would like to …

mysql sql-update

Updating Multiple Columns from another table - Need Oracle format

I have a script that I use in SQL Server but I need to convert it to an Oracle format. …

sql-update oracle9i

Update columns with Null values

I tried updating a table as follows: update userloginstats set logouttime = sysdate where logouttime = null; It didn't update the columns …

sql oracle null sql-update

MySQL - Update values based on subquery

let's say I have select, which return me from table1: ID Name 1 Bob 2 Alice 3 Joe Then I want UPDATE values …

mysql select sql-update

SQL Server Update Group by

I'm trying to execute this on MS-SQL but returns me an error just at the Group by line update #temp …

sql group-by sql-update