mysql> create database students;
Query OK, 1 row affected (0.02 sec)
mysql> connect students;
Connection id: 16
Current database: students
mysql> create table data(sr_no int, Student_Id int, Name varchar(50), Father_name varchar(50),
Mother_name varchar(50), Class varchar(10), Village varchar(50), Attendance int );
Query OK, 0 rows affected (0.04 sec)
mysql> insert into data values(1,1201,'Aditi Sharma','Rajesh Sharma','Sunita Sharma',10,'Sarhal
Qazian',234);
Query OK, 1 row affected (0.02 sec)
mysql> insert into data values(2,1202,'Arjun Verma','Suresh Verma','Meena Verma',10,'Morron',230);
Query OK, 1 row affected (0.02 sec)
mysql> insert into data values(3,1203,'Priya Singh','Anil Singh','Kavita Singh',11,'Chak Des Raj',235);
Query OK, 1 row affected (0.02 sec)
mysql>
-> insert into data values(4,1204,'Rohan Gupta','Manoj Gupta ','Anjali Gupta',11,'Sultanpur',242);
Query OK, 1 row affected (0.02 sec)
mysql> insert into data values(5,1205,'Sneha Patel','Rakesh Patel','Nisha Patel',12,'Lassara',243);
Query OK, 1 row affected (0.02 sec)
mysql> insert into data values(6,1206,'Karan Mehta','Vijay Mehta','Pooja Mehta',12,'Burej',246);
Query OK, 1 row affected (0.02 sec)
mysql> insert into data values(7,1207,'Ananya Joshi','Sanjay Joshi','Rekha Joshi',12,'Urapar',229);
Query OK, 1 row affected (0.02 sec)
mysql> insert into data values(8,1208,'Vikram Rao','Prakash Rao','Lata Rao',12,'Jagatpur',235);
Query OK, 1 row affected (0.02 sec)
mysql> insert into data values(9,1209,'Neha Desai','Ashok Desai','Shalini Desai',12,'Garupar',236);
Query OK, 1 row affected (0.02 sec)
mysql> insert into data values(10,1210,'Rahul Kapoor','Amit Kapoor','Priya Kapoor',12,'Malpur',232);
Query OK, 1 row affected (0.02 sec)
mysql> select* from data;
+-------+------------+--------------+---------------+---------------+-------+---------------+------------+
| sr_no | Student_Id | Name | Father_name | Mother_name | Class | Village | Attendance |
+-------+------------+--------------+---------------+---------------+-------+---------------+------------+
| 1| 1201 | Aditi Sharma | Rajesh Sharma | Sunita Sharma | 10 | Sarhal Qazian | 234 |
| 2| 1202 | Arjun Verma | Suresh Verma | Meena Verma | 10 | Morron | 230 |
| 3| 1203 | Priya Singh | Anil Singh | Kavita Singh | 11 | Chak Des Raj | 235 |
| 4| 1204 | Rohan Gupta | Manoj Gupta | Anjali Gupta | 11 | Sultanpur | 242 |
| 5| 1205 | Sneha Patel | Rakesh Patel | Nisha Patel | 12 | Lassara | 243 |
| 6| 1206 | Karan Mehta | Vijay Mehta | Pooja Mehta | 12 | Burej | 246 |
| 7| 1207 | Ananya Joshi | Sanjay Joshi | Rekha Joshi | 12 | Urapar | 229 |
| 8| 1208 | Vikram Rao | Prakash Rao | Lata Rao | 12 | Jagatpur | 235 |
| 9| 1209 | Neha Desai | Ashok Desai | Shalini Desai | 12 | Garupar | 236 |
| 10 | 1210 | Rahul Kapoor | Amit Kapoor | Priya Kapoor | 12 | Malpur | 232 |
+-------+------------+--------------+---------------+---------------+-------+---------------+------------+
10 rows in set (0.00 sec)
mysql> select Village from data;
+---------------+
| Village |
+---------------+
| Sarhal Qazian |
| Morron |
| Chak Des Raj |
| Sultanpur |
| Lassara |
| Burej |
| Urapar |
| Jagatpur |
| Garupar |
| Malpur |
+---------------+
10 rows in set (0.00 sec)
mysql> select* from data where Attendance>235;
+-------+------------+-------------+--------------+---------------+-------+-----------+------------+
| sr_no | Student_Id | Name | Father_name | Mother_name | Class | Village | Attendance |
+-------+------------+-------------+--------------+---------------+-------+-----------+------------+
| 4| 1204 | Rohan Gupta | Manoj Gupta | Anjali Gupta | 11 | Sultanpur | 242 |
| 5| 1205 | Sneha Patel | Rakesh Patel | Nisha Patel | 12 | Lassara | 243 |
| 6| 1206 | Karan Mehta | Vijay Mehta | Pooja Mehta | 12 | Burej | 246 |
| 9| 1209 | Neha Desai | Ashok Desai | Shalini Desai | 12 | Garupar | 236 |
+-------+------------+-------------+--------------+---------------+-------+-----------+------------+
4 rows in set (0.00 sec)
mysql> delete* from data where sr_no=2;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '* from data where sr_no=2' at line 1
mysql> delete from data where sr_no=2;
Query OK, 1 row affected (0.02 sec)
mysql> select* from data;
+-------+------------+--------------+---------------+---------------+-------+---------------+------------+
| sr_no | Student_Id | Name | Father_name | Mother_name | Class | Village | Attendance |
+-------+------------+--------------+---------------+---------------+-------+---------------+------------+
| 1| 1201 | Aditi Sharma | Rajesh Sharma | Sunita Sharma | 10 | Sarhal Qazian | 234 |
| 3| 1203 | Priya Singh | Anil Singh | Kavita Singh | 11 | Chak Des Raj | 235 |
| 4| 1204 | Rohan Gupta | Manoj Gupta | Anjali Gupta | 11 | Sultanpur | 242 |
| 5| 1205 | Sneha Patel | Rakesh Patel | Nisha Patel | 12 | Lassara | 243 |
| 6| 1206 | Karan Mehta | Vijay Mehta | Pooja Mehta | 12 | Burej | 246 |
| 7| 1207 | Ananya Joshi | Sanjay Joshi | Rekha Joshi | 12 | Urapar | 229 |
| 8| 1208 | Vikram Rao | Prakash Rao | Lata Rao | 12 | Jagatpur | 235 |
| 9| 1209 | Neha Desai | Ashok Desai | Shalini Desai | 12 | Garupar | 236 |
| 10 | 1210 | Rahul Kapoor | Amit Kapoor | Priya Kapoor | 12 | Malpur | 232 |
+-------+------------+--------------+---------------+---------------+-------+---------------+------------+
9 rows in set (0.00 sec)
mysql>
