user-profile-img

anshika Bhandari

@leelabhandari01qzv5o4k08c• Aug 2, 2022open-state

4GB RAM GENSHIN IMPACT MOBILE TEST (DEVICE-MOTO G40 FUSION 4/64) - YouTube

snapshot

4:18

-

4GB RAM GENSHIN IMPACT MOBILE TEST (DEVICE-MOTO G40 FUSION 4/64) - YouTubewww.youtube.com

user-profile-img

anshika Bhandari

@leelabhandari01qzv5o4k08c• Aug 2, 2022open-state

Poco M4 PRO 4G 64GB 6GB RAM Complete honest review - Poco M4 pro Power Black RS.8,478 #poco_m4pro - YouTube

snapshot

1:24

-

Poco M4 PRO 4G 64GB 6GB RAM Complete honest review - Poco M4 pro Power Black RS.8,478 #poco_m4pro - YouTubewww.youtube.com

user-profile-img

anshika Bhandari

@leelabhandari01qzv5o4k08c• May 18, 2022open-state

2.8.1 QuickSort Algorithm

snapshot

11:09

-

2.8.1 QuickSort Algorithm - YouTubewww.youtube.com

user-profile-img

anshika Bhandari

@leelabhandari01qzv5o4k08c• Apr 26, 2022open-state

MySQL UPDATE Statement

UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;

-

MySQL UPDATE Statementwww.w3schools.com

user-profile-img

anshika Bhandari

@leelabhandari01qzv5o4k08c• Apr 26, 2022open-state

MySQL CREATE VIEW, REPLACE VIEW, DROP VIEW Statements

CREATE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHERE condition;

-

MySQL CREATE VIEW, REPLACE VIEW, DROP VIEW Statementswww.w3schools.com

user-profile-img

anshika Bhandari

@leelabhandari01qzv5o4k08c• Apr 26, 2022open-state

MySQL DEFAULT Constraint

ALTER TABLE Persons ALTER City SET DEFAULT 'Sandnes';

-

MySQL DEFAULT Constraintwww.w3schools.com

user-profile-img

anshika Bhandari

@leelabhandari01qzv5o4k08c• Apr 26, 2022open-state

MySQL CHECK Constraint

ALTER TABLE Persons ADD CHECK (Age>=18);

-

MySQL CHECK Constraintwww.w3schools.com

user-profile-img

anshika Bhandari

@leelabhandari01qzv5o4k08c• Apr 26, 2022open-state

MySQL PRIMARY KEY Constraint

CREATE TABLE Persons (     ID int NOT NULL,     LastName varchar(255) NOT NULL,     FirstName varchar(255),     Age int,     CONSTRAINT PK_Person PRIMARY KEY (ID,LastName) );

-

MySQL PRIMARY KEY Constraintwww.w3schools.com

user-profile-img

anshika Bhandari

@leelabhandari01qzv5o4k08c• Apr 26, 2022open-state

MySQL UNIQUE Constraint

ALTER TABLE Persons ADD UNIQUE (ID);

-

MySQL UNIQUE Constraintwww.w3schools.com

user-profile-img

anshika Bhandari

@leelabhandari01qzv5o4k08c• Apr 26, 2022open-state

MySQL NOT NULL Constraint

ALTER TABLE Persons MODIFY Age int NOT NULL;

-

MySQL NOT NULL Constraintwww.w3schools.com