http://qs321.pair.com?node_id=1233504


in reply to Log4perl: Create missing SQLite file and log to it

Hello mbloecker,

Welcome to the Monastery. If you are running SQLite above 2012-03-20 (3.7.11) you can use the exact condition you mentioned :). SQLite/Release History

create table if not exists TableName (col1 typ1, ..., colN typN)

Alternatively there is a similar question on the forum SQLite Table Existence?. There a few other ways proposed :)

Hope this helps, BR

Seeking for Perl wisdom...on the process of learning...not there...yet!