This is so good to hear! The advances in database theory and practice
have put the old ideas to rest.
Hooray for today!
Ted
On 09/01/2012 07:08 PM, Richard Hipp wrote:
> On Sat, Sep 1, 2012 at 6:34 PM, Ted Rolle, Jr. wrote:
>
>> Back in the olden days we predicted a database
Most companies
got through it with few problems --- a tribute to the programming staff.
Ted
On 09/01/2012 07:51 PM, Simon Slavin wrote:
> On 1 Sep 2012, at 11:34pm, "Ted Rolle, Jr." wrote:
>
>> Back in the olden days we predicted a database's storage to be about 5
>
Text editor to remove the offending line(s)?
This way you can see what you've removed.
The other solutions (tail, less, more) would work better for LARGE files.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/l
Back in the olden days we predicted a database's storage to be about 5
times the size of the data.
By 'olden' I mean IBM's IMS, VSAM, DB2. ..., 70s, 80s.
I hope this is still not the case...
Ted
___
sqlite-users mailing list
sqlite-users@sqlite.org
http:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
And in addition, the TZ offset might be handy to convert to UTC. Local
time is locally determined while UTC is constant, and other local
offsets can be applied to display time in local terms.
For example, EST is UTC-5; EDT is UTC-4; PST is UTC-8; PDT
So simple. I never thought of using the command-line sqlite3...
> in the sqlite3 shell, set output mode to file, and then select as
> above. All your select output will go to your file.
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a table of UPCs with lengths varying from 6 to 12. I'd like to
print those with length=10 to a file for printing.
SELECT *
FROM UPCs
WHERE LENGTH(UPC)=10;
works just fine. But when I export the table I naturally get the whole
table. Would
I just found an elegant query to identify duplicate entries in a
table. It is from Microsoft.
http://support.microsoft.com/kb/139444
Here's the information:
create table t1(col1 int, col2 int, col3 char(50))
insert into t1 values (1, 1, 'data value one')
insert into t1 values (1, 1, 'data value
On Tue, 6 Jul 2010 17:13:44 -0500
P Kishor wrote:
> I have no idea why you would say that. It works just fine.
>
> sqlite> CREATE TABLE UPCs (UPC TEXT);
> sqlite> INSERT INTO UPCs VALUES ('043000205563');
> sqlite> SELECT * FROM UPCs;
> UPC
>
> 043000205563
> sqlite>
Oh, by the way,
On Tue, 6 Jul 2010 17:13:44 -0500
P Kishor wrote:
> sqlite> CREATE TABLE UPCs (UPC TEXT);
> sqlite> INSERT INTO UPCs VALUES ('043000205563');
> sqlite> SELECT * FROM UPCs;
> UPC
>
> 043000205563
> sqlite>
I did as you said with sqlite and it worked perfectly. Thank you.
This is pr
I, (or more to the point, SQLite) can't seem to retain leading zeros
on numbers.
The receiving field is defined as CHAR;
I'm using the SQLite Manager in Firefox.
I've also tried sqlite3 from the command line.
Here's a typical (and minimal) statement:
UPDATE UPCs SET UPC=043000205563;
UPDATE UPCs S
On Fri, 25 Jun 2010 01:46:08 +0100
Simon Slavin wrote:
>
> On 24 Jun 2010, at 10:38pm, Ted Rolle, Jr. wrote:
>
> > I can't see anything good coming out of this if there are lawyers
> > involved.
>
> Big North American companies like Oracle don't do /anyt
I can't see anything good coming out of this if there are lawyers
involved.
--
__
3.14159265358979323846264338327950 Let the spirit of pi
2884197169399375105820974944592307 spread all over the world!
81640628620899862803482534
Does the TEA tarball have the tests?
--
__
3.14159265358979323846264338327950 Let the spirit of pi
2884197169399375105820974944592307 spread all over the world!
8164062862089986280348253421170679 http://pi314.at PI VOBISCUM!
On Fri, 28 May 2010 20:12:54 +0300
Andrejs Igumenovs wrote:
Finally! A question that I can answer.
For all practical (and most impractical)
(Drum roll)
UTC = GMT, or alternatively,
GMT = UTC
UTC is Coordinated Universal Time, which one would think would be
abbreviated CUT, but one French-speakin
Thanks to all who replied!
Single quotes? How simple...I used double quotes...
Ted
--
__
3.14159265358979323846264338327950 Let the spirit of pi
2884197169399375105820974944592307 spread all over the world!
8164062862089986
I'm entering UPCs.
0071318119 becomes 71318119. This is not good, or expected, for that
matter
.
The column is specified as TEXT.
I thought that TEXT values went in 'as entered'. After reading the
docs, Section 2.0:
"If numerical data is inserted into a column with TEXT affinity it is
converted
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 09 Dec 2009 11:48:31 -0800
Roger Binns wrote:
> http://catb.org/~esr/faqs/smart-questions.html
What wasn't clear? I apologize for any murkiness.
My understanding is that a BLOB takes any piece of data and stores it
away intact.
Is it the co
When I insert a gpg-encrypted .asc file command-line sqlite3 inserts
each line as a separate BLOB.
This is not what I want.
I want the whole file to be in the BLOB.
I tried inserting a .gpg file but x'0a' signals a new line with
resulting 'Expected 1 column but found 2'.
Where to from here?
---
___
When I .import a file into a table, || results in a value of '' for the
data item.
How can I get a NULL value stored?
This also happens when the item is at the end (EOL) of the row.
Currently, I:
UPDATE table SET value=NULL where value='';
Ted
---
_
On Sun, 6 Dec 2009 17:57:06 -0800
Stephan Wehner wrote:
Base64? Then just add it with an .import statement?
I thought about that with MIME encoding.
Ted
---
3.14159265358979323846264338327950 Let the spirit of pi spread
28841971
>From what I read, it is necessary to have a programmatic interface to
put images into a database. True?
---
3.14159265358979323846264338327950 Let the spirit of pi spread
2884197169399375105820974944592307 all around the world!
8
I need for computed total price to display with leading and trailing
zeros.
E.g.
1 -> 1.00
2.5 -> 2.50
.9 -> 0.90
The extended price is computed with this statement:
round(purchase.qty*inventory.price/100.0,2)
Ted
3.1415926535897
I'm laboring under a false impression. I thought that the SQLite data
types were limited to text, integer, float, and something else.
On the SQLite site there's Currency, date-time with and without
timestamps.
Where can I find a listing of these?
Ted
___
24 matches
Mail list logo