Thank you!
John
On 11/22/2016 01:21 PM, R Smith wrote:
On 2016/11/22 6:00 PM, John R. Sowden wrote:
That was a throw back to years ago. I was trying to protect against
y2k by making each dbf for 1 calendar year. Also, these files are
about 800k in size, so I was worried about storage
On 2016/11/22 6:00 PM, John R. Sowden wrote:
That was a throw back to years ago. I was trying to protect against
y2k by making each dbf for 1 calendar year. Also, these files are
about 800k in size, so I was worried about storage and search time.
Storage is not an issue anymore. I will
On 22 Nov 2016, at 5:03pm, John R. Sowden wrote:
> Thank you, but I am currently in the early learning phase of sql databases
> and the sql language. I am starting with Sqlite due to its relative
> simplicity, and moving on to H2 to integrate it into Libre Office.
Thank you, but I am currently in the early learning phase of sql
databases and the sql language. I am starting with Sqlite due to its
relative simplicity, and moving on to H2 to integrate it into Libre
Office. It's commands like analyze that I have never heard of and need
to become familiar
John,
On Tue, Nov 22, 2016 at 11:00 AM, John R. Sowden
wrote:
> That was a throw back to years ago. I was trying to protect against y2k by
> making each dbf for 1 calendar year. Also, these files are about 800k in
> size, so I was worried about storage and search
That was a throw back to years ago. I was trying to protect against y2k
by making each dbf for 1 calendar year. Also, these files are about
800k in size, so I was worried about storage and search time. Storage is
not an issue anymore. I will know about search time after learning
about sql
Just a thought about your TABLE named "log16":
I'm not at all a database expert but from the idea what a table is, I
would take a more general approach. CREATE a TABLE log with
columns year, logtext, timestamp a la:
CREATE TABLE LOG (logtext TEXT, timestamp TEXT, year INTEGER PRIMARY KEY)
On 21 Nov 2016, at 21:55, Igor Korot wrote:
> You are of course correct. It does depend on an application.
> However, I tried to explain the SQLite and its paradigm in terms of
> the dBase/FoxPro.
You were correct also, Igor, and gave good advice.
Best regards,
Niall
Hi, Niall,
On Mon, Nov 21, 2016 at 12:52 PM, Niall O'Reilly wrote:
> On 21 Nov 2016, at 17:29, John R. Sowden wrote:
>
>> First of all, I come from the dBASE/Foxpro world. There is no distinction
>> between a table and a database. I understand that with Sqlite a database
> On Nov 21, 2016, at 10:08 AM, John R. Sowden
> wrote:
>
> Thank you all for your answers and direction for further information.
> Hopefully, I will not bring these subjects up again. :)
Some of what you’re asking applies to any SQL database. The SQLite docs do
Thank you all for your answers and direction for further information.
Hopefully, I will not bring these subjects up again. :)
John
On 11/21/2016 09:29 AM, John R. Sowden wrote:
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I
On 21 Nov 2016, at 17:29, John R. Sowden wrote:
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I understand that with
Sqlite a database includes tables and other items. The scenario that
I do not understand, is: say I have a log
Hi, John,
On Mon, Nov 21, 2016 at 12:29 PM, John R. Sowden
wrote:
> First of all, I come from the dBASE/Foxpro world. There is no distinction
> between a table and a database. I understand that with Sqlite a database
> includes tables and other items. The scenario
John,
There is a lot of documentation on the SQLite website.
Here's the 'official' docs on creating a table
https://www.sqlite.org/lang_createtable.html
A Sqlite database consists of many tables. I am unsure if there is an
upper limit, if there is, its more tables than I have ever created.
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I understand that with
Sqlite a database includes tables and other items. The scenario that I
do not understand, is: say I have a log file with about 7 fields
totaling about 80
On Sat, 12 Mar 2016 13:07:01 -0500
Igor Korot wrote:
> My question is: what should I do if I want to create a system table?
Change the source code?
A system table differs from a user table in how it's created. User
tables are defined with CREATE TABLE of course, but system tables are
On 12 Mar 2016, at 9:59pm, Clemens Ladisch wrote:
> This is documented in the documentation:
> http://www.sqlite.org/fileformat2.html#intschema
To that documentation should be added sqlite_users.
Simon.
Igor Korot wrote:
> OK, so how many system tables SQLite has?
This is documented in the documentation:
http://www.sqlite.org/fileformat2.html#intschema
Regards,
Clemens
Igor Korot wrote:
> There is a notion of system table vs. user table in the DBMS.
System tables are tables with a name beginning with "sqlite_".
> My question is: what should I do if I want to create a system table?
This is possible only by (ab)using the writable_schema pragma:
CREATE TABLE
On 12 Mar 2016, at 6:07pm, Igor Korot wrote:
> There is a notion of system table vs. user table in the DBMS.
>
> The SQLite has at least 1 system table that is well-known: sqlite_master.
There are other tables too: the ones made by ANALYZE which have names which
start with 'sqlite_stat' .
dropped
sqlite>
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
> bounces at mailinglists.sqlite.org] On Behalf Of Clemens Ladisch
> Sent: Saturday, 12 March, 2016 11:42
> To: sqlite-users at mailinglists.sqli
Hi, Clemens,
On Sat, Mar 12, 2016 at 1:41 PM, Clemens Ladisch wrote:
> Igor Korot wrote:
>> There is a notion of system table vs. user table in the DBMS.
>
> System tables are tables with a name beginning with "sqlite_".
>
>> My question is: what should I do if I want to create a system table?
>
Hi, Simon,
On Sat, Mar 12, 2016 at 1:18 PM, Simon Slavin wrote:
>
> On 12 Mar 2016, at 6:07pm, Igor Korot wrote:
>
>> There is a notion of system table vs. user table in the DBMS.
>>
>> The SQLite has at least 1 system table that is well-known: sqlite_master.
>
> There are other tables too: the
Hi, ALL,
There is a notion of system table vs. user table in the DBMS.
The SQLite has at least 1 system table that is well-known: sqlite_master.
My question is: what should I do if I want to create a system table?
Thank you.
Hi Sam,
> I am trying to create a table with two indexes:
>
> CREATE TABLE favorites (
> cust_id CHAR(32) NOT NULL,
> fldoid CHAR(38) NOT NULL,
> imgoid CHAR(64) NOT NULL,
> PRIMARY KEY (cust_id),
> INDEX (fldoid, imgoid));
>
> SQLite keeps complaining saying there is an error around
"Sam Carleton" <[EMAIL PROTECTED]>
wrote in message
news:[EMAIL PROTECTED]
> I am trying to create a table with two indexes:
>
> CREATE TABLE favorites (
>cust_id CHAR(32) NOT NULL,
>fldoid CHAR(38) NOT NULL,
>imgoid CHAR(64) NOT NULL,
>PRIMARY KEY (cust_id),
>INDEX (fldoid,
I am trying to create a table with two indexes:
CREATE TABLE favorites (
cust_id CHAR(32) NOT NULL,
fldoid CHAR(38) NOT NULL,
imgoid CHAR(64) NOT NULL,
PRIMARY KEY (cust_id),
INDEX (fldoid, imgoid));
SQLite keeps complaining saying there is an error around INDEX. What
might
27 matches
Mail list logo