Tutorial 4- SQL Constraints Part1 - My SQL Complete Playlist

[@sathwikupadhyaya8783]

Best guy out there in analytical field for beginners. Thanks Krish

[@kunalkumaraiml2365]

Thank you so much sir for such incredible videos.

[@write2ruby]

Very Important Topics are covered

[@dpranay6262]

if u have two more than 1 column as primary then that key IS CALLED COMPOSITE KEY

[@KL1_Khaled]

Good Job 🌹

[@krishj8011]

Nice tutorial...

[@sonquang527]

Can you add transcript to your statistics & machine learning playlists. My listening is not good enough. Thanks Sir

[@devgarg3130]

sir in tutorial-3 when you taught about delete statement i implement that and i deleted the middle entry now id which is auto-generated is not in proper order so how to reorder it?

[@vishnukumard.s9960]

Krish Make video on Data scientist all skills for 2022

[@prateek.agrawal]

will your Complete videos be available on one-neuron? bcoz we have joined bcoz of krish & sudhanshu sir

[@ganeshgunjal4220]

do we have offline lectures for ML course?

[@prateek.agrawal]

@@ganeshgunjal4220 everything is online

[@ganeshgunjal4220]

@@prateek.agrawal i mean pre recorded lectures. So that we can access it in our time.

[@prateek.agrawal]

@@ganeshgunjal4220 yes

[@dineshrajput2472]

Dropping unique constraints can be done by below method too: #Another way to add constraint alter table person add constraint unique (age,first_name); desc person; # How to drop a unique constraint alter table person drop constraint age; desc person;

[@jimiljoshi7998]

Sir,Just buy a technuron subscription and feeling good hope will learn complete data science there....Thank you for this platform

[@dhruvnayak7922]

Sir how to update or delete more than 1 data. please give the command line. 😊

[@bindu897]

Hi Krish, Thank you for this great session. I had one doubt, When we are creating the person table we gave not null and unique for ID column then its displaying as primary key but for first_name col also we gave not null and added unique by altering the table later then why its showing as unique only while describe the table? not as primary key?

[@OutofDeCave-lo3vp]

Hello Krish! Thanks for your dedication and efforts to share your knowledge and experiences with us. I have question regarding ALTER TABLE person part. Why we have used index with DROP ? Second question is , can we write some other word in the place of uc_ ? The complete code is like this ALTER TABLE person DROP INDEX uc_person;

[@Sushmitadhital]

alter table person drop index age; use this one

[@oe10s024]

Need to check two things: 1. In PERSON table, when you drop index (uc_person), it drops Age from unique key. However, it keeps first_name as a unique key because it was assigned unique_key initially. Can you please explain this? 2. In PERSON1 table, last_name was not assigned to NOT NULL. Later, last_name was assigned as a primary key and subsequently dropped from the primary key. Although it was dropped from the primary key, it remains NOT NULL. Can you please explain this?

[@himanshusoni9791]

I am a DME in a company, I use Google sheets and data studio.I am learning SQL but I think that googlesheet or excel is better then mySQL because of easy to use & Just using formula. So why should I learn SQL or why MNCs use SQL? Because Google sheets can also do same things. Please guide me what is use of mysql over google sheets or excel????

[@DesiExploration]

because there is a limit that a excel file can handle approx 10 lakhs of rows , and google sheets start crying after 10000 records. coming to SQL, available resources can be extended to manage million of million records and proper relations can be made among the tables. Access level control is there, particular person can access particular data.

[@gjayanth905]

Sir what is uc_person

[@Sushmitadhital]

alter table person drop index age;

[@kartikagarwal3807]

First prepare yourself before teaching. Giving incomplete and incorrect knowledge can be very dangerous.

[@praveenhtiwari9104]

sir how to contact you if someone is having with any doubt