CONSTRAINTS IN MYSQL | MYSQL COMMANDS | CBSE CLASS XII | COMPUTER SCIENCE

[@Atharv_Tripathi_]

Mam MySQL to bilkul easy kar diya aap ne . Thankew so much❤️👍

[@SwatiChawlaofficial]

It's easy and scoring too... Thanku so much..🙏🏻😊

[@Atharv_Tripathi_]

@@SwatiChawlaofficial yes mam 20 marks pakke hai aab to👍

[@SwatiChawlaofficial]

@@Atharv_Tripathi_ Great.. Best Wishes!!!

[@snehlatajaiswal7366]

Ma'am you have explained everything in detail very nicely thank you so much 😊😊

[@lusifer5821]

mam you are helping us alot thanks to your hard work and dedication

[@SwatiChawlaofficial]

My pleasure.. Keep watching

[@VardhanMittal]

Yes mam

[@SwatiChawlaofficial]

Thanku

[@shailjagoyal9569]

Crystal clear maam thku

[@SwatiChawlaofficial]

Welcome

[@finnowen7964]

Mam thanks for clearing doubts

[@SwatiChawlaofficial]

My pleasure

[@urpaps]

Chapter done✅

[@SwatiChawlaofficial]

Great.. Keep Watching

[@TunerXMusic4u]

Thanx for amazing lecture!

[@SwatiChawlaofficial]

Welcome..

[@rohitnegi6990]

amazing lecc!!

[@SwatiChawlaofficial]

Thanku

[@indiranamasivayam9174]

In foreign key constraint even if we give cascade deletion is done only in child table not in parent but updation is done in both

[@SwatiChawlaofficial]

If possible, share your Syntax

[@dishikarastogi510]

Thank you so much mam

[@SwatiChawlaofficial]

Welcome

[@thinkoutofbox7985]

Maam please tell how we can set a field as unique after creating table...

[@SwatiChawlaofficial]

SYNTAX--- ALTER TABLE Table_Name ADD UNIQUE (Column_Name); Example--- To apply unique constraint on column Name of table Details: ALTER TABLE details ADD UNIQUE (NAME);

[@utpalm9453]

Ma'am.. one doubt, primary key does not take null values right? So, while we are applying DESC command then why it is showing the default value of the column in which the primary key constraint is applied as "NULL"?. I hope u understood my query?

[@SwatiChawlaofficial]

yes...but it will not accept NULL as Default value..

[@TylerDurden5055]

Mam Can Unique key have 2 NULL Values in 2 Differnt Rows?

[@SwatiChawlaofficial]

Yes

[@TylerDurden5055]

@@SwatiChawlaofficial Mam One More Q., is ●Mobile Computing and Network Security, Viruses , E-commerce payment and ●Interface python in MySQL are EXCLUEDED From Term 2 syllabus?

[@Aman-yt5qk]

ma'am please conduct mock test again for term ii like term i

[@SwatiChawlaofficial]

Sure... Will plan

[@Teenu]

thanks mam i just had a doubt that after watching complete mysql playlist do i need to study mysql from books like sumita arora or preeti arora. please mam reply....

[@SwatiChawlaofficial]

I've covered all the concepts.. If your concepts are clear..now try to practice more and more questions. By solving questions...ur concepts will get stronger...

[@vedarthselat2629]

Ma'am can you please explain foreign constraints too?

[@bantosingh7088]

Mam, you haven't covered Foreign key constraint in this video.....Is this topic not in syllabus for CBSE's 2020-2021 session...?!! Please reply mam

[@ayusharyan6825]

Mam DOUBT: @17:18 NULL repeat kar skti hai, in UNIQUE constraint?

[@swetasharma-g9m]

yeahhhh kvian.....

[@indiranamasivayam9174]

What about table constraint mam? Is it necessary?

[@factified9892]

thanks ma'am

[@SwatiChawlaofficial]

Welcome

[@nikhilrai1136]

Mam please provide full project of CLASS XII with Screenshot, etc Please please it's a request.

[@SwatiChawlaofficial]

Sure will upload guidelines also..for project

[@nikhilrai1136]

@@SwatiChawlaofficial When mam?

[@SwatiChawlaofficial]

@@nikhilrai1136 Guidelines..I'll upload in the upcoming week..

[@nikhilrai1136]

@@SwatiChawlaofficial OK mam THANKS

[@indiranamasivayam9174]

Is foreign key constraint not needed mam

[@Shefali_world]

Ma'am, you hadn't explain the foreign constraints.... Please explain it🙏

[@SwatiChawlaofficial]

A foreign key constraint is a type of database constraint that ensures the values in a column (or a set of columns) of a table must match the values in the corresponding column(s) of another table. It creates a link between two tables and maintains referential integrity, ensuring that the data remains consistent and reliable. In other words, a foreign key ensures that the data in one table references existing data in another table.

[@snehalsubudhi2883]

Ma'am and the syntax also?@@SwatiChawlaofficial

[@CooLShooter]

@@SwatiChawlaofficial Mam Please Make A Separate Video So That We Can Understand It Better. Please 🙏

[@rekhak2092]

Is foreign key constraint deleted from the syllabus mam?

[@sundaramsingh314]

No

[@utpalm9453]

By applying unique constriant, can it have more than one null value?

[@SwatiChawlaofficial]

yes

[@utpalm9453]

@@SwatiChawlaofficial thank you ma'am...😊

[@indiranamasivayam9174]

What to do if default constraint is ignored mam?

[@RaCoNnBoY0201]

Even 2x is slow 😭😭

[@indiranamasivayam9174]

Using foreign key constraint is not showing any effect on deletion and updation

[@bhumikasalvi6072]

mam aao jo padahte hai wo notes kidhr upload krte ho ?? please tell kl pre board hai mere

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@nc8002]

ma'am u haven't taught how to apply foreign key constraint. pls make a video

[@SwatiChawlaofficial]

Actually uploading the content according to CBSE curriculum, cbseacademic.nic.in/web_material/CurriculumMain22/SrSec/Computer_Science_SrSec_2021-22.pdf Foreign key concept i have explained in the starting videos of mysql,

[@siddharthsharma7006]

Mam Is this come in cbse board exam

[@SwatiChawlaofficial]

Yes.... it's in ur curriculum

[@siddharthsharma7006]

@@SwatiChawlaofficial ok mam thnxs for reply

[@vlogsaholic_]

Is MySQL case sensitive???

[@SwatiChawlaofficial]

No

[@zake9793]

only in the case of linux. If you use SQL in a linux os then its case sensitive but not in windows or any other os.

[@learningwithpython100]

Mam please ye bata dijiye ke ye video TERM 2 mai aa rahi hai kya

[@SwatiChawlaofficial]

Yes

[@learningwithpython100]

@@SwatiChawlaofficial thanks for reply

[@sarojininagarajan3688]

12.8 revised syllabus deleted know mam plz plz clarify me

[@SwatiChawlaofficial]

kzbin.info/www/bejne/an62qmlneZlra6c Check out this for Revised Syllabus

[@sarojininagarajan3688]

@@SwatiChawlaofficial mam i dont know hindi creating table with sql constraints is deleted or not

[@SwatiChawlaofficial]

Not Deleted

[@swetasharma-g9m]

maam ye constrain topic 2023 24 syllabus pr h????plz reply maam......

[@SwatiChawlaofficial]

Yes

[@sulochnanayak8340]

Mam is this the last video lesson of this chapter? Please Mam reply

[@SwatiChawlaofficial]

MYSQL kzbin.info/aero/PL5Raijva2y4S2sDeMIMu1kAVjwjgWyvyK This is the link of Playlist of MySQL...plz check ..have u watched all..

[@sulochnanayak8340]

@@SwatiChawlaofficial thank you mam

[@utpalm9453]

Ma'am foreign key?

[@SwatiChawlaofficial]

A FOREIGN KEY is a field in one table that refers to the PRIMARY KEY in another table. Example: CREATE TABLE Orders ( OrderID int NOT NULL, OrderNumber int NOT NULL, PersonID int, PRIMARY KEY (OrderID), FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) );

[@utpalm9453]

@@SwatiChawlaofficial won't there be separate lecture for foreign key?

[@SwatiChawlaofficial]

Check out this.. kzbin.info/www/bejne/l5XaYXiCgZJ7iZI

[@shivanigupta6950]

Mam foreign key kasi assign krege

[@SwatiChawlaofficial]

CREATE TABLE Orders ( OrderID int NOT NULL, OrderNumber int NOT NULL, PersonID int, PRIMARY KEY (OrderID), CONSTRAINT FK_PersonOrder FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) );

[@indiranamasivayam9174]

What does INNODB mean mam?

[@SwatiChawlaofficial]

Timestamp?

[@indiranamasivayam9174]

@@SwatiChawlaofficial what does it mean mam,?

[@SwatiChawlaofficial]

InnoDB is a storage engine for the database management system MySQL and MariaDB. Since the release of MySQL 5.5.5 in 2010, it replaced MyISAM as MySQL's default table type. It provides the standard ACID-compliant transaction features, along with foreign key support.

[@indiranamasivayam9174]

@@SwatiChawlaofficial thank you mam

[@saisathvik3587]

awarding only 55 to male

[@anmoll.rajputt]

foreign key?

[@SwatiChawlaofficial]

A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in another table. The table with the foreign key is called the child table, and the table with the primary key is called the referenced or parent table.

[@indiranamasivayam9174]

Check constraint is not working mam

[@SwatiChawlaofficial]

Please check out your syntax carefully... including brackets after check

[@shivamsalaria7487]

Mam... is foreign key constraint not in syllabus?

[@SJ-ic4yr]

It is

[@satwindersingh7285]

Thanks you 🤗🤗🤗