[sqlite] Questions on ANALYZE

often ? Thanks for your answers, -- Jonathan Ballet - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] "SQL Error: near 'Table': Syntax error"

think that all SQL commands or operators (create, alter, update, where, from, select, in, as, etc...) cannot be used. Just check it by yourself ;) Jonathan Ballet

Re: [sqlite] "SQL Error: near 'Table': Syntax error"

John Newby wrote: > Does anyone know any reason why SQLite doesnt like tables called "Table" or > is this a standard SQL thing? > > Many thanks > > John > I guess that 'Table' is a reserved keyword, part of the SQL language. If you _really_ want to have a table, named 'table', you should put

Re: [sqlite] Escape issue

Adriano Monteiro wrote: > Wow... > > What a shame. I think I'm not using the right lib. > What's the diff between pysqlite2 and sqlite? > > > Cheers! 'sqlite' package seems to be linked to the SQLite 2.x version, and as far as I remember, it's not supported anymore. You should use pysqlite2,

Re: [sqlite] Escape issue

e double quote ('') to escape simple quote : "A string constant is formed by enclosing the string in single quotes ('). A single quote within the string can be encoded by putting two single quotes in a row - as in Pascal. C-style escapes using the backslash character are not supported because they are not standard SQL." http://sqlite.org/lang_expr.html Cheers, Jonathan Ballet

Re: [sqlite] Sqlite and Java

Noel Frankinet wrote: > Nilo Paim wrote: > >>> >> Hi Noel, >> >> Maybe slower, maybe memory hungry... but not less portable in my >> opinion. Java is machine independent, unless when using native code. >> On that scenario ( native code ) Java is not portable. >> >> My point is: I would like to