[sqlite] Does anyone know how I would uninstall sqlite?

2006-01-20 Thread twoeyedhuman
I have the latest version of sqlite3 on my debian box and I'd like to uninstall it because I keep getting this error through bash: sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot open shared obje ct file: No such file or directory I'm actually running xandros linux and I

Re: [sqlite] store result

2006-01-20 Thread manoj marathayil
thanks, i failed to notice that one, any way thanks for your replay Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 1/19/06, manoj marathayil wrote: > ok this i can do, but the problem is i need to select a set of records and i > want to manipulate with each record then only i need to delete

Re: [sqlite] Version 3.3.0 (alpha)

2006-01-20 Thread Jeff West
Does anyone have any more information or documentation on how to use the "READ UNCOMMITTED" feature of the latest version? Thanks, Jeff [EMAIL PROTECTED] wrote: SQLite version 3.3.0 is now available on the website http://www.sqlite.org/ Version 3.3.0 incorporates many enhancements and

Re: [sqlite] journal files and database corruption

2006-01-20 Thread Will Leshner
On Jan 20, 2006, at 8:25 AM, Will Leshner wrote: Thanks for this information. It sounds like a reasonable precaution might be not to make "too many" changes to a database in one transaction. But I guess knowing how many changes is too many would be a pretty hard thing to figure out.

RE: [sqlite] Decimal conversion

2006-01-20 Thread nbiggs
I was using version 3.2.1. I downloaded 3.3.1 and your suggestion worked, but it is very slow compared to 3.2.1. I use the original query to test the speed. 3.2.1 returned the data in a little over 10 seconds while 3.3.1 took a minute. Why is that? I used .dump to create .sql files and then

Re: [sqlite] journal files and database corruption

2006-01-20 Thread Will Leshner
On Jan 20, 2006, at 8:07 AM, [EMAIL PROTECTED] wrote: Deleting a hot journal after a power loss or OS crash is more likely to result in severe database corruption, but database corruption is possible from deleting a hot journal after an ordinary program crash. Thanks for this information.

Re: [sqlite] journal files and database corruption

2006-01-20 Thread drh
Will Leshner <[EMAIL PROTECTED]> wrote: > On Jan 20, 2006, at 7:41 AM, [EMAIL PROTECTED] wrote: > > > The database might be completely unusable. It depends on > > which writes completed and which had not at the time of the > > crash. > > Am I right in thinking that that would be more likely to

Re: [sqlite] journal files and database corruption

2006-01-20 Thread Will Leshner
On Jan 20, 2006, at 7:41 AM, [EMAIL PROTECTED] wrote: The database might be completely unusable. It depends on which writes completed and which had not at the time of the crash. Am I right in thinking that that would be more likely to happen in, say, a hardware failure, and less likely to

Re: [sqlite] journal files and database corruption

2006-01-20 Thread drh
Will Leshner <[EMAIL PROTECTED]> wrote: > In the article about locking and concurrency on the SQLite website, > where it talks about how to corrupt a SQLite database, it says that a > SQLite database can be corrupted if a hot journal file is missing > when SQLite reconnects to the database.

[sqlite] journal files and database corruption

2006-01-20 Thread Will Leshner
In the article about locking and concurrency on the SQLite website, where it talks about how to corrupt a SQLite database, it says that a SQLite database can be corrupted if a hot journal file is missing when SQLite reconnects to the database. What kind of corruption are we talking about,

Re: [sqlite] store result

2006-01-20 Thread Jay Sprenkle
On 1/19/06, manoj marathayil <[EMAIL PROTECTED]> wrote: > ok this i can do, but the problem is i need to select a set of records and i > want to manipulate with each record then only i need to delete that record That's why I had it separated. Select the set into a temporary table. Process the

[sqlite] Re: Checking for string length

2006-01-20 Thread Igor Tandetnik
malcom wrote: Hello, is possible with sqlite to return a row with a column string length > n chars? ex: SELECT * FROM TABLE WHERE MY_COLUMN LENGTH > 0 SELECT * FROM TABLE WHERE length(MY_COLUMN) > 0 Igor Tandetnik

Re: [sqlite] Checking for string length

2006-01-20 Thread Ran
See http://www.sqlite.org/lang_expr.html Ran On 1/20/06, malcom <[EMAIL PROTECTED]> wrote: > > Hello, is possible with sqlite to return a row with a column string > length > n chars? > > ex: SELECT * FROM TABLE WHERE MY_COLUMN LENGTH > 0 > > thanks >

[sqlite] Checking for string length

2006-01-20 Thread malcom
Hello, is possible with sqlite to return a row with a column string length > n chars? ex: SELECT * FROM TABLE WHERE MY_COLUMN LENGTH > 0 thanks

[sqlite] Re: Question about string concatenation

2006-01-20 Thread malcom
thanks a lot 2006/1/20, malcom <[EMAIL PROTECTED]>: > Hello, > Anyone can translate this SQL query to sqlite? I know that to > concatenate two string you should to use || but I can't port this > query to sql :( > > UPDATE table_name > SET column = CONCAT(column, " other text to add") >