Re: [sqlite] one column is another table's row num

2010-03-17 Thread Igor Tandetnik 
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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] one column is another table's row num

2010-03-17 Thread liubin liu 

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?
-- 
View this message in context: 
http://old.nabble.com/one-column-is-another-table%27s-row-num-tp27940860p27940860.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users