Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications
SQL Lab Exercises-4 Table Creation Show structure Insertion of Records SELECT Query SELECT Query SELECT with ORDER BY SELECT Query SELECT Query SELECT Query SELECT Query SELECT with BETWEEN Nested Query SELECT with COUNT() SELECT with SUM() UPDATE Query SELECT with SUM, GROUP BY and ORDER BY


Insertion of Records

Q:3
Insert data in all the fields. (at least 7 records)


SQL> INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT);
Enter value for accno: 1001
Enter value for name: SYAM KUMAR
Enter value for branch: CALICUT
Enter value for amount: 55000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1001,'SYAM KUMAR','CALICUT',55000)

1 row created.

SQL> /
Enter value for accno: 1002
Enter value for name: RAM KUMAR
Enter value for branch: COCHIN
Enter value for amount: 25000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1002,'RAM KUMAR','COCHIN',25000)

1 row created.

SQL> /
Enter value for accno: 1003
Enter value for name: KRISHNA KUMAR
Enter value for branch: TRICHUR
Enter value for amount: 45000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1003,'KRISHNA KUMAR','TRICHUR',45000)

1 row created.


SQL> /
Enter value for accno: 1004
Enter value for name: MOHAN KUMAR
Enter value for branch: COCHIN
Enter value for amount: 5000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1004,'MOHAN KUMAR','COCHIN',5000)

1 row created.

SQL> /
Enter value for accno: 1005
Enter value for name: ANIL KUMAR
Enter value for branch: TRICHUR
Enter value for amount: 35000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1005,'ANIL KUMAR','TRICHUR',35000)

1 row created.

SQL> /
Enter value for accno: 1006
Enter value for name: DEVA KUMAR
Enter value for branch: CALICUT
Enter value for amount: 60000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1006,'DEVA KUMAR','CALICUT',60000)

1 row created.


SQL> /
Enter value for accno: 1007
Enter value for name: ASHOK KUMAR
Enter value for branch: CALICUT
Enter value for amount: 45000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1007,'ASHOK KUMAR','CALICUT',45000)

1 row created.