|
外部表无法修改
sqlite> insert into t2 values('wang',1);
Error: table t2 may not be modified
但能复制给其他
sqlite> create table t3 as select * from t2;
sqlite> select * from t3;
name|age
tom|100
jack|100
sqlite> insert into t3 values('wang',1);
sqlite> select * from t3;
name|age
tom|100
jack|100
wang|1 |
|