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-3 Table creation Show table structure Record Insertion Simple Query SELECT with COUNT() SELECT with MIN() and MAX() Simple Query SELECT with MAX() SELECT with ORDER BY .. DESC SELECT with BETWEEN SELECT with COUNT() Show all records UPDATE Query SELECT USING COUNT() with GROUP BY COUNT() with GROUP BY and ORDER BY


Table creation

Q:1
Create a table Student with fields
RollNo      Number (6)        Primary key
Name        Character (25)
Batch       Character (20)
Total       Number (4)
Batch have values COMMERCE, SCIENCE, HUMANITIES


SQL>  CREATE TABLE STUDENT(
  2   ROLLNO NUMBER(6) PRIMARY KEY,
  3  NAME CHARACTER(25),
  4  BRANCH CHARACTER(20) CHECK(BRANCH IN('COMMERCE','SCIENCE','HUMANITIES')),
  5  TOTAL NUMBER(4));

Table created.