Re: [sqlite] SQLite DELUXE Re: sqlite command line tool NUL support

https://www.sqlite.org/privatebranch.html This command both creates the new repository and populates it with all the latest SQLite could -> This command both creates the new repository and populates it with all the latest SQLite code On Wed, Jan 24, 2018 at 10:44 PM Richard Hipp

Re: [sqlite] SQLite DELUXE Re: sqlite command line tool NUL support

On 1/24/18, petern wrote: > Have you worked out an automated way for your changes to shadow and > auto-merge from the official trunk? https://www.sqlite.org/privatebranch.html -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] SQLite DELUXE Re: sqlite command line tool NUL support

On Wed, Jan 24, 2018 at 1:30 PM, petern wrote: > Have you worked out an automated way for your changes to shadow and > auto-merge from the official trunk? That is, aside from collision edits, > is it automated? Longer term, your shadow distribution also needs >

[sqlite] SQLite DELUXE Re: sqlite command line tool NUL support

Have you worked out an automated way for your changes to shadow and auto-merge from the official trunk? That is, aside from collision edits, is it automated? Longer term, your shadow distribution also needs new/merged test cases and a regression test run to re-qualify the merged changes at each

Re: [sqlite] command shell .timeout

Thank you, Richard. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Thursday, August 03, 2017 3:38 PM To: SQLite mailing list Subject: Re: [sqlite] command shell .timeout On 8/3

Re: [sqlite] command shell .timeout

On 8/3/17, Roman Fleysher wrote: > Dear SQLiters, > > I am using sqlit3 command shell. It has ".timeout" command. What is the > difference between: > > .timeout MS > PRAGMA busy_timeout = milliseconds; They accomplish the same thing. The ".timeout" command (which

Re: [sqlite] Command line not accepting multi-line statements.

Thanks, that worked. John Gillespie On 8 November 2016 at 14:30, Richard Hipp wrote: > On 11/8/16, John G wrote: > > I normally use the 3.8.8.3 supplied with MacOS El Capitan. > > I downloaded version 3.15.1 from the Download page - precompiled > >

Re: [sqlite] Command line not accepting multi-line statements.

On Tue, Nov 8, 2016 at 3:30 PM, Richard Hipp wrote: > On 11/8/16, John G wrote: > > I normally use the 3.8.8.3 supplied with MacOS El Capitan. > > I downloaded version 3.15.1 from the Download page - precompiled > > command-line tools :

Re: [sqlite] Command line not accepting multi-line statements.

On 11/8/16, John G wrote: > I normally use the 3.8.8.3 supplied with MacOS El Capitan. > I downloaded version 3.15.1 from the Download page - precompiled > command-line tools : (sqlite-tools-osx-x86-3150100.zip). > > When I tried copying and pasting multiple or multi-line

Re: [sqlite] Command line shell not flushing stderr when interactive

Microsoft seems to only make the stderr stream unbuffered when writing to a character device: "The stdout and stderr functions are flushed whenever they are full or, if you are writing to a character device, after each library call."  It doesn't seem to consider pipe that emacs is reading from

Re: [sqlite] Command line shell not flushing stderr when interactive

On 19 Jan 2014, at 7:32pm, Luuk wrote: > It is acceptable—and normal—for standard output and standard error to be > directed to the same destination, such as the text terminal. Messages appear > in the same order as the program writes them, unless buffering is involved. >

Re: [sqlite] Command line shell not flushing stderr when interactive

On 19-01-2014 19:59, Christopher Wellons wrote: When the shell is set to interactive (i.e. "-interactive"), the output (stdout) is flushed with every prompt (shell.c:422) but stderr is not. Stderr is suppose to be unbuffered so that flushing is not required. Or is that different for

Re: [sqlite] Command line shell not flushing stderr when interactive

>> When the shell is set to interactive (i.e. "-interactive"), the output >> (stdout) is flushed with every prompt (shell.c:422) but stderr is not. > Stderr is suppose to be unbuffered so that flushing is not required. Or is > that different for windows? According to the stderr Linux man page

Re: [sqlite] Command line shell not flushing stderr when interactive

On Sun, Jan 19, 2014 at 11:10 AM, Christopher Wellons < well...@nullprogram.com> wrote: > > When the shell is set to interactive (i.e. "-interactive"), the output > (stdout) is flushed with every prompt (shell.c:422) but stderr is not. > Stderr is suppose to be unbuffered so that flushing is not

Re: [sqlite] Command-line utility

http://www.sqlite.org/download.html scroll to "Precompiled Binaries for Windows" It runs just fine on 32 bit windows. Adam Hi, thanks, and yes I have these, but am specifically interested in the latest development trunk, which I don't think is included on this page in compiled form (unless

Re: [sqlite] Command-line utility

http://www.sqlite.org/download.html scroll to "Precompiled Binaries for Windows" It runs just fine on 32 bit windows. Adam On Thu, Jul 11, 2013 at 12:20 PM, RSmith wrote: > Could someone send me a build with the current trunk of the command-line > utility for Windows 32Bit

Re: [sqlite] Command history not working in sqlite3 tool for MAC OS

Yes, I installed the latest version myself. > Date: Fri, 11 May 2012 07:46:16 +0100 > From: amit.k.chaudh...@gmail.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Command history not working in sqlite3 tool for MAC OS > > My Mac is running system provided sqlite3 (3.

Re: [sqlite] command line to get number of tables in sqlite

On 22/12/2011 7:25 AM, Matt Young wrote: select count() from sqlite_master; No?? ...where type='table'; Cheers, Mohit. 22/12/2011 | 12:51 PM. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] command line to get number of tables in sqlite

select count() from sqlite_master; No?? On Wed, Dec 21, 2011 at 10:32 AM, smallboat wrote: > Hello, > > I have a sqlite file. I would like to open it and know how many tables in > it. > > What is the command line to open a sqlite file and get to know how many > tables in

Re: [sqlite] command line to get number of tables in sqlite

Somthing like sqlite3 sqlite.file sqlite> select count(*) from sqlite_master where type = 'table'; /Roger On 12/21/11 19:32, smallboat wrote: Hello, I have a sqlite file. I would like to open it and know how many tables in it. What is the command line to open a sqlite file and get to know

Re: [sqlite] command line to get number of tables in sqlite

On 21 Dec 2011 at 18:32, smallboat wrote: > I have a sqlite file. I would like to open it and know how many tables in it. > > What is the command line to open a sqlite file and get to know how many tables > in it? Thanks. See: http://www.sqlite.org/sqlite.html and:

Re: [sqlite] Command line option equivalent for .read

Walker Data Management & Warehousing 0118 321 5930 dav...@datamgmt.com http://www.datamgmt.com > Date: Thu, 8 Dec 2011 17:26:55 + > From: Simon Davies <simon.james.dav...@gmail.com> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Subject: Re:

Re: [sqlite] Command line option equivalent for .read

On 8 December 2011 17:05, David Walker wrote: > Hi, > > Having played around with a shell script that calls SQLite I have noticed > that I can something like > >        .separator STRING      at the SQLite prompt >        .mode line > > or I can do > >        sqlite3

Re: [sqlite] Command line client and Tcl interface behaves differently?

Hi, Sorry, never mind this post. I haven't found the problem actually yet, but a "bare minimum" example fed directly to the interpreter through the command line works correctly: % package require sqlite3 3.7.2 % set inf [open 1_schema.sql r] file6 % set sql [read $inf] [... the contents of the

Re: [sqlite] Command line client and Tcl interface behaves differently?

On Sat, Nov 20, 2010 at 2:43 PM, Richard Hipp wrote: > On Sat, Nov 20, 2010 at 8:25 AM, Fredrik Karlsson wrote: > >> Dear list, >> >> I am having a silly problem, and need your expertise. I just want to >> initiate a SQLite database using a schema file in Tcl,

Re: [sqlite] Command line client and Tcl interface behaves differently?

On Sat, Nov 20, 2010 at 8:25 AM, Fredrik Karlsson wrote: > Dear list, > > I am having a silly problem, and need your expertise. I just want to > initiate a SQLite database using a schema file in Tcl, but I just get > an empty database whatever I do. I asked this question on

Re: [sqlite] Command line tool always return the first column in a select

I upgraded to 3.7.0 and it fixes the problem. Thanks! Ben On Wed, Aug 4, 2010 at 8:07 AM, Black, Michael (IS) wrote: > I just ran your code on 3.6.23.1 and it works just fine. > > Can you try a newer version? > > x.sql: > create table mytable (id VARCHAR(255), name

Re: [sqlite] Command line tool always return the first column in a select

I just ran your code on 3.6.23.1 and it works just fine. Can you try a newer version? x.sql: create table mytable (id VARCHAR(255), name VARCHAR(255), address VARCHAR(255), PRIMARY KEY(id)); insert into mytable (id, name, address) VALUES ('123abc','charlie', '123 st'); insert into mytable

Re: [sqlite] command line does not accept arrow keys

hi Jay Jay A. Kreibich wrote: > Yes. Readline support is not on by default. > > You need to compile it with -DHAVE_READLINE and add -lreadline > to the linker: > > $ cc -DHAVE_READLINE -o sqlite3 sqlite3.c shell.c -lreadline recompiling sqlite3 from source code with your command solved

Re: [sqlite] command line does not accept arrow keys

On Fri, Nov 20, 2009 at 10:29:20PM -0500, Qianqian Fang scratched on the wall: > Is this possibly caused by how sqlite binary was compiled? Yes. Readline support is not on by default. You need to compile it with -DHAVE_READLINE and add -lreadline to the linker: $ cc -DHAVE_READLINE -o

Re: [sqlite] command line does not accept arrow keys

I don't know, is there a way I can tell? the binary was downloaded from sqlite website, version is 3.6.2. The binary stores in a remote server, running Debian 3, I used ssh in a Terminator/gnome-terminal bash shell. I also installed sqlite on my local machine, running Ubuntu Karmic,

Re: [sqlite] command line does not accept arrow keys

On Fri, Nov 20, 2009 at 6:02 PM, Qianqian Fang wrote: > hi > > I can not type arrow keys in the sqlite3 command line, all the arrow > keys (as well as other keys in the small keyboard) will be shown as > escape sequence "^]]A". Could it be a problem with readline? See

Re: [sqlite] Command to create a database in sqlite

sqlite3_open. Mozaharul Haque wrote: > Hi, > > A silly asking. I found the command to create a table but what about to > create a database? > > The table would be stored in the sqlite_master table. > > And how do I refer (full path) to the database using application like > Basic4ppc 6.05. >

Re: [sqlite] Command to create a database in sqlite

"Mozaharul Haque" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > A silly asking. I found the command to create a table but what about > to create a database? Just give a file name to sqlite3_open, then create a table. If the file didn't exist, it will be created at this point.

Re: [sqlite] command

using UODATE command its working. thanks for the help regards Nishit On 8/30/07, Jim Dodgen <[EMAIL PROTECTED]> wrote: > > Also I recommend you get a very basic SQL database book. > > > Quoting John Stanton <[EMAIL PROTECTED]>: > > > nishit sharma wrote: > > > i have given some text in a

Re: [sqlite] command

Also I recommend you get a very basic SQL database book. Quoting John Stanton <[EMAIL PROTECTED]>: > nishit sharma wrote: > > i have given some text in a database file as > > America|england| and many more. > > now i want to replace some text with new text how > > this is possible. Also my

Re: [sqlite] command

nishit sharma wrote: i have given some text in a database file as America|england| and many more. now i want to replace some text with new text how this is possible. Also my database has around 15 rows now which will be incremented. so, plz anyone tell me how to replace a text in a row and

RE: [sqlite] command

Update can be used to replace a text with some new text. To delete a particular row use 'where' command along with 'delete'. -Original Message- From: nishit sharma [mailto:[EMAIL PROTECTED] Sent: Thursday, August 30, 2007 4:04 PM To: sqlite-users@sqlite.org Subject: [sqlite] command i

Re: [sqlite] command-line shell handling of errors.

"Yes and yes." :) Alejo On 10/26/06, Kees Nuyt <[EMAIL PROTECTED]> wrote: Hi Richard, On Thu, 26 Oct 2006 17:23:17 +, you wrote: > So the question: > Who will be adversely effected by the new error behavior > in the sqlite command-line shell? Not really. I prefer the new behaviour. At

Re: [sqlite] command-line shell handling of errors.

Hi Richard, On Thu, 26 Oct 2006 17:23:17 +, you wrote: > So the question: > Who will be adversely effected by the new error behavior > in the sqlite command-line shell? Not really. I prefer the new behaviour. At the moment I have to jump through hoops and scan my make logs to detect errors

Re: [sqlite] command-line shell handling of errors.

[EMAIL PROTECTED] writes: > So the question: Who will be adversely effected by the new > error behavior in the sqlite command-line shell? Who is > using the sqlite command-line shell in scripts in such a > way that the script will no longer work with the new > behaviors? Do I need to change

Re: [sqlite] command-line shell handling of errors.

I don't use the command-line shell, but I'd definitely prefer not to see a fundamental change in the behavior of any tool I use. The debugging could get nasty and it's possible that someone using the tool in an unsupervised script might not notice the problem until after it had done some

Re: [sqlite] Command line interface SQLITE 2.8.16

On 9/14/05, Sijm, Norbert <[EMAIL PROTECTED]> wrote: > > > > Hi, I'm trying to execute a command in a DOS batchfile , but I get a syntax > error. Is this supported in 2.8.16 ? > ( sqlite mydbase.db select * from table1; ) Try enclosing your SQL statements in double quotes, like this: sqlite

Re: [sqlite] command history

Puneet, Puneet Kishor <[EMAIL PROTECTED]> 03/05/2004 05:01 AM To: SQLite <[EMAIL PROTECTED]> cc: Subject:[sqlite] command history > Is there a way to enable some kind of command history in the SQLite > shell? You know, press the up arrow to get the

Re: [sqlite] command history

On May 3, 2004, at 3:48 AM, eno wrote: Puneet Kishor wrote: Actually I am on Mac OS X 10.3. I have no idea what I need to do to enable READLINE. I just downloaded the source and did the ./configure, make, make install dance and got no READLINE. It must be somewhere on my system because the

Re: [sqlite] Command-line SQLite

At 15:20 28/11/2003, [EMAIL PROTECTED] wrote: I'm attempting to use the command-line SQLite to test the speed of certain "selects" and how writing them in different fashions affects speed OK, can anyone explain (no pun intended!) what I should be looking for in what information "explain"