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

[@arvindsinghrawat538]

G.O.A.T Krish Sirrrr ! Grateful

[@obsaa7259]

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

[@raghuram8645]

Thanks Krish..

[@krishj8011]

great tutorials

[@prateekagrawal1142]

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

[@ManaviVideos]

Alter table Person Drop index pk_person; #Drop multiple primary keys

[@anu4240]

KRISH IS THIS PLAYLIST SUFFICIENT FOR DATA SCIENCE INTERVIEW ?

[@fredyjose7445]

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

[@srinivasbogineni408]

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

[@namitaojha7861]

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

[@anushagarg7955]

@Krish Naik the check constraint is not getting dropped

[@Danny0605-DB]

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

[@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!

[@devgarg3130]

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

[@matheuslemos8013]

Hacker rank

[@raeesh2373]

Sql workbench and cmd if work on those platform you perform anywhere

[@MotheJojo]

hi i got error for this query alter table st_theresa add foreign key(school_pin) references st_little_flower(school_pin); create table st_theresa( id int not null, school_name varchar(50) not null, school_location varchar(60), school_district varchar(70), school_pin int not null, primary key(id) ); create table st_little_flower( id int not null, school_name varchar(65), pin int); alter table st_little_flower add school_pin int; alter table st_theresa add unique(school_pin); error is Error Code: 1822. Failed to add the foreign key constraint. Missing index for constraint 'st_theresa_ibfk_1' in the referenced table 'st_little_flower' pls give me solution

[@ranjit2391]

how to add multiple values in new column ?

[@biswajitroy-zp6lk]

Sir pls start Neo4j graph database

[@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

[@ankurkaiser]

You need to have an overall idea but majorly you focus on DA and tools. You need to have good knowledge of Python, SQL, Visualization tools, and some cloud services.

[@PankajTiwari-hp4pk]

Sir please mysql command line par kara dijiye

[@Thevamshichary]

how to drop check constraint?

[@antarabasu12]

sir how to drop foreign key , I am getting confused, not able to do it. I am doing : alter table department drop foreign key fk_teacherdepartment; desc department; , is this right??

[@redrighthand3383]

don't do entire drop foreign key fk_teacherdepartment just do drop foreign key

[@hasanmougharbel8030]

Hey there, kudos to your great efforts. I have a simple enquiry as an newbie sql learner. Why cant i have more than one primary key in a single table? Thanks for taking care of this.

[@skumar2705_channel]

Please sir provide pdf of this slide.

[@ronimarine5527]

Alter table person drop constraint pk_पर्सन;

[@NATIVEBYTarunRaj]

alter table Person alter city_name drop DEFAULT;