SQLite3 trapping OperationalError
paul
paul at subsignal.org
Sat Mar 10 06:10:39 EST 2007
jim-on-linux schrieb:
> pyhelp,
>
> I set up a table in SQLite3.
>
> While running other modules I want to know if a
> table exists.
>
> SQL has a command "List Tables" but I don't think
> SQLlite3 has this command.
I think "list tables" is a mysqlism
>
> I've tried
> cursor.execute("select * from debtor where key
> is not null ")
FROM sqlite_master SELECT name WHERE type='table';
cheers
Paul
More information about the Python-list
mailing list