#NOTE
#SQL treats ' BADDMUNDA' and 'BADDMUNDA' as two different values due to the space

#Table Creation
CREATE table STUDENT(
    ID INT,
    NAME VARCHAR(100),
    SUBJECT VARCHAr(100),
    ADDRESS VARCHAR(100)
    );
#Data Insertion:
INSERT  INTO STUDENT
    VALUES
(10,"SID", "MATH", "Lokandwala");
INSERT  INTO STUDENT
    VALUES
(20,"SIeD", "BIO", "MEENABAZAR");
INSERT  INTO STUDENT
    VALUES
(30,"BADDMUNDA", "CHE", "DYOTOLA");

#Basic SELECT:
#Retrieve all rows:

#SELECT * FROM STUDENT;
#WHERE
#SELECT * FROM STUDENT WHERE id = 10; 

#UPDATE Command:
#Update specific records based on conditions: 
#UPDATE STUDENT SET ADDRESS = "KHUSARWAH" WHERE NAME = "SIeD";

UPDATE STUDENT SET ADDRESS = "VYOMKESH" WHERE name = "BADDMUNDA";
#SELECT ID, NAME, ADDRESS FROM STUDENT;



#DELETE
DELETE FROM STUDENT WHERE ID = 10;
#SELECT * FROM STUDENT;

#DROP TABLE STUDENT;
SELECT * FROM STUDENT;

##Common Mistake: String matching is exact in SQL. Avoid extra spaces in conditions (e.g., " BADDMUNDA" vs. 'BADDMUNDA').

##NOTES DROP:
#Purpose: Completely removes the entire table, database, or column.
#Effect: All data, structure, and related objects (like indexes, constraints) are permanently deleted.
#Cannot be rolled back (in most systems).
#Syntax:
##sql
#Copy code
#DROP TABLE table_name;
#DROP DATABASE database_name;
###Purpose: Deletes specific rows from a table.
#Effect: Only the data is removed; the table structure remains.
#Can be rolled back (if used within a transaction).
##Syntax:
#sql
#Copy code
#DELETE FROM table_name WHERE condition;