MY SQL COMMANDS (PART-5) | ALTER | UPDATE | DELETE | DROP | CBSE CLASS 12 | COMPUTER SCIENCE

[@silent1975]

Mam is doing the work which our need of hour,python content is not found in any systematic manner like this channel anywhere google or KZbin and she is providing us quality content for us free of cost 🙏 i request everybody to make her channel as popular as our PHYSICS WALLAH SIR🥰 revolution begins here for computer subject. Do like share and subscribe ❤

[@SwatiChawlaofficial]

Thankuu so much for ur support...🙏🏻😊

[@emimaryrose643]

what u said is so true..

[@navinpatidar6974]

💯

[@aryajolly9870]

Theee besttt cs teacher ❤❤❤❤

[@Teacher-s1623]

Best computer teacher 👍👍

[@SwatiChawlaofficial]

Thanku so much... 🙏🏻🙂

[@rishabhsharma7701]

terrific video but mam pls provide ppt in the discription box of every video this would me very helpful

[@mrwordpress6676]

Thanks for this quality content

[@SwatiChawlaofficial]

my pleasure...

[@Karthika420]

Thank you maam for wonderful explanation ❤❤❤

[@SwatiChawlaofficial]

Most welcome 😊

[@Sourab_kumar_]

Mam your teaching quality are next level and you are teaching in govt. School

[@SwatiChawlaofficial]

Thanks a lot

[@PrithamFzx]

Is she teaching in govt school?

[@SA-so2zc]

Mam why is warning shown after execution ? (At 13:40) Does it have any significance ?

[@ruphusjohn8384]

Too clear ma'am. Thanks ma'am

[@SwatiChawlaofficial]

Welcome Keep watching

[@neerajmenon8107]

everything is clear mam. Thank you so much for your efforts.

[@SwatiChawlaofficial]

You are welcome 😊

[@smunofficial1963]

Thankyouu so much mam , today after 40 min , there is my board practial , thankyou for helping!!

[@SwatiChawlaofficial]

My pleasure

[@vaibhavigupta31]

You are the best teacher❤️..... cleared all my doubts✌️.....all the concepts of this video are crystal clear to me🥳.....your great explanation forced me to do this comment ❤️✨😁🥳😍

[@SwatiChawlaofficial]

Thanku so much... 🙂

[@vibilansivakumar]

Mam I'm very thankful to you

[@SwatiChawlaofficial]

Thank You so much..😊🙏🏻

[@NeerajKumar-qd8fy]

Mam you have cleared my all the concepts!!best video on SQL.... Thanks mam !!! Mam please send me ppt of complete SQL.. please mam!!!!🙏

[@SwatiChawlaofficial]

Thanku so much... 😊🙏🏻

[@SwatiChawlaofficial]

Sure...send me ur mail id

[@NeerajKumar-qd8fy]

@@SwatiChawlaofficial [e-mail]

[@NeerajKumar-qd8fy]

Pls send on this email [e-mail] 🙏

[@NeerajKumar-qd8fy]

Mam please send ...I haven't received it yet..

[@SurajSingh-wt6ol]

Thank you mam for helping this concept

[@SwatiChawlaofficial]

Most Welcome

[@studywithdivprit2744]

Mam .....just bcz of u i got 65 out of 70 in preboard

[@SwatiChawlaofficial]

That's great... Congratulations!!!

[@Barhrakshita]

Hey could you please tell me the strategy for cs , I am in 12th and I am not able to complete the syallbus till now,

[@utpalm9453]

Can we add primary key constraint while adding a new column by alter table? Ma'am.. pls ans this

[@utpalm9453]

Ma'am.. what if we add constraint NOT NULL while adding a new column by alter table?

[@xperthighlight]

Mam apki wajah se mere ache marks aaye h pure pre boards me bus ab me chahta hu ki kal mere boards me 90 above ajaye

[@Teenu]

mam thanks i watched complete playlist of mysql and finding cs quite easy because of you. very very thanks mam......

[@SwatiChawlaofficial]

You are most welcome

[@Surajfutureca8083]

Mam you are really good😎 teacher

[@SwatiChawlaofficial]

Thanku so much.... It really means alot...

[@innovative2966]

Nice video thanks Ma'am

[@SwatiChawlaofficial]

Most welcome 😊

[@utpalm9453]

Can we change the datatype or datatype size through CHANGE command of alter table???

[@SwatiChawlaofficial]

yes.. For example, the size of column name is 10 earlier and u want to change it to 15 now.. The query will be: mysql> ALTER TABLE students MODIFY name VARCHAR(30);

[@indiranamasivayam9174]

Càn only data type be changed using modify in alter command mam? If so, it is possible only to change int to float and vice versa and char to varchar and vice. Is it not possible to change int or float to char or varchar and vice versa.

[@naveenmittal5115]

Thanks a lot mam for this great grand explanation 🥰

[@SwatiChawlaofficial]

Thanks and Welcome Keep Watching

[@RahulSaini-pp5kz]

no doubts🤩🤩🤩🤩

[@SwatiChawlaofficial]

That's Great.. Thanku...

[@lalithaprabhath6920]

WHAT IF WE ADD CONSTRAINT, NOT NULL WHILE ADDING A NEW COLUMN BY ALTER TABLE MAM !??

[@dhruvsaini500]

ALTER TABLE Item ADD (Discount INT); Mam this was the ans of one of the question asked in sample paper. Here in the ans key there is the use of brackets even when we are adding a single column but mam the command which you have told there is no brackets use so mam if we write this command without brackets then it will be wrong??

[@SwatiChawlaofficial]

If u r adding multiple columns in a table using Alter command, then brackets are mandatory... If u r adding single column in a table, then brackets are optional... Plz try this urself practically as well..

[@Sourab_kumar_]

Legend seeing this before a month of final exam😂

[@SwatiChawlaofficial]

Best wishes for your exam

[@radioactive7583]

A legend pro max watching the day before board exam, even after having 24 days to study.

[@hakeshcoc2089]

@@radioactive7583 10hrs before exam

[@Aliumplayz]

​@@hakeshcoc208915 mins before exam in exam hall

[@avirajmishra8673]

Watching in Exam hall💀

[@anupmasrivastava4880]

Ma'am how can we enter a column in-between 2 existing columns? Pls tell

[@GSMHere]

Mam is there any way to add any column at any position in the table instead of adding it at the end of the table...?

[@rishabharyan613]

In mysql column position doesn't matter it can be changed when u will add column and again desc the table the position of column will be changed

[@shabeerkhan379]

Mam can we copy entire data values from one table to another table?

[@SwatiChawlaofficial]

Yes... The INSERT INTO SELECT statement copies data from one table and inserts it into another table. The INSERT INTO SELECT statement requires that the data types in source and target tables match. INSERT INTO table2 SELECT * FROM table1 WHERE condition;

[@sagarmishra7219]

@@SwatiChawlaofficial ma'am not getting ispr short video bana dijiyega 🙏🙏🙏

[@SwatiChawlaofficial]

Okk...

[@sagarmishra7219]

@@SwatiChawlaofficial 🙏

[@srutirajprusty6404]

Mam update ke Alag type ke bhi Qns hai...jese update marks by increasing it by 5%...iss type ke qn chahiye

[@CosmoScion]

Homie from KV Berhampur 👊🤝

[@srutirajprusty6404]

@@CosmoScion hiii dude...sry topper🤩🤩

[@CosmoScion]

@@srutirajprusty6404 UPDATE students SET marks = marks * 1.05;

[@CosmoScion]

@@srutirajprusty6404 😂

[@its__Hacker]

UPDATE SET marks = marks + (marks*0.05);

[@kri_nimita]

Can we add a new column after any desired column..for example in the table emp if i want to add the gender column just after the name column...can i do that?

[@RahulSaini-pp5kz]

you can add from alter but not sure if u can add at desired location but if you want to😂😂 delete the previous coulums add your desired coulumn and then add those deleted coulumns again😂😂

[@SwatiChawlaofficial]

Yes we can do this...by the following syntax.. alter table emp add gender varchar(2) after name;

[@kri_nimita]

@@SwatiChawlaofficial ok ma'am 😊

[@KesavanVenkateswaran]

Mam in alter command for single column addition its not working for int datatype if bracket is not enclosed

[@SwatiChawlaofficial]

Please share your complete syntax

[@indiranamasivayam9174]

can only one column be modified at a time mam

[@SwatiChawlaofficial]

Yes

[@studywithdivprit2744]

!!!!Mam I NEED A HELP !!!!!..board practical viva ke liye...apna best chapter theory ... MySQL ...aur data handling me se kya rakhna suitable.. . Hoga ....bcz in school , which examinar will came.... Unka database portion bhut strong h.....

[@SwatiChawlaofficial]

in which u r having command.... if u r comfortable with these two..go for it + connectivity also, if possible

[@studywithdivprit2744]

Okk...thanks mam....

[@aarthipekamwar3473]

All sql comands will be in capital letters But in some programs they are in small letters and some are capital

[@parthsingh1412]

SQL IS CASE INSENSITIVE LANGUAGE YOU CAN USE BOTH SMALL OR CAPITAL

[@parthsingh1412]

@Aarthi Pekamwar

[@puspalatakar7006]

@@parthsingh1412 not case sensitive

[@puspalatakar7006]

@@parthsingh1412 kyunki agar case sensitive hoga to wo depend karega ki tum command ko kese likh rahe ho

[@chesstricksandtraps1]

@@puspalatakar7006 Usne case INsensitive likha hai

[@utpalm9453]

Can two columns have same name?

[@SwatiChawlaofficial]

no

[@saumyasingh...8441]

You are best mam❤️

[@SwatiChawlaofficial]

Thanks a lot 😊

[@rajeshwarikurmi2039]

Mam keyword ko capital main likhna zaroori hai kya

[@SwatiChawlaofficial]

No

[@utpalm9453]

So, we can apply insert into and desc command even afte deleting it.. but not in the case of after dropping it .. am i correct ma'am?

[@SwatiChawlaofficial]

yes..drop command will completely delete the table..

[@mrabhishek3283]

24:53 yeh kya tha ?

[@viswaraje8441]

In ALTER command both keywords change and modify seems same. In what situation we have to use change

[@SwatiChawlaofficial]

MODIFY clause is used to change data type, size, default value, order of column, etc.. CHANGE clause of ALTER command is used to change the name of the column(s).

[@Drishti_Sadh]

Are these lec are sufficient for tomorrow's exam 😶

[@Proxz]

do the sample papers

[@asmiivarshney3380]

Cbse boards?

[@Proxz]

@@asmiivarshney3380 ye

[@Drishti_Sadh]

@@asmiivarshney3380 yepp

[@indiranamasivayam9174]

Mam , suppose we have created a table And we have altered it by adding few columns Now if we r asked to insert few records should we include the added columns or not

[@chesstricksandtraps1]

You can but if you don't then it will leave it null so no error will occur.

[@silent1975]

Thank you so much mam

[@SwatiChawlaofficial]

Most welcome 🙏🏻😊

[@artwithkajal1739]

Mam when we use drop command then is it delete also database?

[@SwatiChawlaofficial]

To delete table: Drop table tablename; To delete database: Drop databasename;

[@Theera4029]

how to add data for newly inserted coloumns...

[@SwatiChawlaofficial]

Using update commamd

[@Theera4029]

@@SwatiChawlaofficial yes.....thank you but we can't add data for all new columns at a time....

[@SwatiChawlaofficial]

Suppose you added two columsn in ur mysql table as: alter table student add (Stream varchar(10), fees int); To add values simultaneously for both the columns, update student set Stream='Non Med' , Fees='12000' where id=101; You can add values for all the rows also in a particular column, by omitting the where clause. Update Student set Gender='M' ; This will add Gender M in all the rows fro that particular column..

[@TunerXMusic4u]

Mam is there any android app good for SQL in your knowledge?

[@SwatiChawlaofficial]

play.google.com/store/apps/details?id=app.compiler

[@TunerXMusic4u]

@@SwatiChawlaofficial thnx mam 🙂🙂

[@indiranamasivayam9174]

Mam is it compulsory to give commit command after alter or update command

[@SwatiChawlaofficial]

In case of connectivity??

[@indiranamasivayam9174]

@@SwatiChawlaofficial To make the changes permanent issue a command commit Given in Sumita Arora in lesson 13

[@SwatiChawlaofficial]

Yes

[@virushkalover4884]

U are fabulous

[@SwatiChawlaofficial]

Thanku..🙏🏻😊

[@narayansinghtomar3250]

Mam can u plz provide me a link for running SQL query in android phone

[@SwatiChawlaofficial]

play.google.com/store/apps/details?id=app.compiler

[@narayansinghtomar3250]

@@SwatiChawlaofficial mam it is not giving output plz suggest anthor 🙏🏻🙏🏻

[@SwatiChawlaofficial]

I have tried this.. It's working fine

[@narayansinghtomar3250]

@@SwatiChawlaofficial mam output is taking too much time

[@manavnagrani8338]

Mam if you could provide ppt it would be really helpful at the time of revision thank you 🙏

[@SwatiChawlaofficial]

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

[@ManojKumar-qz5yf]

Ma'am when i am entering 2005 as year in dob it showing error and asks to enter 1990. What should i do?

[@SwatiChawlaofficial]

Enter in the format of yy-mm-dd

[@chesstricksandtraps1]

Actually when you enter like 2005-01-01 then instead of reading it as 2005 hyphen 01 hyphen 01, it assumes it to be 2005 minus 01 minus 01. Try it without the hyphen like 20050101. Reply if it works :)

[@aishanasim1900]

Mam ek table create kiye jisme rollno,name and marks h Mam we want rollno as primary key then .....mam plz make it by the use of Alter command 🙏

[@SwatiChawlaofficial]

create table student (rollno int, name varchar(10), mark float ); alter table student add constraint PRIMARY KEY(rollno);

[@aishanasim1900]

Thank you so much mam 🙏🤩😊😀

[@samdevan8077]

Can u take live sessions

[@SwatiChawlaofficial]

Yes... Already started... Even today also...6:15 p.m. for details...plz Check community tab.. Plz subscribe the channel and press the bell icon so that u don't miss any notification...

[@RohitKumarMishra-f4c]

Mam alter ka use krke yek new column add to ho jayega but usme null values hongi Agr null ki jagah usme kuchh aur enter krna ho to kese krenge

[@SwatiChawlaofficial]

By using update command

[@RohitKumarMishra-f4c]

@@SwatiChawlaofficial yes mam 😅 mam preboard aa gye h one shot series chla do

[@tanishksharma8430]

ALTER TABLE TABLE_NAME ADD NEW_COLUMN DATATYPE NOT NULL DEFAULT='HELLO'

[@krishnanikhil2507]

THank you mam loved it

[@SwatiChawlaofficial]

Most welcome 😊

[@Aves7]

Thanks mam

[@SwatiChawlaofficial]

Welcome..

[@poonammaurya7526]

Plssssssssssss also provide ppt na maam.

[@SwatiChawlaofficial]

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

[@GSMHere]

Bro you have the feature of screenshot...Just simply use it and save the photos in a particular folder...membership...huh...

[@mayank5549]

@@GSMHere lol

[@whatsappstatus6113]

Mam pls provide ppt also

[@SwatiChawlaofficial]

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

[@Sourab_kumar_]

😂😂😂

[@Katojameskats]

❤❤❤

[@zayafila4528]

I like to study computer science due to mam

[@SwatiChawlaofficial]

That's Great... Thanku so much..

[@utpalm9453]

Ma'am.. what if we add constraint NOT NULL while adding a new column by alter table?

[@Sourab_kumar_]

No bro you can't enter this

[@umamaheswarisrirengan8579]

Thank you mam

[@SwatiChawlaofficial]

Welcome