Re: [sqlite] SQLITe space issue

On 12 Aug 2013, at 3:54am, Inna Belakhova wrote: > Is there a limit on a datastore? > > Is there a limit on a table? Please read the page I cited in my previous message. Simon. ___ sqlite-users mailing list

Re: [sqlite] delete the extra row from 2 similar tables

On 8/11/2013 10:48 PM, ChingChang Hsiao wrote: I have 2 similar tables. If_idx is the key. I am trying to synchronize the rows. Is there one sql statement to delete the extra row or 2 statements to get the result for the extra if_idx, 29 and then delete it from the table

Re: [sqlite] SQLITe space issue

Is there a limit on a datastore? Is there a limit on a table? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Friday, 9 August 2013 9:17 AM To: General Discussion of SQLite Database Subject: Re: [sqlite]

[sqlite] delete the extra row from 2 similar tables

I have 2 similar tables. If_idx is the key. I am trying to synchronize the rows. Is there one sql statement to delete the extra row or 2 statements to get the result for the extra if_idx, 29 and then delete it from the table lldp_stats_tx_port_table_clear. PRAGMA foreign_keys=OFF; BEGIN