Re: [sqlite] would someone check my SQL..

You may try: SELECT NULL FROM sqlite_master WHERE tbl_name = 'table'; - Original Message - From: "Asko Kauppi" <[EMAIL PROTECTED]> To: Sent: Thursday, February 10, 2005 5:08 PM Subject: Re: [sqlite] would someone check my SQL.. Is it true that in SQLite o

Re: [sqlite] would someone check my SQL..

Is it true that in SQLite one has no way to check (at CREATE TABLE statement itself) whether the table already is there? I got this from a person more accustomed to MySQL: >in mysql, the CREATE TABLE command has a 'IF NOT EXISTS' option, but as i >said, it's a non-standard extension. >

[sqlite] would someone check my SQL..

I'm crafting a storage module based on SQLite internally. Think about it as 'ini files, but with a database'. Since this is my first touch to SQL, and the number of statements I need is rediculously small, I'd like some kind soul to 'proof-read' these and give comments. Each SQL block is a si