Top "Sql-update" questions

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

Conditional UPDATE in MySql

I am trying to UPDATE values from a table but i need to add some conditions. I found the function …

mysql sql sql-update
How do I do large non-blocking updates in PostgreSQL?

I want to do a large update on a table in PostgreSQL, but I don't need the transactional integrity to …

postgresql transactions sql-update plpgsql dblink
How can I update multiple columns with a Replace in SQL server?

How do I update different columns and rows across a table? I want to do something similiar to replace a …

sql sql-server sql-update dynamic-sql
Oracle ORA-00933: SQL command not properly ended?

I keep getting this error. How do I solve this problem? Error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly …

sql eclipse oracle sql-update ora-00933
Update with self-join

I want to update a table to indicate that some rows are parents of others, so I added a "parentid" …

sql oracle sql-update ora-00933
Cannot update view?

My site was developed using Drupal 6 running on a Postgresql 8.3 server on Ubuntu 11.10. Also webmin version 1.590. Now I want to …

postgresql sql-update sql-view
Recovery after wrong MySQL update query?

I made a wrong update query in my table. I forgot to make an id field in the WHERE clause. …

mysql sql sql-update data-recovery
SQL Updatable View with joined tables

I have a view that looks similar to this, SELECT dbo.Staff.StaffId, dbo.Staff.StaffName, dbo.StaffPreferences.filter_type …

sql-server view sql-update sql-view
how to Update a field in Cakephp

i am newbie in Cakephp so I feel difficulties to implement the database queries .. what i want is I want …

cakephp sql-update cakephp-2.0 cakephp-2.1
MySQL Query Browser How do I enter NULL?

Stupid question: In SQL, I know I can do UPDATE TableA SET MyColumn=NULL But, how do I enter NULL …

mysql sql sql-update