2012/8/6 YAN HONG YE <[email protected]>: > I wanna insert into a value to my sqlte db: > > insert into mydb (number1) select count(number1) from db2 where number1>80; > > but it doesn't work
sqlite> CREATE TABLE db2(number1 int, name text); sqlite> INSERT INTO db2 VALUES (20,'Name 2'); sqlite> INSERT INTO db2 VALUES (90,'Name 9'); sqlite> INSERT INTO db2 VALUES (140,'Name 14'); sqlite> CREATE TABLE mydb(number1 int); sqlite> INSERT INTO mydb (number1) SELECT count(number1) FROM db2 WHERE number1>80; sqlite> SELECT * FROM mydb; 2 -- Kit _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
