[sqlite] (no subject)

[Uros Reljic]

http://recycling-it.com/wp-content/themes/health.google.php
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Some intresting from speco_

[Uros Reljic]

You got message
From: spe...@hotmail.com
Start

http://moppetadvisor.co.uk/newsletters/opatip.php


End

  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Building an SQLite Extension: How to check if a table exists in the database?

[Uros Reljic]

Try this


SELECT * FROM dbname.sqlite_master WHERE type='table' AND name='tbname';


Change dbname with name of your database and tbname with the name of table.


--

speco 




> To: sqlite-users@sqlite.org
> From: itandet...@mvps.org
> Date: Fri, 9 Mar 2012 20:30:55 -0500
> Subject: Re: [sqlite] Building an SQLite Extension: How to check if a table   
> exists in the database?
> 
> Wei Song  wrote:
> > I'm developing an SQLite extension which uses a function to set data into a 
> > table. I'd like to know how to check if a table
> > exists in a database? 
> 
> Just prepare the statement that you are going to use to write the data, and 
> handle any errors.
> -- 
> Igor Tandetnik
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users