1 update t1 set f1 = f2 where f1 =100;
2 update t1 set f1 = 10, f2 = 20 where f1 =100;
3 update t1 set f1 = 10+ 20 where f1 =100;
4 update t1 set f1 = 200;
6 AND with two different data types (int and char)
7 OR with two different data types (int and char)
8 BETWEEN with all data types
10 Test -ve values for integer and with between operator
11 comparison (f1>f2) with two different data types (int and short, int and float, int and char)
16 1.Total columns in unique, primary key constraint