exp.test004.ksh

b树实现源码,linux和unix下运行,速度快,极好用

[Parser: syntax error] +12
[Parser: syntax error] +
echo Same as csql2 but with primary key;
Statement Executed
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
echo select * from t1;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	20	
	11	21	
	12	22	
	13	23	
	14	24	
	50	50	
	
echo select * from t1 where f1 = 100;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	
echo select * from t1 where f1 = 10;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	20	
	
echo select f1 from t1 where f1 = 11;
---------------------------------------------------------
	f1	
---------------------------------------------------------
	11	
	
echo select f2 from t1 where f1 = 11;
---------------------------------------------------------
	f2	
---------------------------------------------------------
	21	
	
echo select f1, f2 from t1 where f1 = 12;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	12	22	
	
echo select * from t1 where f1 != 12 AND f2 <= 13;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	
echo select * from t1 where f1 = 12 AND f2 >= 22;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	12	22	
	
echo select * from t1 where f1 = 12 OR  f1 > 13;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	12	22	
	14	24	
	50	50	
	
echo select * from t1 where f1 = 12 OR f2 < 13;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	12	22	
	
echo select * from t1 where f1 = 12 OR f2 <> 22;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	20	
	11	21	
	12	22	
	13	23	
	14	24	
	50	50	
	
echo select * from t1 where NOT f1 = 12;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	20	
	11	21	
	13	23	
	14	24	
	50	50	
	
echo select * from t1 where f1 != 12;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	20	
	11	21	
	13	23	
	14	24	
	50	50	
	
echo select * from t1 where NOT f1 != 12;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	12	22	
	
echo select * from t1 where NOT (f1 = 12 AND f2 =22);
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	
echo select * from t1 where NOT (f1 = 12 OR f2 = 23);
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	
echo select * from t1 where f1 = 12 OR f2 = 23 OR f2 = 22;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	12	22	
	13	23	
	
echo select * from t1 where  f1+12 = 20;
Statement prepare failed with error -19
echo select * from t1 where f1 = 12 + f2;
Statement prepare failed with error -19
echo select * from t1 where f1 =  f2;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	50	50	
	
Statement Executed