Martin Prochnow - development:database
https://martin-prochnow.de/
2026-04-07T19:15:09+00:00Martin Prochnow
https://martin-prochnow.de/
https://martin-prochnow.de/_media/wiki/logo.pngtext/html2023-05-01T08:10:18+00:00Anonymous (anonymous@undisclosed.example.com)Datenbanken
https://martin-prochnow.de/development/database/index?rev=1682928618&do=diff
Datenbanken
* <http://sqlfiddle.com/>
SQLite
Case-insensitive ORDER BY
SELECT
_column_
FROM
_table_
ORDER BY
_column_
COLLATE NOCASE ASC;
Update einer Tabelle mit Werten aus einer anderen
UPDATE _table1_ SET
_columnA_ = (
SELECT
_columnB_
FROM
_table2_
WHERE
_table2_._id_ = _table2_.id
)
WHERE
EXISTS (
SELECT
1
FROM
_table2_
WHERE
_table2_._…