Top "Sql-update" questions

Use SELECT inside an UPDATE query

How can I UPDATE a field of a table with the result of a SELECT query in Microsoft Access 2007. Here's …

sql ms-access-2007 sql-update

mysql after insert trigger which updates another table's column

i'm trying to write a trigger, I have following tables: BookingRequest: +-----------+---------+------+-----+---------+----------------+ | Field | Type | Null | …

mysql sql-update triggers

MySQL Update Column +1?

I was wondering what would be the easiest way to update a column by +1? I will be updating a post …

mysql sql sql-update aggregate-functions

SQL Update to the SUM of its joined values

I'm trying to update a field in the database to the sum of its joined values: UPDATE P SET extrasPrice = …

sql sum sql-update

When running UPDATE ... datetime = NOW(); will all rows updated have the same date/time?

When you run something similar to: UPDATE table SET datetime = NOW(); on a table with 1 000 000 000 records and the query takes 10 …

mysql sql datetime sql-update

How to update and order by using ms sql

Ideally I want to do this: UPDATE TOP (10) messages SET status=10 WHERE status=0 ORDER BY priority DESC; In English: I …

sql sql-server tsql sql-order-by sql-update

SQL update undo

Is there a way we can undo a SQL update query?

sql sql-update undo

PHP MYSQL UPDATE if Exist or INSERT if not?

I have no idea if this is even remotely correct. I have a class where I would like to update …

php mysql sql-update sql-insert on-duplicate-key

Table is 'read only'

When I want to execute an update query on my table I got an error saying: 1036 - Table data is …

mysql freebsd sql-update

Update MySQL with if condition

It seems I have big problems with conditional queries. I have to do a conditional update. I write here what …

mysql sql sql-update