liubin liu wrote:
> I want to create two tables like:
> create table t1 (id INT PRIMARY KEY, cont TEXT);
> create table t2 ({select count(*) from t1} INT);
>
> How could I do it?You create table t2 with plain vanilla integer field, then create insert and delete triggers on t1 that update t2. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
