Back to Browse

6. NOT NULL & UNIQUE CONSTRAINTS | sql tutorial

2.7K views
Oct 18, 2024
5:13

SQL Constraints: NOT NULL & UNIQUE Explained In this video, learn how NOT NULL and UNIQUE constraints work in SQL! ๐Ÿš€ โœ… NOT NULL: Ensures a column cannot store NULL (empty) values. This guarantees every row has a value in that column. โœ… UNIQUE: Ensures all values in a column are different. Perfect for fields like email or usernames. Want more similar videos- hit like, comment, share and subscribe โค๏ธDo Like, Share and Comment โค๏ธ โค๏ธ Like Aim 5000 likes! โค๏ธ โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž– Please like & share the video. โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž– script create table emp1( id int, email varchar(128) NOT NULL, phone varchar(28) UNIQUE ) SELECT * FROM EMP1 INSERT INTO EMP1 VALUES(1,'[email protected]',123) INSERT INTO EMP1(ID,EMAIL,PHONE) VALUES(3,'DEF',234) โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž– AWS DATA ENGINEER : https://www.youtube.com/playlist?list=PLOlK8ytA0MghpdMjb0m9zu1v9s_qbRP0q Azure data factory : https://youtube.com/playlist?list=PLOlK8ytA0MgguN5XidtQXbILxwCdJCUJE&si=iEICXHP80zGchUYh Azure data engineer playlist : https://youtube.com/playlist?list=PLOlK8ytA0MghBrzu0i6WlTBdoO1WdwV_e SQL PLAYLIST : https://www.youtube.com/playlist?list=PLOlK8ytA0MggGXIKmbfZ-_Xqcos3JKdV- PYSPARK PLAYLIST - https://www.youtube.com/playlist?list=PLOlK8ytA0MgjvOpd-088NRU_vTYw_aryH โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž– ๐Ÿ“ฃWant to connect with me? Check out these links:๐Ÿ“ฃ Join telegram to discuss https://t.me/+Cb98j1_fnZs3OTA1 โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž– what we have covered in this video: โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž– Hope you liked this video and learned something new :) See you in next video, until then Bye-Bye! โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–โž–

Download

0 formats

No download links available.

6. NOT NULL & UNIQUE CONSTRAINTS | sql tutorial | NatokHD