SQL Commands | Insert Command | Update Command | In Hindi
HTML-код
- Опубликовано: 14 окт 2024
- SQL Commands | Insert Command | Update Command | In Hindi | Tutorial#06
in this playlist, I am going to start Structured Query Language (SQL). SQL is one of the best database software which is broadly used. It is mainly the syllabus part of 11/12/BCA/BTech student and I have designed this in such a way that it is specially designed for 11/12/BCA/BTech student. In this video, I have explained SQL Constraints. SQL are basically set of rules that applies to a table. In this video I have explained the basic commands of sql i.e. insert, update command.
Telegram Channel: t.me/codeitupl...
Facebook Group: / 21673. .
Instagram: t.me/codeitupyt
Facebook Group: www.facebook.c...
Facebook Page: / codeitup-104310264625489
Website: codeitup.in
Join this channel to get access to perks:
/ @codeitup
Link to Previous Video: • Create Table | Create ...
Link to next video: • Alter Command in SQL |...
Tags Used:
mysql tutorial
beginners mysql
mysql
sql commands
class xii mysql tutorial hindi
insert command
update command
insert into statement
inserting data into tables
insert table sql
insert into table in sql
update query in sql
insert query in sql
alter and update in sql
alter update in sql
sql video tutorial for beginners
update
how to update sql
sql update tutorial
how to use update in sql
what is update in sql
beginners sql
sql update
#codeitup
#sql
#cbse
@CBSE
@CBSE INDIA
@Unacademy CBSE Science 11 & 12
@CBSE Udaan XI
@Ncert Solutions CBSE ncerthelp.com
i m so glad that we have such brilliant teachers who are giving quality content....
so lucky to be hindi speaker
😊🙏
@@codeitupsir kya ye sare concepts iss session ke liy same hai ya kuch new add ya delete hua hai...??
Sir..u r one of the opiest teachers in youtube..boards ka date aate hi..ip subject padhna padhega ka thought aaya..and then i was like...codeitup is there..nothing to worry
😊👍
Thanks sir , m aaj hi SQL to finish kar dunga, with the help of your channel
Glad to help you Subbu😊
thank you so much sir!! your videos are really informative and easy to grab the points!!
Most welcome Vishal, keep learning😊
You are Amazing sir 😊 Maine pure playlist 1 baar me dekh liya bina kisi boriouth ki 😌thankyou so much sir
Most welcome Vivek, keep learning 😊
Thank you so much sir....aapne bohot ache se sb clear kr diya 😢 thanks sir
Most welcome!
I am watching your all SQL video u have completed till this video😊😊
Sorry sir.
Mai apke vedio tak pahuchne par bht late hogyi lknn aj mujhe yeah bht use hua h bht informative hy thank u so much sir 😊
Thanks & most welcome Sneha
😊
Thnkyu so much sir me insert ke syntax me bhut confuse thi but apne mere confusion dur kar diya
Sir explanation is very good and apki video dekh ke hi mere notes ban jatte hai. Thank you so much sir ❤️❤️
Most welcome Daksh, keep learning😊
Best video to learn SQL👍🔥
🙂👍
You are like jeetu bhayiya of. Ip. For. Us.. The way. You help. Us.. Is. Really appreciating... Thanks sir🙏🏻❤❤
Most welcome Ishika!
Your explanation is really outstanding and too much better than my computer teacher
My pleasure Subbu 😊
@@codeitup Yes Sir, you explain in a quite detailed manner which proves to be very much helpful. You explain each and every small and big point. Thank you so much Sir🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thanks Aditi..
You taught very well
I understood in one flow 🙏 thank you so much love from Tibet
Thanks & most welcome Dorjee😊
U can understand Hindi ❓❔
@@ashishsrivastava371 Yes I can kumar shish ji
Thank you sir this videos is very helpfull for all. And sir apne +2 ke baad kya kiya tha sir btado😅😅
Thank you so much sir kya hi padhate h ap❤
😊🙏
Sit python board 2k24 k liye koi recent course aya h boards ane wale h kch ni padha ab decide kiya h apse hi padhenge🙁💕
Plz reply sir plz plz plz reply
Apne term 1 me bahut help ki 🙏🙏
😊
best video for sql ❤❤❤❤
🙂
Thanks sir me aap ke notes hi kar rha hu
That's good Gaurav!
Thank you sir... You are awesome ❤
Thanks & most welcome!
Dhanyavaad guru g , your explanation is fabulous. It's going to help me a lot in my exam tmrw.
Thax so much sir concept is all clear now..... Waiting for next videos...
Will upload soon Sakshi !
Sir apka😉 hr bachhe ki comment ko reply and response krna mujhe bhut achha lga
really you r something else sir;😍😘
Thanks dear😊
Thanku so much sir it help m alot🙏🙏🙏
Glad to help you Anju!
Very helpful sir
This videos are like heaven in this period
Glad to hear that Abhishek !
Thanks sir for this series
Most welcome!
Gorgeous explanation 💝
Sir is this playlist of yours sufficient for class 12 IP?
Thanks sir (aap nhi hote to mera kya hota )❤❤❤
U are great sir
😊🙏
Thanks. sir very Good class.
Always welcome Badal!
Very helpfull video
thank you sir
Glad to help you Saksham!
Very nice sir
sir are the syntax correct here, because I believe that the commands are written in CAPs.... Please do correct me if I am wrong sir.......
yes Aaryan ..i think you are correct ......syntax are generally used in CAPs...Thank me later Champ !!
@@ArmaanKhan-cd8tq thanks mate
Thankyou so much for your explanation. are your videos sufficient enough to learn all the SQL commands. Since, I am from different background and its my need to learn the SQL coding for job so are these sufficient enough?
Not sufficient but enough to build your strong base in database.
@@codeitup thankyou so much, I have to start from scratch and it is a good start
Sir jaisa ki hamne pichle video mei mobile no. ko unique key liya tha aur hamne iss video mei usko ravi ke liye null chora and according to the definition of unique key ham ek column mei duplicate values nhi daal skte hai..... Then sir kyaa ham usme null values uss particular mobile no. column mei repeat kr skte hai ya phir sirf wo ek hi baar rhega ??
Sir jabhi salary insert krenge tab output mein salary anup ki 50000.0 aayegi?
THANK YOU SIRRR JIII
Most welcome Akshat!
very well explained sir
Thanks Jeenie Rohit !
Agar agar salary 60000 hai aur hum phir se usse update kar ke 60000 set kare toh kya hoga??
Thank you for the video.
I have watch your class 11 playlist and secured 93 in class 11.
hn hojayega
@@nainasharma88510 thanks
Sir insert into aur select command same hota hai kya
sir....is it necessary to learn syntax too for board exam??????????
Superb explaination sir❤️😁
Thanks a lot 😊
THANKS 🙏🏻😊😊😀👍🏻👍🏻
Most welcome dear!
Nicely explained ☺️
Thanks dear..
Sir jis trha se attribute order mein agar vaise na deke 1 2 values change ho jaye toh accept krega ya error
Means designation value ki jagah mobile aa jaye toh ?? Plzz
Agar data types same hai to error nahi dega but agar data type change ho gay to error dega.
Sir mobile no ko long int bhi to rakh sakte hai....
Very nice explanation Sir
Thanks a lot Devansh!
@@codeitup Sir aapse information chayie kya aap apna phone number de sakhte hai
Pls mail to letscodeup@gmail.com
Thank you sir😊😊
Most welcome Daksh!
Sir is this content sufficient to prepare for class 12th term 2 ip examination?
i have a dought in insert command. is it possible to insert data without single inverted coma ie., (2,raja,hyderabad) like this is it
possible
Thanku sir
Always welcome😊
❤️❤️
🙂
Great sir ji👍👍👍
Thanks Akash!
Superb explanation sir👌
Thanks Mohit!
THANK YOUS SIR!!!
Most welcome😊
Nice look,
Thank you 😊
Sir date ko 2020-01-01 likhenge na...aapne month ki jagah JAN likha hai us se error show ho rha hai
Otherwise great explaination sir👍
Ohh sorry. I made this mistake. Yes the date format would be 'YYYY-MM-DD'. Thanks for the update Preeti.
Thx u very much sir
Most welcome!
Sir if two table is given and the question ask to insert in second table.Then how to make it sir can you please give me some hint sir.
Insert into emp values(107, 'Sameer' , 'Programmer' , null , 200000 , '2021-02-10');
Agar Value Na Ho To Kya Aese Kr Skte Hai ?
nahi , output mea null likha aa jayega most probably
Sir phone no. Char kaise hua vo to varchar hoga na char me to character value hi aata h na am I Right😶
Thank you sir
Most welcome Pawan!
Mai cs se darta tha
11th mera cs score 42/100
But
In class 12
Aapke lecture padkar term 1 me 33/35 laya
Thanks you sir
Awesome..😍
Thanks 🤗
Sir ek row krke hi vakue insert hogi ek sath mein nhi ?? Kya
Nahi, value row by row one by one insert hoti hai savita.
Promotion ho gaya ravi ka😂🤣
😊
Nice video sir 😍
Thanks Abhishek!
Love from ranchi
Thanks Tabish !
Sir can we update a value for element having null value?
Respect
Thanks😊
nice explan sir jii
Thanks and welcome Ranjan !
A small correction the date format isn't 2022-JAN-01
IT IS 2022 -01-02.
I mean month is not written as alphabet. It is written as numeric data
really ??
Yes thanks for correction.
Thankyouu!! I was stuck😊
Sir pls take a doubt live session
That day I will become mad ! All will ask a lots of question.
@@codeitup 😂😂
सर मेरे पास एक परेसनी है सर अगर मे एक फ़ील्ड स्किप कर दु तो क्या जब data इंट्री हो जायेगी तब क्या ख़ाली देखेगी
Ek example dijie, fir batata hu..
@@codeitup by example ager Mai ek field skip kar du to kya vo skip field jab mai table pe pade data ko dekhunga .tab ko skip he dekhegi .
@@ankitaginhotry1667 Yes waha NULL dikehga.
@@codeitup ok thanks a lot sir.
Sir can I get your number through this gmail akaginhotry8707@gmail.com
Term 2
Sir date is not working
Isn't the prompt for MySQL
mySQL> ...you are using only SQL>
.. 🔥
😊
Me trying to 0 the 1 dislike also 🙏🙏🙏🙏🙏🙏thank you bhai 😊😊😊😊
Thanks Ayush, Thanks for the support.
Sir table me apne mobile no. Me quotes kyo lagaye h
kyuki mobile no. ka datatype sir ne 'char' set kiya tha
for the veiwers : this type of date is not valid now , in place of name of month we should type number of the month.......
Sir char or varchar mein diff nhi btaya
Hmmmm bhul gya, koi nahi kisi video me bata dunga.
Sorry to say ..agar ye practically kar k batate tioh better hota..kyu ki aise samajh nhi aa rha.. mera table nhi ho paa tha create
Actually sir teaching is good but aapne actually practical dikhana chahiye.. Khali theory me kese hoga 😢
I think date format was wrong...
Hello sir
Hello
Sir ye date wale mai error 1292 dikha raha h
Date format will be YYYY-MM-DD please use this format.
Hello
Hi...
Sir ye to 11 ka h
Kyo 12 me as revision tour nii h kya? It is there Urvashi...
@@codeitup ha sir padh liya baar bar that's why
thankyou very much
Most welcome😊