DML Commands
mysql> create table stud_det(name varchar(10), reg_no varchar(10), address varchar(10));
Query OK, 0 rows affected (0.09 sec)
mysql> insert into stud_det values('Kavya','22ce99','Coimbatore');
Query OK, 1 row affected (0.00 sec)
mysql> insert into stud_det values('Ilakkiya','22ce94','Aliyar');
Query OK, 1 row affected (0.00 sec)
mysql> insert into stud_det values('Monisha','22ce88','Chennai');
Query OK, 1 row affected (0.00 sec)
mysql> select * from stud_det;
+----------+--------+------------+
| name | reg_no | address |
+----------+--------+------------+
| Kavya | 22ce99 | Coimbatore |
| Ilakkiya | 22ce94 | Aliyar |
| Monisha | 22ce88 | Chennai |
+----------+--------+------------+
3 rows in set (0.00 sec)
mysql> update stud_det set name= 'Madhu' where reg_no='22ce88';
Query OK, 1 row affected (0.08 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from stud_det;
+----------+--------+------------+
| name | reg_no | address |
+----------+--------+------------+
| Kavya | 22ce99 | Coimbatore |
| Ilakkiya | 22ce94 | Aliyar |
| Madhu | 22ce88 | Chennai |
+----------+--------+------------+
3 rows in set (0.00 sec)
mysql> delete from stud_det where address='Chennai';
Query OK, 1 row affected (0.00 sec)
mysql> select * from stud_det;
+----------+--------+------------+
| name | reg_no | address |
+----------+--------+------------+
| Kavya | 22ce99 | Coimbatore |
| Ilakkiya | 22ce94 | Aliyar |
+----------+--------+------------+
2 rows in set (0.00 sec)
