KTDsuHbd

1>>cd /var/www/dbs
2>>sqlite3 ha.db
3sqlite>>.timeout 2000
4sqlite>>INSERT INTO table1 SELECT * FROM table2;
5sqlite>>DELETE * FROM table2;
6sqlite>>.quit
7	
8>>sqlite3 ha.db
9sqlite>>INSERT INTO table1 ('a1','a2') VALUES ('1','2');
10sqlite>>.quit
11	
12cd /var/www/dbs
13echo ".timeout 2000
14INSERT INTO table1 SELECT * FROM table2;
15DELETE * FROM table2;
16.quit" |
17    sqlite3 ha.db
18	
19#!/bin/sh
20
21sqlite3 /var/www/dbs/ha.db <<END_SQL
22.timeout 2000
23INSERT INTO table1 SELECT * FROM table2;
24DELETE FROM table2;
25END_SQL
26	
27#!/bin/sh
28
29sqlite3 /var/www/dbs/ha.db <<END_SQL
30CREATE TABLE IF NOT EXISTS table2 AS SELECT * FROM table1;
31INSERT INTO table2 SELECT * FROM table1;
32DELETE FROM table1;
33END_SQL