Re: [sqlite] Why am I not getting anything?

Thank you. On Sun, Feb 10, 2019 at 1:35 AM Shawn Wagner wrote: > > SELECT * FROM pragma_foreign_key_list('temp1'); > > The table name needs to be a string for the pragma_foreign_key_list virtual > table. (It's not for the corresponding pragma statement.) > > On Sat, Feb 9, 2019, 11:31 PM Igor

Re: [sqlite] Why am I not getting anything?

SELECT * FROM pragma_foreign_key_list('temp1'); The table name needs to be a string for the pragma_foreign_key_list virtual table. (It's not for the corresponding pragma statement.) On Sat, Feb 9, 2019, 11:31 PM Igor Korot Hi, ALL, > > [code] > sqlite> SELECT * FROM sqlite_master WHERE name

[sqlite] Why am I not getting anything?

Hi, ALL, [code] sqlite> SELECT * FROM sqlite_master WHERE name LIKE '%temp%'; type|name|tbl_name|rootpage|sql table|temp|temp|40|CREATE TABLE temp(id INTEGER PRIMARY KEY, name VARCHAR(200)) table|temp1|temp1|41|CREATE TABLE temp1(myid INTEGER PRIMARY KEY, id INTEGER, my name VARCHAR(200),

Re: [sqlite] Was there an announcement of 3.27?

On February 8, 2019 3:31:51 PM EST, "Dominique Pellé" wrote: >David Raymond wrote: > >> SQLite version 3.27.1 is now available on the SQLite website: >> >> https://sqlite.org/ >> https://sqlite.org/download.html >> https://sqlite.org/releaselog/3_27_1.html > >Release notes

Re: [sqlite] Checking differences in tables

Warren Young, on Saturday, February 9, 2019 06:15 PM, wrote... >On Feb 9, 2019, at 12:20 PM, Jose Isaias Cabrera wrote: >> >> Warren Young, on Saturday, February 9, 2019 01:36 PM, wrote... >> > >> >You may be interested in the sqldiff program that comes with SQLite: >> >> Yeah, I know about it,

Re: [sqlite] Inconsistent behavior in sqlite3_set_authorizer() and error messages

I’ll interpret the silence as a “no”? > On Feb 7, 2019, at 11:53 AM, Joshua Thomas Wise > wrote: > > Is the SQLite team aware of these issues? > > >> On Feb 4, 2019, at 7:00 AM, sqlite-users-requ...@mailinglists.sqlite.org >> wrote: >>

Re: [sqlite] Checking differences in tables

On Feb 9, 2019, at 12:20 PM, Jose Isaias Cabrera wrote: > > Warren Young, on Saturday, February 9, 2019 01:36 PM, wrote... > > > >You may be interested in the sqldiff program that comes with SQLite: > > Yeah, I know about it, but I thought it was for two different DBs It is, but that doesn’t

Re: [sqlite] Checking differences in tables

Warren Young, on Saturday, February 9, 2019 01:36 PM, wrote... >On Feb 9, 2019, at 8:49 AM, Jose Isaias Cabrera wrote: >> >> Perhaps, Dr. Hipp and the team can write a quick PRAGMA that can do >> something like this, > >You may be interested in the sqldiff program that comes with SQLite: > >$

Re: [sqlite] Checking differences in tables

On Feb 9, 2019, at 8:49 AM, Jose Isaias Cabrera wrote: > > Perhaps, Dr. Hipp and the team can write a quick PRAGMA that can do something > like this, You may be interested in the sqldiff program that comes with SQLite: $ sqldiff --help Usage: sqldiff [options] DB1 DB2 Output SQL text that

Re: [sqlite] Checking differences in tables

WOW Clemens Ladisch on Saturday, February 9, 2019 11:44 AM wrote, Jose Isaias Cabrera wrote: >> t_20190208 (a PRIMARY KEY, b, c, d, e). >> >> I create a new table, >> >> t (a PRIMARY KEY, b, c, d, e) >> >> and insert a set of "new data", which contains changes that happened since >> yesterday >>

Re: [sqlite] Checking differences in tables

Jose Isaias Cabrera wrote: > t_20190208 (a PRIMARY KEY, b, c, d, e). > > I create a new table, > > t (a PRIMARY KEY, b, c, d, e) > > and insert a set of "new data", which contains changes that happened since > yesterday > after the new set of data was created. Right now, I bring the data out

Re: [sqlite] Checking differences in tables

Simon Slavin on Saturday, February 9, 2019 11:02 AM wrote... On 9 Feb 2019, at 3:49pm, Jose Isaias Cabrera wrote: > Imagine this scenario:I have this table, > > t (a PRIMARY KEY, b, c, d, e) > > that contains yesterday's data. Today, I rename that table to, > > t_20190208 (a PRIMARY KEY, b, c,

Re: [sqlite] Checking differences in tables

On 9 Feb 2019, at 3:49pm, Jose Isaias Cabrera wrote: > Imagine this scenario:I have this table, > > t (a PRIMARY KEY, b, c, d, e) > > that contains yesterday's data. Today, I rename that table to, > > t_20190208 (a PRIMARY KEY, b, c, d, e). That's not how you use tables. Your software

[sqlite] Checking differences in tables

Hi Gurus. Imagine this scenario:I have this table, t (a PRIMARY KEY, b, c, d, e) that contains yesterday's data. Today, I rename that table to, t_20190208 (a PRIMARY KEY, b, c, d, e). I create a new table, t (a PRIMARY KEY, b, c, d, e) and insert a set of "new data", which contains changes