Re: [sqlite] SQL and SQLite pronounciation?

- Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: "sqlite-users" Sent: Wednesday, April 04, 2007 2:24 PM Subject: [sqlite] SQL and SQLite pronounciation? Hi All, I have a simple question; how do you pronounce SQL and SQLite? In the book

Re: [sqlite] SQL query problem

- Original Message - From: "Umesh Persad" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 16, 2007 10:32 AM Subject: [sqlite] SQL query problem Hi, I was wondering if anyone can help with a problem I have having with SQL. I have a table 'people' in a Sqlite

[sqlite] creating indices from my app vs sqlite3.exe

___BACKUP INFO___ I've got a single database, with about 10,000 records (the file is 944KB). I have a feature that will re-populate the database from external disk files. If the database is already populated, then the feature just walks the disk files and validates that each file is already

Re: [sqlite] Searching for data

I do this in the following way: SELECT * FROM tbl WHERE (cola LIKE '%hello%' OR colb LIKE '%hello%' OR colc LIKE '%hello%') AND (cola LIKE '%juan%' OR colb LIKE '%juan%' OR colc LIKE '%juan%') AND (cola LIKE '%casa%' OR colb LIKE '%casa%' OR colc LIKE '%casa%') This will return all records that

[sqlite] pragma table_info(...) documentation?

I'm needing to find some information about a table, and the table_info pragma seems to be the right ticket. I've looked around, and failed, to find any documentation on this cool pragma. It appears to return 6 columns of data per table-column. I believe they are as follows: [1] = column#

[sqlite] How to create a database without sqlite?

I been reading this list for several days, but just started using it today. I'm using it as an embedded database (on Windows), and want to be able to create the initial database from within my app -- meaning, I don't want to ship a database file. What is the recommended method for creating a