On Dec 30, 2003, at 3:12 PM, Kurt Welgehausen wrote:
... are UNIQUE columns basically the same as PRIMARY KEY ...?
No, they're not the same thing.
I understand that they are not the same thing in SQL. What I want to
know is whether or not applying UNIQUE and PRIMARY KEY amount to the
same
>> ... are UNIQUE columns basically the same as PRIMARY KEY ...?
No, they're not the same thing.
There are dozens of elementary articles on database
theory on the www. Try a Google search on 'database
primary key' or something like that.
Hi again,
> Actually, the -DNDEBUG=1 is not SQLite specific. This is how
> you disable assert()s. The SQLite library is full of assert()s
> for sanity checking. But it is smaller and runs twice as fast
> if you leave them out.
Oh yes, you are right.
(I forgot it because I don't use assert()
Danny Reinhold wrote:
TCC = gcc -g -O2 -DTHREADSAFE=1 -DNDEBUG=1
The important thing is not only the option -DNDEBUG=1 but
mainly -g ofcourse... -DNDEBUG=1 is a SQLite specific directive
while -g is a compiler option for the gcc...
Actually, the -DNDEBUG=1 is not SQLite specific.
Hi!
> Danny,
>
> thank you for your answer!! =)
No problem - but it wasn't correct... ;-)
(I should sleep a little ;-))
> > > TCC = gcc -g -O2 -DTHREADSAFE=1 -DNDEBUG=1
The important thing is not only the option -DNDEBUG=1 but
mainly -g ofcourse... -DNDEBUG=1 is a SQLite specific
Hi,
I try to find a ODBC driver to use on linux with OOo.
Can you help me ?
P.S. Sorry for my english.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi!
> I added these things myself to the Makefile...
>
> TCC = gcc -g -O2 -DTHREADSAFE=1 -DNDEBUG=1
> LIBREADLINE = ... -lpthread
>
> Then:
>
> $ make
> $ cd .libs
> $ strip libsqlite.so.0.8.6
>
> That's all. Now the libsqlite.so file is only 260K (less than half
>> Hi Kurt. I could use code to parse out the other stuff too.
>> If its written in C/C++, would you be willing to share it?
>>
>> cheers
>> -brett
It's a tcl function that returns a list containing a string,
5 lists of strings, and 3 lists of lists of strings. You'd
have to translate it. It's
Roger Reghin wrote:
> I managed to compile SQLite (2.8.8) under Linux with the ThreadSafe option
> set to 1.
>
> It works, but the file size is twice as big as the original .so from the
> SQLite site (without the ThreadSafe portion).
>
> What should I do, or, what I shouldn't do???
1. Run
I managed to compile SQLite (2.8.8) under Linux with the ThreadSafe option set to 1.
It works, but the file size is twice as big as the original .so from the SQLite site
(without the ThreadSafe portion).
What should I do, or, what I shouldn't do???
On Tue, 2003-12-30 at 06:46, Steve O'Hara wrote:
> My understanding is that logically, by their very nature, joins are always
> likely to be slower than single table queries - I thought that this was a
> given downside to normalisation or am I incorrect? Maybe the downside is
> not pronounced in
> -Original Message-
> From: Mrs. Brisby [mailto:[EMAIL PROTECTED]
> Sent: 29 December 2003 23:41
> To: Yogesh Vachhani
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Subject: Re: [sqlite] Let us make SQLite more
> powerful
>
>
> On Sat, 2003-12-27 at 07:16, Yogesh Vachhani wrote:
> > >
Hi Everyone,
I don't know this was problem or not.
I'm using version 2.8.8.
I have a table with 350 record,
With below Query I got 5 records, (which suppose to be result i want)
SELECT DISTINCT LangNo, MovieSTK FROM VoIS WHERE BranchSMS='GKL1' AND
DateID='2' AND LangNo BETWEEN 1 AND 5 ORDER
13 matches
Mail list logo