Alex Rivera | Logout

Questions tagged sql-update

48 questions

Sort by: Newest Votes Active
18
votes
2
answers

PyMysql UPDATE query

python mysql sql-update pymysql
asked 2013-07-20T02:29:36.230
10
votes
2
answers

How to write a query with join, update and order by?

mysql sql join sql-update sql-order-by
asked 2013-05-08T15:27:55.197
8
votes
2
answers

using if statement how to replace values

sql sql-server-2008 if-statement sql-update case
asked 2013-04-13T05:23:43.730
8
votes
1
answers

What is the time complexity of INSERT, UPDATE and SELECT in SQLite?

sqlite time insert sql-update complexity-theory
asked 2013-04-09T08:01:29.523
9
votes
1
answers

Updating database rows without locking the table in PostgreSQL 9.2

postgresql sql-update database-cursor
asked 2013-04-02T17:45:54.630
11
votes
4
answers

generate update query using django orm

python django orm sql-update
asked 2013-03-10T07:15:57.193
66
votes
5
answers

Find out the history of SQL queries

oracle-database sql-update database-administration
asked 2013-02-12T10:55:41.237
79
votes
4
answers

Don't update column if update value is null

sql postgresql null sql-update
asked 2012-11-09T10:02:00.590
8
votes
2
answers

Invalid use of group function while updating a table with sum function

mysql sql sql-update
asked 2012-11-03T07:37:51.817
18
votes
4
answers

Update multiple rows in a table from another table when condition exists

sql postgresql sql-update postgis
asked 2012-10-13T03:06:43.397
14
votes
4
answers

How to update column in a table from another table based on condition?

sql sql-server sql-update subquery multiple-tables
asked 2012-09-11T05:04:51.320
9
votes
3
answers

MySQL replication not running updates in binlog

mysql sql-update replication
asked 2012-08-07T13:25:29.273
334
votes
9
answers

mysql update column with value from another table

mysql sql sql-update
asked 2012-07-29T11:54:04.607
11
votes
2
answers

How to update only specific fields of an active record in Yii?

php activerecord yii model sql-update
asked 2012-04-23T06:01:05.690
33
votes
13
answers

Table is 'read only'

mysql freebsd sql-update
asked 2012-03-05T23:50:57.593
8
votes
1
answers

Update database schema on model change without data loss

c# entity-framework ef-code-first sql-update
asked 2012-02-22T05:34:29.193
19
votes
2
answers

MySQL: Update a full table, inserting a MD5 hash, for each row a specific one

mysql sql sql-update md5
asked 2011-11-19T19:09:31.617
40
votes
5
answers

Update rows in one table with data from another table based on one column in each being equal

sql oracle-database sql-update
asked 2011-10-27T15:52:51.780
37
votes
2
answers

Determine if CodeIgniter update query successfully affected any rows

php codeigniter sql-update rows-affected
asked 2011-09-09T22:45:46.520
17
votes
4
answers

SQL Updatable View with joined tables

sql-server view sql-update sql-view
asked 2011-09-02T08:39:31.530
28
votes
3
answers

SQL Stored Procedure: If variable is not null, update statement

sql t-sql stored-procedures sql-update
asked 2011-08-18T17:58:12.130
337
votes
8
answers

Update a table with data from another table

sql oracle-database sql-update
asked 2011-08-11T18:05:54.983
36
votes
5
answers

MySQL ON UPDATE CURRENT_TIMESTAMP not updating

mysql sql timestamp sql-update
asked 2011-04-06T18:36:52.157
23
votes
1
answers

UPDATE-no-op in SQL MERGE statement

t-sql sql-server-2008 sql-update sql-merge
asked 2011-03-15T19:05:39.250
30
votes
4
answers

How to use update trigger to update another table?

sql sql-server-2008 triggers sql-update
asked 2011-03-09T22:05:22.390
33
votes
5
answers

UPDATE with CASE and IN - Oracle

sql oracle-database sql-update
asked 2011-03-02T17:06:20.587
10
votes
1
answers

Sql Xquery How to Replace text in Update Query

sql-server sql-update xquery-sql xquery-update
asked 2011-02-23T07:08:06.407
19
votes
7
answers

SQL UPDATE, but only if the old value is null

sql null sql-update
asked 2011-01-26T15:14:54.607
58
votes
7
answers

Insert the same fixed value into multiple rows

mysql sql sql-update sql-insert
asked 2011-01-14T16:16:03.540
110
votes
6
answers

Get count of records affected by INSERT or UPDATE in PostgreSQL

sql postgresql sql-update
asked 2010-10-27T23:45:30.107
20
votes
2
answers

SQL update one column from another column in another table

mysql join sql-update
asked 2010-09-29T03:25:40.813
20
votes
7
answers

update all NULL fields MySQL

mysql sql-update
asked 2010-07-04T15:16:41.093
53
votes
10
answers

MySQL - How do I enter NULL?

mysql sql sql-update
asked 2010-05-06T21:37:45.083
207
votes
8
answers

SQL update fields of one table from fields of another one

sql postgresql sql-update dynamic-sql
asked 2010-05-04T08:27:14.663
4351
votes
40
answers

UPDATE from a SELECT

sql sql-server t-sql sql-update
asked 2010-02-25T14:36:53.113
185
votes
10
answers

Increment value in MySQL update query

php mysql sql sql-update
asked 2010-02-13T21:37:19.850
18
votes
3
answers

Add a clause to a MySQL statement without quotes using CodeIgniter's Active Record functions

php codeigniter sql-update query-builder quoting
asked 2010-01-16T02:35:48.237
21
votes
6
answers

Update Field When Not Null

mysql sql null sql-update
asked 2009-12-07T14:13:20.703
1000
votes
13
answers

Update a table using JOIN in SQL Server?

sql-server t-sql join sql-update
asked 2009-10-21T22:48:11.393
44
votes
6
answers

SQL Update Multiple Fields FROM via a SELECT Statement

sql sql-server stored-procedures sql-update
asked 2009-08-12T18:45:54.473
704
votes
12
answers

MySQL - UPDATE query based on SELECT Query

mysql select sql-update
asked 2009-08-11T20:39:40.993
537
votes
11
answers

How can I update top 100 records in SQL server?

sql sql-server t-sql sql-update
asked 2009-07-29T06:37:18.913
194
votes
6
answers

Number of rows affected by an UPDATE in PL/SQL

oracle-database plsql sql-update
asked 2009-05-14T07:21:22.210
191
votes
5
answers

UPDATE multiple tables in MySQL using LEFT JOIN

mysql sql-update
asked 2009-04-30T13:25:00.327
12
votes
3
answers

mysql + update top n

mysql sql sql-update
asked 2009-04-07T15:40:12.840
15
votes
9
answers

SQL Update woes in MS Access - Operation must use an updateable query

sql ms-access sql-update
asked 2009-02-11T14:55:00.337
615
votes
5
answers

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

sql postgresql sql-update duplicates distinct
asked 2008-09-10T15:33:10.890
454
votes
21
answers

Multiple Updates in MySQL

mysql sql sql-update
asked 2008-08-06T14:12:09.903