[sqlite] ANALYZE command

Hi, I recently downloaded sqlite source code via cvs repository. In this source, I found out a new command which name is ANALYZE. (analyze.c) It's like the oracle ANALYZE command, right ? Please tell me more about it and how to use. Sencerely, Mikio Kishi

[sqlite] Equivalent for SHOW FIELDS

Does SQLite provide an equivalent for the mysql SHOW FIELDS function that provides data type information about all fields in a table ? We need this feature to dynamically create/alter tables structure without requiring user interaction. smime.p7s Description: S/MIME Cryptographic Signature

[sqlite] RFC Beginning digit in column name

copyed from a co-developer Dear developers, a while back, our project decided to switch from mysql to usage of various SQL backends, among this sqlite3 as our favorite. Now recently we encountered a problem, just a tiny one, but one we are not able to solve with all used SQl backends in a

Re: [sqlite] RFC Beginning digit in column name

On 8/9/05, ender [EMAIL PROTECTED] wrote: copyed from a co-developer Dear developers, a while back, our project decided to switch from mysql to usage of various SQL backends, among this sqlite3 as our favorite. Now recently we encountered a problem, just a tiny one, but one we are not able

Re: [sqlite] RFC Beginning digit in column name

[09-08-2005 19:05, ender escreveu] [...] So my simple feature request would be: allow '`' as a quoting symbol - as mySQL does. Or - what would be as helpful as the other idea - allow unquoted column names with leading digits - as mySQL does. Does MySQL allows [0_xy] to specify column names?

Re: [sqlite] RFC Beginning digit in column name

At 8:46 PM +0100 8/9/05, Nuno Lucas wrote: [09-08-2005 19:05, ender escreveu] [...] So my simple feature request would be: allow '`' as a quoting symbol - as mySQL does. Or - what would be as helpful as the other idea - allow unquoted column names with leading digits - as mySQL does. Does

Re: [sqlite] RFC Beginning digit in column name

On 8/9/05, Nuno Lucas [EMAIL PROTECTED] wrote: [09-08-2005 19:05, ender escreveu] [...] So my simple feature request would be: allow '`' as a quoting symbol - as mySQL does. Or - what would be as helpful as the other idea - allow unquoted column names with leading digits - as mySQL does.

Re: [sqlite] RFC Beginning digit in column name

Does MySQL allows [0_xy] to specify column names? If I remember correctly, that is the standard SQL way to have columns with spaces in the middle, and sqlite allows columns starting with a digit in this way... It's not standard; it's a Microsoft extension. Regards

Re[8]: [sqlite] Accessing Database on Network

Hello, Henry No. It might be on your particular systems, but we cannot make Henry a general case. It is possible that it will always be safe on Henry (for example) Windows 2000, while not safe on NT or XP! It Henry depends on how the OS handles caching. They are supposed to Henry check on each

[sqlite] Did OSCON tutorial get accepted for AUUG in oct?

Anyone know if the OSCON tutorial was accepted for AUUG2005? klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.:

Re: [sqlite] Did OSCON tutorial get accepted for AUUG in oct?

On Wed, Aug 10, 2005 at 12:35:27PM +1000, Klint Gore wrote: Anyone know if the OSCON tutorial was accepted for AUUG2005? afaik it was but dr. hipp will not be the one giving it.

Re: Re[8]: [sqlite] Accessing Database on Network

On Wed, 2005-08-10 at 00:30 +0200, djm wrote: Hello, Henry No. It might be on your particular systems, but we cannot make Henry a general case. It is possible that it will always be safe on Henry (for example) Windows 2000, while not safe on NT or XP! It Henry depends on how the OS handles

Re: [sqlite] Did OSCON tutorial get accepted for AUUG in oct?

Is it M6 you are referring to? http://www.auug.org.au/events/2005/auug2005/tutorials.html Regards. rayB |-+ | | Klint Gore | | | [EMAIL PROTECTED]| | | u | | |