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

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.

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

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