Re: [sqlite] Format of the data

2008/7/22 Joanne Pham <[EMAIL PROTECTED]>: > Hi All, > I am current using sqlite 3.5.9 and below is command to get the data from my > database as: > .output '/opt/phoenix/monitor/exportData' > .mode csv > select '#Monitored applications' , group_concat(appName) from appMapTable; > The

[sqlite] query regarding encoding

Hi, I am sqllite user. I am using sqlite3-3.5.9. I am inserting some unicode data in utf-8 encoding format in database. When I tried the data back from the database it seems that data is being converted to some other encoding. Conversion may take place at insertion time. I am not sure. Is there

Re: [sqlite] query regarding encoding

"Jawahar Nayak" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I am sqllite user. I am using sqlite3-3.5.9. I am inserting some > unicode data in utf-8 encoding format in database. When I tried the > data back from the database it seems that data is being converted to > some other

Re: [sqlite] FTS index size

> It's hard to say - you might want to describe your tables and the join > by simply including the SQL itself, rather than a loose description of > it. It may be that there's a simple change which will clear things > up. Ok, what exactly I mean is a table containing tracks in an audio library, i.

[sqlite] sqlite3 basics

Hi, I'm new to sqlite. The command "sqlite3 test.db" and "sqlite3 ex1" as listed in the getting started guide on the website do not appear to work for me. What are the commands to simply create a database in sqlite and how to exit when in the ">" prompt? Thank you. respectfully, Milton __

Re: [sqlite] sqlite3 basics

sqlite3 test.db works, what error are you getting? and to exit (on a windows system Ctrl + C works On Tue, Jul 22, 2008 at 9:01 AM, Milton Centeno <[EMAIL PROTECTED]> wrote: > Hi, > > I'm new to sqlite. The command "sqlite3 test.db" and "sqlite3 ex1" as listed > in the getting started guide on the

Re: [sqlite] sqlite3 basics

2008/7/22 Milton Centeno <[EMAIL PROTECTED]>: > Hi, > > I'm new to sqlite. The command "sqlite3 test.db" and "sqlite3 ex1" as listed > in the getting started guide on the website do not appear to work for me. > What are the commands to simply create a database in sqlite and how to exit > when in th

Re: [sqlite] sqlite3 basics

Hi, Milton, Regarding: The command "sqlite3 test.db" and "sqlite3 ex1" You're referring the to command line test program, "sqlite3" or "sqlite3.exe". These commands will create databases named "test.db" and "ex1" respectively, if they did not exist before you ran the command. Of course, t

Re: [sqlite] sqlite3 basics

Milton Centeno wrote: > > I'm new to sqlite. The command "sqlite3 test.db" and "sqlite3 ex1" as listed > in the getting started guide on the website do not appear to work for me. > What are the commands to simply create a database in sqlite and how to exit > when in the ">" prompt? Thank you.

Re: [sqlite] sqlite3 basics

Thank you for your response. at the sqlite> prompt I enter sqlite3 test.db then I get ...> entering .databases gives me another ...> If I hit the Ctrl C it exits and closes the prompt window. On 7/22/08, Greg Morphis <[EMAIL PROTECTED]> wrote: > > sqlite3 test.db works, what error are you gett

Re: [sqlite] sqlite3 basics

On Tue, Jul 22, 2008 at 7:27 AM, Milton Centeno <[EMAIL PROTECTED]> wrote: > Thank you for your response. > > at the sqlite> prompt I enter sqlite3 test.db then I get ...> > entering .databases gives me another ...> > If I hit the Ctrl C it exits and closes the prompt window. The command 'sqlite3

Re: [sqlite] problem building reduced-size sqlite

Shane Harrelson wrote: > I checked in some updates to the "configure" support that will hopefully do > the right thing and pass any OMIT options to lemon and mkkeywordhash. Thanks, this allowed the code to compile to completion, leaving only 3 minor warnings: sqlite3.c: In function ‘rtreeCreate

Re: [sqlite] sqlite3 basics

yeah, if you just enter sqlite3 then it creates an in-memory database, to create a working and existing database, enter "sqlite3 test.db" at the C:\ prompt. Example "C:\> sqlite3 test.db" Ignore my comment on the Ctrl + C, if you're seeing the ---> then it's waiting for a semi-colon ";". Thanks >

Re: [sqlite] problem building reduced-size sqlite

On 7/22/08, Steve Friedman <[EMAIL PROTECTED]> wrote: > > > > Actually, I have both --enable-tempstore=always and -DTEMP_STORE=2 > (belts and suspenders). Then you probably want to use -DSQLITE_TEMP_STORE=2 instead. ___ sqlite-users mailing list sqlite-

Re: [sqlite] sqlite3 basics

On Tue, 22 Jul 2008, Keith Goodman wrote: > On Tue, Jul 22, 2008 at 7:27 AM, Milton Centeno <[EMAIL PROTECTED]> wrote: >> Thank you for your response. >> >> at the sqlite> prompt I enter sqlite3 test.db then I get ...> >> entering .databases gives me another ...> >> If I hit the Ctrl C it exits a

[sqlite] up to date info on SQLite query optimization?

Greetings, I am looking for tips, tricks and general information, both for personal usage (I'd like to move as many as possible of my SOHO-related databases to SQLITE) and for an online article, about SQLite3 query optimization tricks. I have already found and will study these pages: http://www.s

[sqlite] Extract month and year from a datetime field

Hi, How extract the month and/or year from a datetime field? For example: SELECT OrderID,OrderDate FROM tblOrders OrderDate is in datetime format and I would extract grouping for months regards Giuseppe ___ sqlite-users mailing list sqlite-users@sql

Re: [sqlite] FTS index size

Again, you've given a relatively broad description of what you're trying to do. I could make up a bunch of stuff and answer my own question, but you'd probably rather than I considered the problem _you_ are having. It sounds like you've actually committed code to do this - post the SQL CREATE sta

Re: [sqlite] Extract month and year from a datetime field

Giuseppe Costanzi <[EMAIL PROTECTED]> wrote: > How extract the month and/or year from a datetime field? > For example: > > SELECT OrderID,OrderDate > FROM tblOrders select OrderID, strftime('%m', OrderDate) as Month, strftime('%Y', OrderDate) as Year from tblOrders; http://sqlite.org/lang_datef

[sqlite] network type functions

Hello! Can I found functions for ip address/mask operations? Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Extract month and year from a datetime field

Igor Tandetnik wrote: > Giuseppe Costanzi <[EMAIL PROTECTED]> wrote: > >> How extract the month and/or year from a datetime field? >> For example: >> >> SELECT OrderID,OrderDate >> FROM tblOrders >> > > select OrderID, strftime('%m', OrderDate) as Month, strftime('%Y', > OrderDate) as Yea

Re: [sqlite] up to date info on SQLite query optimization?

M. Fioretti <[EMAIL PROTECTED]> wrote: > A few examples of the kind of queries I'd > like to (learn how to) optimize first: > > - search of strings in text fields (both sub-words and whole words) Are you familiar with SQLite full-text search (FTS) extension? http://www.sqlite.org/cvstrac/wiki?p=F

Re: [sqlite] up to date info on SQLite query optimization?

On Tue, Jul 22, 2008 14:24:38 PM -0400, Igor Tandetnik wrote: > Are you familiar with SQLite full-text search (FTS) extension? No, thanks for the link, will study it. > > - calculation of moving average of a floating field, eg if a table is ... > Any solution in pure SQL is going to be awkward.

Re: [sqlite] network type functions

Hello, Le 22 juil. 08 à 20:17, Alexey Pechnikov a écrit : > > Hello! > > Can I found functions for ip address/mask operations? > > Best regards, Alexey. I am a new user, and was looking for ip network/mask function too. I found none, so I just wrote an extension (tested on linux and MacOSX 10.5,

[sqlite] Cursors in SQlite

Good Evening list, Does SQLite support/implement cursors of any form, I've been searching through the documentation about this but I suspect either cursor is the wrong term for SQLite or they are either not supported or implemented. Could anyone clear this up for me? Cheers, Daniel Brown "The b

Re: [sqlite] Cursors in SQlite

Brown, Daniel <[EMAIL PROTECTED]> wrote: > Does SQLite support/implement cursors of any form sqlite3_step is, in some sense, a forward-only cursor. You might also find this interesting: http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor Igor Tandetnik __