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

2013-09-28 Thread Igor Tandetnik
On 9/28/2013 7:12 PM, ChingChang Hsiao wrote: I have 2 similar tables. If_idx and dest_addr_idx are the keys. 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, 69 and dest_addr_idx ,1 and then

[sqlite] delete the extra row from 2 similar tables with 2 key

2013-09-28 Thread ChingChang Hsiao
I have 2 similar tables. If_idx and dest_addr_idx are the keys. 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, 69 and dest_addr_idx ,1 and then delete it from the table

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

2013-08-11 Thread Igor Tandetnik
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

[sqlite] delete the extra row from 2 similar tables

2013-08-11 Thread ChingChang Hsiao
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