In a MySQL script you can write: CREATE TABLE IF NOT EXISTS foo ...; … other stuff … and then you can run the script many times without re-creating...
I want to create a table in a SQLite database only if doesn’t exist already. Is there any way to do this? I don’t want to drop the table...
Is it possible to create a temporary (session only) table from a select statement without using a create table statement and specifying each column type? I know derived tables...