repo.or.cz
/
csql.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
history
|
raw
|
HEAD
*** empty log message ***
[csql.git]
/
test
/
tools
/
csql
/
comp4.sql
blob
447104ae061ac1d0a007964c65d67fc8c55b38f6
1
CREATE TABLE t1 (f1 INT NOT NULL,f2 char(10) NOT NULL,f3 INT);
2
CREATE INDEX idx on t1 (f1,f2) TREE UNIQUE;
3
INSERT INTO t1 VALUES(1,'1',1);
4
INSERT INTO t1 VALUES(3,'1',3);
5
echo select count(f1) from t1;
6
select count(f1) from t1;
7
echo test over