todo

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

update t1 set f1 = f2 where f1 =100;
update t1 set f1 = 10, f2 = 20 where f1 =100;
update t1 set f1 = 10+ 20 where f1 =100;
update t1 set f1 = 200;
delete from t1;
AND with two different data types (int and char)
OR with two different data types (int and char)
BETWEEN with all data types
IN with all data types
Test -ve values for integer and with between operator
comparison (f1>f2) with two different data types (int and short, int and float, int and char)



Later
1.Total columns in unique, primary key constraint