PostgresSQL 10: JSONB update value of complex key/value structure1

postgresql-10

Anonymous 1800Anonymous 1800

5As a forewarning: if you find yourself needing to do this, it means the data probably wants to be normalised. Answered more fully in...

PeterVandivier

Select Start and End date6

mysql-5.6

Anonymous 1749Anonymous 1749

8This is a *Gaps and Islands* problem. You want to determine "islands" of consecutive dates based on certain conditions. Once you have identified them, you can apply `MIN()` and `MAX()` to each island to obtain the boundaries ("from" and "to" dates).

Andriy M

SQLite 5 tables, Join, Sum, GroupBy2

sqlite

Anonymous 1739Anonymous 1739

Troubles with 'WHERE...IN' clause2

sqlite

Anonymous 1732Anonymous 1732

How do I automate the import of CSV files into a PostgreSQL db at a specific time (each day)?6

postgresql-11

khakha

7Put your COPY command into a SQL script, then run psql from within a batch file. To avoid the password prompt, use [environment variables](https://www.postgresql.org/docs/current/libpq-envars.html) inside the batch file.

Truilus

How do you make the last insert in this fiddle increment beyond 2?3

mysql-5.5

Howard BrownHoward Brown

3From [the docs](https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html):

Jack Douglas

Does using an array of jsonb ever make sense?3

postgresql

TruilusTruilus

2I'm really glad I read all the way to the end of the question:

Jack Douglas

How to assign a corresponding row-id number to each row in a table18

sqlite

FoggyFinderFoggyFinder

4`row_number` does appear to be what you are looking for:

Jack Douglas

db fiddle, Markdown export, Firebird

dbfiddle

AriochArioch

In MySQL, how to update a whole table in the default safe mode?14

mysql

anoldmanintheseaanoldmaninthesea

2Yes that is the 'proper' way to do it, or (better) simply turn off safe mode temporarily:

Jack Douglas