[sqlite] Feature req: Shell .open command should inform user what file it opened

In the command shell, the .open command will either open an existing file or create a new one if it doesn't already exist. This can be confusing. It's even more confusing on Windows if the user has forgotten that the path should be written with forward slashes instead of the usual Windows

[sqlite] Import 5000 xml files in a sqlite database file

Hi, I have more than 5000 xml files. All files have the same xml-structure. Each file has different values (timestamps, numbers and strings). I would like to put all these values in a sqlite database tabke, all in one table. => Import the data values into a sqlite database table. Can you

[sqlite] Problem with alter table add column

Hello I don't understand the sqlite command "alter table add column". Please help me! I have the following 2 tables: TABLEONE(columnA INTEGER PRIMARY KEY, columnB TEXT); TABLETWO(columnX INTEGER PRIMARY KEY, columnY TEXT); I want to add a new column "cloumnZ" to TABLETWO. The new column must