What is Unique Key in SQL | SQL Class Day #15 In Telugu
This Short is About SQL Class Not Null in Integrity Constraints Day #15 (SQL series) in Telugu for SQL Developers, Data Analyst and Business Analyst. By Srinivas Reddy Excel Telugu Videos
UNIQUE KEY:
This Constraint will not accept duplicate values.
-- Create Table:
CREATE TABLE EMP2(EID INT unique, ENAME VARCHAR(20), ESAL INT);
-- Insert Values:
INSERT INTO EMP2 VALUES(101,'SRINIVAS',22000);
INSERT INTO EMP2 VALUES(102,'abc',20000);
INSERT INTO EMP2 VALUES(103,'abc',12000);
INSERT INTO EMP2 VALUES(102,'ABC',20000); //Error
SP_HELP EMP1
#sqltelugu #excel #shorts #telugu #excelteluguvideos #mysql #sqltelugu
Please Follow us on Instagram: / excelteluguvideos
Telegram: https://t.me/EXCELTELUGUVIDEOS