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 RUclips 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 ❤
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 ❤️✨😁🥳😍
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);
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??
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..
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.
!!!!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.....
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?
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😂😂
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).
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
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;
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..
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 :)
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...
![Lil Uzi Vert - Chill Bae [Official Music Video]](http://i.ytimg.com/vi/D7F42F_JM3U/mqdefault.jpg)
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 RUclips 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 ❤
Thankuu so much for ur support...🙏🏻😊
what u said is so true..
💯
Theee besttt cs teacher ❤❤❤❤
Best computer teacher 👍👍
Thanku so much... 🙏🏻🙂
Thank you maam for wonderful explanation ❤❤❤
Most welcome 😊
terrific video but mam pls provide ppt in the discription box of every video this would me very helpful
Thanks for this quality content
my pleasure...
Mam your teaching quality are next level and you are teaching in govt. School
Thanks a lot
Is she teaching in govt school?
Too clear ma'am. Thanks ma'am
Welcome
Keep watching
everything is clear mam. Thank you so much for your efforts.
You are welcome 😊
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 ❤️✨😁🥳😍
Thanku so much... 🙂
Thankyouu so much mam , today after 40 min , there is my board practial , thankyou for helping!!
My pleasure
Mam I'm very thankful to you
Thank You so much..😊🙏🏻
Mam .....just bcz of u i got 65 out of 70 in preboard
That's great...
Congratulations!!!
Ma'am.. what if we add constraint NOT NULL while adding a new column by alter table?
No bro you can't enter this
Mam you have cleared my all the concepts!!best video on SQL.... Thanks mam !!! Mam please send me ppt of complete SQL.. please mam!!!!🙏
Thanku so much...
😊🙏🏻
Sure...send me ur mail id
@@SwatiChawlaofficial nkec12525@gmail.com
Pls send on this email nkec12525@gmail.com 🙏
Mam please send ...I haven't received it yet..
Thank you mam for helping this concept
Most Welcome
mam thanks i watched complete playlist of mysql and finding cs quite easy because of you. very very thanks mam......
You are most welcome
Mam why is warning shown after execution ? (At 13:40)
Does it have any significance ?
Nice video thanks Ma'am
Most welcome 😊
Thanks a lot mam for this great grand explanation 🥰
Thanks and Welcome
Keep Watching
no doubts🤩🤩🤩🤩
That's Great..
Thanku...
Can we add primary key constraint while adding a new column by alter table?
Ma'am.. pls ans this
Mam you are really good😎 teacher
Thanku so much....
It really means alot...
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
Can we change the datatype or datatype size through CHANGE command of alter table???
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);
Thank you mam
Welcome
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??
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..
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.
Legend seeing this before a month of final exam😂
Best wishes for your exam
A legend pro max watching the day before board exam, even after having 24 days to study.
@@radioactive7583 10hrs before exam
@@hakeshcoc208915 mins before exam in exam hall
Watching in Exam hall💀
All sql comands will be in capital letters
But in some programs they are in small letters and some are capital
SQL IS CASE INSENSITIVE LANGUAGE YOU CAN USE BOTH SMALL OR CAPITAL
@Aarthi Pekamwar
@@parthsingh1412 not case sensitive
@@parthsingh1412 kyunki agar case sensitive hoga to wo depend karega ki tum command ko kese likh rahe ho
@@puspalatakar7006 Usne case INsensitive likha hai
Are these lec are sufficient for tomorrow's exam 😶
do the sample papers
Cbse boards?
@@asmiivarshney3380 ye
@@asmiivarshney3380 yepp
Mam update ke Alag type ke bhi Qns hai...jese update marks by increasing it by 5%...iss type ke qn chahiye
Homie from KV Berhampur 👊🤝
@@CosmoScion hiii dude...sry topper🤩🤩
@@srutirajprusty6404 UPDATE students
SET marks = marks * 1.05;
@@srutirajprusty6404 😂
UPDATE
SET marks = marks + (marks*0.05);
Thank you so much mam
Most welcome 🙏🏻😊
Ma'am how can we enter a column in-between 2 existing columns? Pls tell
Mam is there any android app good for SQL in your knowledge?
play.google.com/store/apps/details?id=app.compiler
@@SwatiChawlaofficial thnx mam 🙂🙂
!!!!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.....
in which u r having command.... if u r comfortable with these two..go for it + connectivity also, if possible
Okk...thanks mam....
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...?
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
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?
yes..drop command will completely delete the table..
You are best mam❤️
Thanks a lot 😊
Mam in alter command for single column addition its not working for int datatype if bracket is not enclosed
Please share your complete syntax
❤❤❤
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?
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😂😂
Yes we can do this...by the following syntax..
alter table emp add gender varchar(2) after name;
@@SwatiChawlaofficial ok ma'am 😊
In ALTER command both keywords change and modify seems same. In what situation we have to use change
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).
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
You can but if you don't then it will leave it null so no error will occur.
Can two columns have same name?
no
Mam can we copy entire data values from one table to another table?
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;
@@SwatiChawlaofficial ma'am not getting ispr short video bana dijiyega 🙏🙏🙏
Okk...
@@SwatiChawlaofficial 🙏
U are fabulous
Thanku..🙏🏻😊
can only one column be modified at a time mam
Yes
how to add data for newly inserted coloumns...
Using update commamd
@@SwatiChawlaofficial yes.....thank you but we can't add data for all new columns at a time....
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..
Ma'am when i am entering 2005 as year in dob it showing error and asks to enter 1990. What should i do?
Enter in the format of yy-mm-dd
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 :)
Mam
is it compulsory to give commit command after alter or update command
In case of connectivity??
@@SwatiChawlaofficial To make the changes permanent issue a command commit
Given in Sumita Arora in lesson 13
Yes
Mam if you could provide ppt it would be really helpful at the time of revision
thank you 🙏
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
Mam can u plz provide me a link for running SQL query in android phone
play.google.com/store/apps/details?id=app.compiler
@@SwatiChawlaofficial mam it is not giving output plz suggest anthor 🙏🏻🙏🏻
I have tried this..
It's working fine
@@SwatiChawlaofficial mam output is taking too much time
Mam when we use drop command then is it delete also database?
To delete table:
Drop table tablename;
To delete database:
Drop databasename;
Mam keyword ko capital main likhna zaroori hai kya
No
THank you mam loved it
Most welcome 😊
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 🙏
create table student
(rollno int,
name varchar(10),
mark float
);
alter table student add constraint PRIMARY KEY(rollno);
Thank you so much mam 🙏🤩😊😀
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
By using update command
@@SwatiChawlaofficial yes mam 😅 mam preboard aa gye h one shot series chla do
ALTER TABLE TABLE_NAME ADD NEW_COLUMN DATATYPE NOT NULL DEFAULT='HELLO'
Can u take live sessions
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...
Mam pls provide ppt also
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
😂😂😂
Plssssssssssss also provide ppt na maam.
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
Bro you have the feature of screenshot...Just simply use it and save the photos in a particular folder...membership...huh...
@@GSMHere lol
24:53 yeh kya tha ?
I like to study computer science due to mam
That's Great...
Thanku so much..
Ma'am.. what if we add constraint NOT NULL while adding a new column by alter table?
Thanks mam
Welcome..