On Thursday, 15 August, 2019 08:02, Jose Isaias Cabrera
wrote:
>Thanks for this. What I am looking for is an unique ID that I can
>use to call that table. Does that exists in the internal of SQLite?
>I know I can create a table myself keep track of them myself, but I
>am trying to see if it e
On 15 Aug 2019, at 3:01pm, Jose Isaias Cabrera wrote:
> sqlite> SELECT * FROM sqlite_master WHERE type='table' AND name='PMOTitles';
> type|name|tbl_name|rootpage|sql
> table|PMOTitles|PMOTitles|11|CREATE TABLE PMOTitles
>(
> TitleKey PRIMARY KEY,
> Titles
>)
>
> What is the di
Richard Hipp, on Thursday, August 15, 2019 09:45 AM, wrote...
>
> On 8/15/19, Jose Isaias Cabrera, on
> > I have no idea
> > what that means, but the question I have is, will that number ever change?
> > Thanks.
>
> Yes. Root page numbers will change, for example when you run VACUUM.
Yep, you're
On 8/15/19, Jose Isaias Cabrera wrote:
> I have no idea
> what that means, but the question I have is, will that number ever change?
> Thanks.
Yes. Root page numbers will change, for example when you run VACUUM.
An SQLite database consists of a "forest" of b-trees. Each table and
each index is
Greetings.
When I run this command,
sqlite> SELECT * FROM sqlite_master WHERE type='table' AND name='PMOTitles';
type|name|tbl_name|rootpage|sql
table|PMOTitles|PMOTitles|560|CREATE TABLE PMOTitles
(
TitleKey PRIMARY KEY,
Titles
)
sqlite>
I see that there is a rootpage assig
5 matches
Mail list logo
