SQLite中重复值的插入

sqlite> create table t(id integer primary key autoincrement, col2 varchar(32));
sqlite> insert into t values((select (max(rowid) % 8192 + 1) from t), 'fdasfaf');
sqlite> select * from t;
1|fdasfaf
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> select * from t;
1|fdasfaf
2|k9
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> select * from t;
1|fdasfaf
2|k9
3|k9
4|k9
5|k9
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> select * from t;
1|fdasfaf
2|k9
3|k9
4|k9
5|k9
6|k9
7|k9
8|k9
9|k9
10|k9
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> replace into t values((select (max(rowid) % 10 + 1) from t), 'k9');
sqlite> select * from t;
1|k9
2|k9
3|k9
4|k9
5|k9
6|k9
7|k9
8|k9
9|k9
10|k9
sqlite>

评论

2 楼 iihero 2011-09-14  

qq258112065 写道

数据库开发和java开发谁更有发展前途啊？

不知道你说的数据库开发，是指应用开发，还是底层开发？
如果是底层开发(开发dbms)，当然很有前途.

1 楼 qq258112065 2011-09-14  

数据库开发和java开发谁更有发展前途啊？