1 echo CREATE TABLE t1 (f1 INT , f2 VARCHAR (12));
2 CREATE TABLE t1 (f1 INT , f2 VARCHAR (12));
3 INSERT INTO t1 VALUES(1, 'ABCDE');
4 INSERT INTO t1 VALUES(2, 'ABCDF');
5 INSERT INTO t1 VALUES(3, 'NBCDGH');
6 INSERT INTO t1 VALUES(4, 'NABCDIJ');
7 INSERT INTO t1 VALUES(5, 'PQRST');
8 INSERT INTO t1 VALUES(6, 'NIHAR');
9 INSERT INTO t1 VALUES(7, 'RAHUL');
10 echo select * from t1;
12 echo DELETE FROM t1 where f2 LIKE 'ABCD%';
13 DELETE FROM t1 where f2 LIKE 'ABCD%';
14 echo select * from t1;
16 echo DELETE FROM t1 where f2 LIKE '_BCD%';
17 DELETE FROM t1 where f2 LIKE '_BCD%';
18 echo select * from t1;
20 echo DELETE FROM t1 where f2 in ('NIHAR','rahul','CSQL1');
21 DELETE FROM t1 where f2 in ('NIHAR','rahul','CSQL1');
22 echo select * from t1;