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?
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);
@@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?
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....
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...
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.
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,
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) );
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.
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.
![Lil Uzi Vert - Chill Bae [Official Music Video]](http://i.ytimg.com/vi/D7F42F_JM3U/mqdefault.jpg)
Mam MySQL to bilkul easy kar diya aap ne . Thankew so much❤️👍
It's easy and scoring too...
Thanku so much..🙏🏻😊
@@SwatiChawlaofficial yes mam 20 marks pakke hai aab to👍
@@Atharv_Tripathi_ Great..
Best Wishes!!!
Ma'am you have explained everything in detail very nicely thank you so much 😊😊
mam you are helping us alot thanks to your hard work and dedication
My pleasure..
Keep watching
Yes mam
Thanku
Crystal clear maam thku
Welcome
Mam thanks for clearing doubts
My pleasure
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?
yes...but it will not accept NULL as Default value..
Mam DOUBT: @17:18
NULL repeat kar skti hai, in UNIQUE constraint?
yeahhhh kvian.....
Chapter done✅
Great..
Keep Watching
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
Thanx for amazing lecture!
Welcome..
Maam please tell how we can set a field as unique after creating table...
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);
Ma'am can you please explain foreign constraints too?
Mam Can Unique key have 2 NULL Values in 2 Differnt Rows?
Yes
@@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?
amazing lecc!!
Thanku
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....
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...
ma'am please conduct mock test again for term ii like term i
Sure... Will plan
What about table constraint mam?
Is it necessary?
Mam please provide full project of CLASS XII with Screenshot, etc Please please it's a request.
Sure will upload guidelines also..for project
@@SwatiChawlaofficial When mam?
@@nikhilrai1136 Guidelines..I'll upload in the upcoming week..
@@SwatiChawlaofficial OK mam THANKS
Thank you so much mam
Welcome
Is foreign key constraint deleted from the syllabus mam?
No
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
If possible, share your Syntax
Ma'am, you hadn't explain the foreign constraints....
Please explain it🙏
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.
Ma'am and the syntax also?@@SwatiChawlaofficial
@@SwatiChawlaofficial Mam Please Make A Separate Video So That We Can Understand It Better. Please 🙏
What to do if default constraint is ignored mam?
Is foreign key constraint not needed mam
ma'am u haven't taught how to apply foreign key constraint. pls make a video
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,
Mam Is this come in cbse board exam
Yes.... it's in ur curriculum
@@SwatiChawlaofficial ok mam
thnxs for reply
mam aao jo padahte hai wo notes kidhr upload krte ho ??
please tell kl pre board hai mere
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
By applying unique constriant, can it have more than one null value?
yes
@@SwatiChawlaofficial thank you ma'am...😊
Is MySQL case sensitive???
No
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.
thanks ma'am
Welcome
12.8 revised syllabus deleted know mam plz plz clarify me
ruclips.net/video/4MSy61D485E/видео.html
Check out this for Revised Syllabus
@@SwatiChawlaofficial mam i dont know hindi creating table with sql constraints is deleted or not
Not Deleted
Mam is this the last video lesson of this chapter? Please Mam reply
MYSQL
ruclips.net/p/PL5Raijva2y4S2sDeMIMu1kAVjwjgWyvyK
This is the link of Playlist of MySQL...plz check ..have u watched all..
@@SwatiChawlaofficial thank you mam
Mam please ye bata dijiye ke ye video TERM 2 mai aa rahi hai kya
Yes
@@SwatiChawlaofficial thanks for reply
Using foreign key constraint is not showing any effect on deletion and updation
maam ye constrain topic 2023 24 syllabus pr h????plz reply maam......
Yes
Ma'am foreign key?
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)
);
@@SwatiChawlaofficial won't there be separate lecture for foreign key?
Check out this..
ruclips.net/video/adw0ELL-HS0/видео.html
Mam foreign key kasi assign krege
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)
);
Even 2x is slow 😭😭
What does INNODB mean mam?
Timestamp?
@@SwatiChawlaofficial what does it mean mam,?
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.
@@SwatiChawlaofficial thank you mam
foreign key?
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.
Mam... is foreign key constraint not in syllabus?
It is
Check constraint is not working mam
Please check out your syntax carefully... including brackets after check
awarding only 55 to male
Thanks you 🤗🤗🤗