Tutorial 5- Primary Key, Foreign Key, Check And Default Constraints-MySQL Complete Playlist

SQL constraints are used to specify any rules for the records in a table.
Constraints can be used to limit the type of data that can go into a table.
It ensures the accuracy and reliability of the records in the table, and
if there is any violation between the constraint and the record action,
the action is aborted. Constraints can be column level or table level.
Column level constraints apply to a column, and table-level constraints
apply to the whole table.
This is the Part 1 series
1. Not Null
2. Unique
3. Primary Key
4. Foreign Key
5. Check
6. Default
7. Index
#mysqltutorial
Subscribe @Krish Naik Vlogs channel for more educational videos on finance and investment
Please donate if you want to support the channel through GPay UPID,
Gpay: krishnaik06@okicici
Telegram link: t.me/joinchat/N77M7xRvYUd403D...
#datanalyst #roadmaptobecomedatanalyst
Please join as a member in my channel to get additional benefits like materials in Data Science, live streaming for Members and many more
/ @krishnaik06
-----------------------------------------------------------------------------------------------------------------------
Connect with me here:
Twitter: / krishnaik06
Facebook: / krishnaik06
instagram: / krishnaik06
-----------------------------------------------------------------------------------------------------------------------

[@arvindsinghrawat538]

G.O.A.T Krish Sirrrr ! Grateful

[@raghuram8645]

Thanks Krish..

[@krishj8011]

great tutorials

[@obsaa7259]

Always 'm watching u'r video after click like Button!

[@prateekagrawal1142]

Just a request please put interview questions for data analysis with their answers as previously there were just questions and not answers

[@namitaojha7861]

can you please make a video of explaining what is set foreign_key_checks = 0

[@ranjit2391]

how to add multiple values in new column ?

[@dhananjaybiraris695]

is it possible to use multiple primary key without using constraint ?

[@fredyjose7445]

Please make me understand why we need to mention reference of previous table when ever we add constraint foreign key

[@Thevamshichary]

how to drop check constraint?

[@anu4240]

KRISH IS THIS PLAYLIST SUFFICIENT FOR DATA SCIENCE INTERVIEW ?

[@biswajitroy-zp6lk]

Sir pls start Neo4j graph database

[@srinivasbogineni408]

I have purchased one neuron course but i dont recieve full course on statistics, no body is responding will you solve this issue

[@PankajTiwari-hp4pk]

Sir please mysql command line par kara dijiye

[@inayatinu7068]

cant we just mention primary key beside not null of id to make the id primary key , similarly to make more than 1 column primary key!

[@adzinja6574]

Sir I am learning data analyst but I am little bit confused if he is doing data cleaning he need to learn some ML algorithm or not or he only focus on descriptive analysis I hope you solve my query thank you

[@anushagarg7955]

@Krish Naik the check constraint is not getting dropped

[@susantkumarsamantaraya6609]

Please sir provide pdf of this slide.

[@devgarg3130]

sir can you pease suggest any good platform where we can practice queries.

[@user-bd3tj4it3n]

hi i got error for this query