Re: [sqlite] sqlite-users Digest, Vol 56, Issue 5

I wanna insert into a value to my sqlte db: insert into mydb (number1) select count(number1) from db2 where number1>80; but it doesn't work ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite-users Digest, Vol 56, Issue 5

2012/8/6 YAN HONG YE : > I wanna insert into a value to my sqlte db: > > insert into mydb (number1) select count(number1) from db2 where number1>80; > > but it doesn't work sqlite> CREATE TABLE db2(number1 int, name text); sqlite> INSERT INTO db2 VALUES (20,'Name 2'); sqlite>

Re: [sqlite] sqlite3 database unreadable on Mountain Lion

On Fri, Aug 3, 2012 at 10:33 AM, Tobias Giesen wrote: > Hello, > > here's a problem that's puzzling me. > > I have one particular type of database that has become unreadable on > the new Mac OS 10.8. It must be related to the SQL structure. The error > I get is "database

Re: [sqlite] sqlite3 database unreadable on Mountain Lion

Running Mountain Lion, I got: 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc for: sqlite3 :memory: 'SELECT sqlite_source_id()' On Mon, Aug 6, 2012 at 7:26 AM, Richard Hipp wrote: > On Fri, Aug 3, 2012 at 10:33 AM, Tobias Giesen >wrote:

Re: [sqlite] sqlite3 database unreadable on Mountain Lion

On Mon, Aug 6, 2012 at 8:04 AM, Chris Smith wrote: > Running Mountain Lion, I got: > 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc > Have you upgraded your SQLite? Because Doug Currie at http://www.mail-archive.com/sqlite-users@sqlite.org/msg71932.html gives

Re: [sqlite] sqlite3 database unreadable on Mountain Lion

On 6 Aug 2012, at 1:04pm, Chris Smith wrote: > Running Mountain Lion, I got: > 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc > > for: > sqlite3 :memory: 'SELECT sqlite_source_id()' For comparison, in a pre-release version of Mountain Lion I get $ which

[sqlite] Select rows where a column is not unique

Guys, I'm sure this is a pretty lame question, but my thinking hat is malfunctioning this morning. How can I select all rows from a table where a specific column is NOT UNIQUE? Table has three columns (charge_code, mnemonic, description). Thanks, Jerry Tilsley Sr Systems Analyst St. Claire

Re: [sqlite] Select rows where a column is not unique

Tilsley, Jerry M. wrote: > I'm sure this is a pretty lame question, but my thinking hat is > malfunctioning this morning. How can I select all rows from a > table where a specific column is NOT UNIQUE? select * from MyTable where SpecificColumn in ( select

Re: [sqlite] Select rows where a column is not unique

On Mon, Aug 6, 2012 at 2:58 PM, Tilsley, Jerry M. wrote: > Guys, > > I'm sure this is a pretty lame question, but my thinking hat is > malfunctioning this morning. How can I select all rows from a table where > a specific column is NOT UNIQUE? Table has three columns

Re: [sqlite] Select rows where a column is not unique

Igor, Which of those would be fastest? Or don't you have enough information to tell? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Monday, August 06, 2012 9:14 AM To: sqlite-users@sqlite.org

Re: [sqlite] Select rows where a column is not unique

Thanks all for quick response. I was able to eliminate my duplicates very easy! -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Paul van Helden Sent: Monday, August 06, 2012 9:15 AM To: General Discussion of SQLite Database

Re: [sqlite] Select rows where a column is not unique

On 8/6/2012 9:24 AM, Rob Richardson wrote: Which of those would be fastest? Or don't you have enough information to tell? Hard for me to predict. If it were important to me, I'd test and time all of them on a realistic dataset. -- Igor Tandetnik

Re: [sqlite] How to build a new sqlite3.dylib?

On 04 Aug 2012 at 11:54, Tobias Giesen wrote: > I was able to compile the sqlite3 shell, but how to create the latest > dylib, or where can I download it? I use xcode for this purpose, using the amalgamation. -- Cheers -- Tim

Re: [sqlite] sqlite3 database unreadable on Mountain Lion

On Aug 6, 2012, at 8:26 AM, Simon Slavin wrote: > So either Apple has made a change between versions, or we have different > paths. I use fully qualified pathnames here: ~ e$ /usr/bin/sqlite3 :memory: 'SELECT sqlite_source_id()' 2012-04-03 19:43:07

Re: [sqlite] sqlite3 database unreadable on Mountain Lion

Fully qualified path names may still both load the same shared library. I assume you have "ldd" available? Run that on the binaries and see which library they'll load. Probably the same one unless they are statically linked. Michael D. Black Senior Scientist Advanced Analytics Directorate

Re: [sqlite] sqlite3 database unreadable on Mountain Lion

On 6 Aug 2012, at 7:48pm, Doug Currie wrote: > ~ e$ /usr/local/bin/sqlite3 :memory: 'SELECT sqlite_source_id()' > 2012-05-14 01:41:23 8654aa9540fe9fd210899d83d17f3f407096c004 I think this copy has been installed by something else. I don't think it comes with Apple's

Re: [sqlite] sqlite3 database unreadable on Mountain Lion

On Aug 6, 2012, at 4:51 PM, Simon Slavin wrote: > On 6 Aug 2012, at 7:48pm, Doug Currie wrote: > >> ~ e$ /usr/local/bin/sqlite3 :memory: 'SELECT sqlite_source_id()' >> 2012-05-14 01:41:23 8654aa9540fe9fd210899d83d17f3f407096c004 > > I think this

Re: [sqlite] How to build a new sqlite3.dylib?

Hello, would you be willing to share your dylib with me? I don't know how to do this with Xcode. Cheers Tobias > On 04 Aug 2012 at 11:54, Tobias Giesen wrote: > > > I was able to compile the sqlite3 shell, but how to create the latest > > dylib, or where can I

Re: [sqlite] How to build a new sqlite3.dylib?

On 6 Aug 2012, at 10:29pm, Tobias Giesen wrote: > would you be willing to share your dylib with me? I don't know how to > do this with Xcode. Do you absolutely need to use a dynamic library ? The recommendation from the SQLite team is that people build sqlite3 into

Re: [sqlite] How to build a new sqlite3.dylib?

On 06 Aug 2012 at 22:49, Simon Slavin wrote: > On 6 Aug 2012, at 10:29pm, Tobias Giesen wrote: > >> would you be willing to share your dylib with me? I don't know how to >> do this with Xcode. > > Do you absolutely need to use a dynamic library ?

Re: [sqlite] How to build a new sqlite3.dylib?

> Do you absolutely need to use a dynamic library ? I have spent a full day trying to compile & link the c and h file with my Pascal code and I have given up. The DB library I have expects a dylib so I will have to feed it what it can eat. Trouble is, I don't know how to build the dylib either

Re: [sqlite] Fw: Fw: Fw: A question on sqlite processing

On Mon, Aug 6, 2012 at 7:42 PM, u okafor wrote: > Dear sirs, > My group is working with SQLITE Version 3.7 . .and the project has to do > with transformation of applications > to run on a Bare PC. On a CREATE TABLE, our traversal, in terms of > opcodes, inside

Re: [sqlite] How to build a new sqlite3.dylib?

On 6 Aug 2012, at 11:48pm, Tobias Giesen wrote: >> Do you absolutely need to use a dynamic library ? > > I have spent a full day trying to compile & link the c and h file with > my Pascal code and I have given up. The DB library I have expects a > dylib so I will have