SQL Script with Multiple SQL Update Statements?

[Petebacher]

Does anyone know if there's some way to execute multiple SQL statements using e.g. the DB editor screen or similar?

 

Background is that I purchased a dead pre-built and pre-configured table off FB Marketplace that was set up back in 2019.  I've got it up and running, but the database is pretty sparse and I'd like to setup date and manufacturer menus in PuP.  Unfortunately, the database does not have intro year or manufacturer for any of the over 600 installed tables. I extracted the database data into a spreadsheet, where I updated it and then generated update scripts that I'd like to run against the database to update all of the empty date and manufacturer fields, but the DB Editor tool does not appear to support running multiple semicolon-delimited SQL statements.

 

Anybody got any tricks I can use?

 

Thanks

 

-Pete

Edited July 10, 2024 by Petebacher

[Petebacher]

In case anyone else has a similar need, this tool (DB Browser for SQLite) does what I needed and then some (seems like a great tool for my needs)

 

-Pete

[Petebacher]

An additional thought... 

 

If while writing my script, I key the updates on the table file name, others would be able to use this script to update their manufacturer and introduction years in the PuP database.

 

Just wondering if anybody else has any interest in such a script. Let me know here.

 

-Pete