exp.test022.ksh

来自「b树实现源码,linux和unix下运行,速度快,极好用」· KSH 代码 · 共 212 行

KSH
212
字号
echo char datatype testing;Statement ExecutedStatement Executed: Rows Affected = 1Statement Executed: Rows Affected = 1Statement Executed: Rows Affected = 1Statement Executed: Rows Affected = 1Statement Executed: Rows Affected = 1Statement Executed: Rows Affected = 1Statement Executed: Rows Affected = 1Statement Executed: Rows Affected = 1Statement Executed: Rows Affected = 1Statement Executed: Rows Affected = 1Statement Executed: Rows Affected = 1echo select * from t1;---------------------------------------------------------	f1	f2	---------------------------------------------------------	10	A		11	B		12	C		13	D		14	14		50	E		This is really a ver	E		UPPERCASE	UPPER		uppercase	LOWER		upperletter	LOWER		uppercaseletter	LOWER		echo select * from t1 where f1 = '10';---------------------------------------------------------	f1	f2	---------------------------------------------------------	10	A		echo select * from t1 where f1 != '12' AND f2 <= '13';---------------------------------------------------------	f1	f2	---------------------------------------------------------	Illegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for Stringecho select * from t1 where f1 = '12' AND f2 >= '22';---------------------------------------------------------	f1	f2	---------------------------------------------------------	Illegal Operator:Not Supported for Stringecho select * from t1 where f1 = '12' OR  f1 > '13';---------------------------------------------------------	f1	f2	---------------------------------------------------------	12	C		14	14		50	E		This is really a ver	E		UPPERCASE	UPPER		uppercase	LOWER		upperletter	LOWER		uppercaseletter	LOWER		echo select * from t1 where f1 = '12' OR f2 = '13';---------------------------------------------------------	f1	f2	---------------------------------------------------------	12	C		echo select * from t1 where f1 = '12' OR f2 < '22';---------------------------------------------------------	f1	f2	---------------------------------------------------------	10	A		11	B		12	C		13	D		14	14		50	E		This is really a ver	E		UPPERCASE	UPPER		uppercase	LOWER		upperletter	LOWER		uppercaseletter	LOWER		echo select * from t1 where NOT f1 = '12';---------------------------------------------------------	f1	f2	---------------------------------------------------------	10	A		11	B		13	D		14	14		50	E		This is really a ver	E		UPPERCASE	UPPER		uppercase	LOWER		upperletter	LOWER		uppercaseletter	LOWER		echo select * from t1 where f1 != '12';---------------------------------------------------------	f1	f2	---------------------------------------------------------	10	A		11	B		13	D		14	14		50	E		This is really a ver	E		UPPERCASE	UPPER		uppercase	LOWER		upperletter	LOWER		uppercaseletter	LOWER		echo select * from t1 where NOT f1 != '12';---------------------------------------------------------	f1	f2	---------------------------------------------------------	12	C		echo select * from t1 where f1 = f2;---------------------------------------------------------	f1	f2	---------------------------------------------------------	14	14		echo select * from t1 where f2 between 'A' AND 'C';---------------------------------------------------------	f1	f2	---------------------------------------------------------	Illegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for StringIllegal Operator:Not Supported for Stringecho update t1 set f2 = '2' where f1 != f2;Statement Executed: Rows Affected = 10---------------------------------------------------------	f1	f2	---------------------------------------------------------	10	2		11	2		12	2		13	2		14	14		50	2		This is really a ver	2		UPPERCASE	2		uppercase	2		upperletter	2		uppercaseletter	2		echo update t1 set f2 = '3' where f1 = '50';Statement Executed: Rows Affected = 1---------------------------------------------------------	f1	f2	---------------------------------------------------------	10	2		11	2		12	2		13	2		14	14		50	3		This is really a ver	2		UPPERCASE	2		uppercase	2		upperletter	2		uppercaseletter	2		Statement Executed: Rows Affected = 1---------------------------------------------------------	f1	f2	---------------------------------------------------------	10	2		11	2		12	2		13	2		14	14		This is really a ver	2		UPPERCASE	2		uppercase	2		upperletter	2		uppercaseletter	2		Statement Executed

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?