Delete records in one table not present in another: HOW?

Question

In a "base" table of SQLite, there is a reference column:

refX

Another "content" table contains this same column, but many of its records are not listed in the base table.

How do I delete the records in the "content" table that are NOT in the "base" table?

score 2 · Accepted Answer · edited Mar 03 '18 at 03:39

2

DELETE FROM Content WHERE refX NOT IN (SELECT refX FROM Base);

edited Mar 03 '18 at 03:39

Confused

answered Mar 02 '18 at 17:35

CL.

Having deleted tens of thousands of records, the database is still the same size on the disk. Is this normal? – Confused Mar 02 '18 at 18:00
1

See [change sqlite file size after “DELETE FROM table”](https://stackoverflow.com/q/2143800/11654). – CL. Mar 02 '18 at 18:02
"Attached databases can be vacuumed by appending the appropriate schema-name to the VACUUM statement." – CL. Mar 02 '18 at 18:09
Sorry, I'm so new to this I have NO IDEA what a schema-name actually is, what it's talking about... nothing. No clues. – Confused Mar 02 '18 at 18:11

1 Answers1