New answers tagged update
2
votes
MariaDB 11.0 to 11.1 GA fails with ERROR 1210 (HY000) at line 32: Incorrect arguments to DATA DIRECTORY
OK, I seem to have resolved this (after a few hours!). Changing to InnoDB per file, and doing a full repair/optimise and recreate using the old version (11) of MariaDB, then manually running ...
- 41
1
vote
Accepted
Sum column and remove lines sum
Basically you are asking to delete the records from your table I hope this is a single process.
This can be done by inserting your "final" data into a temporary table truncate your existing ...
- 3,685
1
vote
Accepted
PostgreSQL: Update multiple data while using the binding variable
Your query is
UPDATE test_tbl SET str=333
WHERE ID = floor(random()*(10-1+1))+1;
Now random() is a volatile function, that is, it can return different results if it is called several times in a ...
- 45.7k
2
votes
Accepted
UPDATE & SELECT & INNER JOIN combined (SQL92) — How?
According to the ANSI SQL-92 standard 13.9 page 391, an UPDATE using JOIN is NOT part of the standard.
You could use a correlated subquery.
Qyery,
UPDATE Table2
SET Sort = ( SELECT Sort
...
- 3,685
4
votes
Accepted
Should I worry about a serial update execution plan?
Should I worry about a serial update execution plan?
Almost certainly not in this case.
As far as I have seen (from previous EF questions) EF isn't shy about adding the OUTPUT clause to queries ...
- 83.1k
Top 50 recent answers are included