String Function in SQL | In Hindi
Вставка
- Опубліковано 5 жов 2024
- String Function in SQL | In Hindi | Tutorial#11
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 all important String Function in SQL.
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: • Foreign Key Concept in...
Link to next video: • Math Functions in MySQ...
Tags Used:
mysql tutorial
sql tutorial
mysql class 12
class 12 sql
class 12 mysql
class 12 python
python class 12
sql class 12
mysql class 12
string functions in sql
sql string functions
sql string length
string functions in sql
string functions in sql
string functions in sql in hindi
string functions in mysql
mysql string functions
string functions in mysql in hindi
sql
mysql
mysql functions
introduction to mysql
class xii mysql tutorial hindi
#codeitup
#sql
#cbse
@CBSE
@CBSE INDIA
@Unacademy CBSE Science 11 & 12
@CBSE Udaan XI
@Ncert Solutions CBSE ncerthelp.com
Timestamp 🔥
1:37 Char()
4:49 concat()
6:26 lower()/lcase()
8:04 Upper()/ucase()
9:18 substr()/substring()
11:50 ltrim()
12:53 rtrim()
13:48 Trim()
17:44 instr()
19:39 length()
20:30 left()
21:25 right()
22:13 mid()
Nawice ❤️
Thanks broo 🙃
are you sure bro ?
Thnx bro
💓
No words enough,how I am thankful to you sir,love from Tibet 🙏
Thank you so much dear, God bless you!
Sir a =97 your teaching is great!!👌👌👍👍🇮🇳
😊
,,,getting confidence after watching this for preboards
🙂👍
Sir your explanations are LIT! 🔥 But Sir if you would have showed us these all things in MySQL then it would have been much better....I mean grasping things in practical mode would have been muchh useful and better....Sir if u agree to my point , then please make a single video in which u r showing all these commands and functions ❤️
Dear Learner, in this playlist ua-cam.com/play/PLmRclvVt5DtlM3Ef8ERo4sVVk-yTvSzX5.html to to last three videos where you will find practical implementation for all commands.
Sir you are the best even teachers don't give such content after getting even paid you are god sir just want to touch your feet❤️❤️❤️❤️
Thank you so much Umesh. God Bless You!
Sir i like how u explain everything with utter ease but want to request u one thing please check whether the functionsare in uppercase or lower case like in here at 17:16 we dont know which trim spelling is the correct one ...TRIM or trim? and the similar is done mutiple times thank you...
Lots of love🙏❤
😊
realy great , i am realy understand after seeing this video thank you ANAND
Good👍
Tomorrow I have my boards exam and I'm studying from your video.
😊👍
I am speechless ,how I am thankful to you sir but 1 request from my side sir can you please make a separate video on demonstrating all the command practically on system please 🙏🙏....
Dear Learner, in this playlist ua-cam.com/play/PLmRclvVt5DtlM3Ef8ERo4sVVk-yTvSzX5.html to to last three videos where you will find practical implementation for all commands.
@@codeituponce again thank you sir
as always awesome sir. I understood literally everything. can't thank you enough.
😊👍
Amazing explanation h Sir thank you yeh vedios provide krne k liye 😊😊
Thanks & most welcome Sneha!
the bestest. huge respect from Roorkee
Thanks Tanushi😊
You are my favorite teacher sir
Thanks😊
Sir what is the difference between substr function and mid function
They both seem like same
Sir ki smile and words 🔥🔥
😄
Thank you sir. Everything is clear.
Most welcome Roshan!
Thnkyou sir for this amazing explanation 😌
Most welcome!
sir your lectures are awesome. Can we collaborate ? please reply.Thank you!
Collaborate or enroll ?
For any query please mail to codeitupofficial@gmail.com!
Thank you so much sir 🙏🏻❤
Thanku sir. YOU ARE AWESOME
😊
Is mid and substr same?
Same doubt
Nice explanation sir
thank you sir really helpful video
Glad to help you Akansha!
Thanku so much sir your explanation is very good. Sir but tomorrow is my Ip unit 2 exam.
Most welcome!
Thanks u so sos sos sos much sir
Most welcome Umesh !
Aap practical to karate nhi
ASCII value of lower case 'a' is 97
You're teaching is osm sir
Thanks Mohit !
Sir right left function main space count hoga
example select left ( ' United Kingdom '‚ 7) ;
Output United
a=97 not 98.
Sir value left to right to 0 se count hogi na for example instr('amit','i');
Then result should be 2
Thank you so much sir for an amazing lecture. Sir I want to join paid batch. How will I join it?
Most welcome dear😊
For any query please mail to codeitupofficial@gmail.com!
Sir BSc.2nd year computer science ka bhi video upload kijiye
What is there in your syllabus?
Sir instr() numeric value return krta hai?
#Ask
very good class Sir thanks
Most welcome Badal!
Sir are you not doing practically on computer with the lectures? If possible plz do sir, we will understand more better then..
Go for the last video in this playlist, I have done it practically as well.
thank you sir 🙏🙏🙏
Sir LTRIM __sql___ esa function hoga output kya hoga ???
Out esa hoga kya sql___
Thank you sir ❤️
Sir apne eye jesa bataya he string function ki bare me axam me not bi asehilikhenge kia
I have a doubt. How to use select replace("Anand", "and", "d") in MySQL? Does replace() function only work in the SQL server?
Advance Python course video sir #Useful
10:47 substr function me indexing jaisa logic toh nhi lagega na.
Nhi lagega
Sir small a ka ascii code 97 hoga👍👍
Superb work sir👍👍👍👍👍
Thanks Neha!
Thank you sir 😍👍🏽
Most welcome😊
sir Please ek video Board practical liye bhi bana dijiye
please;
koi bhi topic pe banado app CBSE 12th class ke liye please
Sure Narendra !
@@codeitupsir jitna jaldi hO sake banadena please
Thank u sir
Most welcome!
23:35, Sir then what is the difference between substring () and mid()
Mid beech me se hi nikaltah number
Substr kahi se bhi nikaldeta h
Watching this before 1 hours left in my exam🤣
👍
thanku sir😍
Most welcome!
sir if the code is ....
select trim(' X Y Z ');
then will the output be
XYZ
?
X Y Z
No the spaces between X, Y , Z will remain same. Trim function only removes spaces from beginnning and end. Not the spaces in between.
Output will be: X Y Z
Substr and mid almost same
sir kya aap notes bhi provide karva sakte hoo
thanks and love from pakistan😘
Most welcome!
Thanks sir❤️
Most welcome !
Sir from where we get notes of sql
Sir where is python string excerise question...
You may find in the following playlist: ua-cam.com/play/PLmRclvVt5DtlWzjMNELOeIpQ-Q835d1DN.html
@@codeitup but there is not proper excersice as for string function ...
LEFT KE LIYE TABLE HONA JRURI HE KYA
Legend for real
Sirr this video is for 11th class also?
Yes
thanku sir
Most welcome😊
ASCII for a=97
SIR AGAR SUBSTRING ME
COUNT KRTE VKT UTNE CHARACTER HI NA HO JITNE BRACKET KE ANDAR DEDIYA HAI TOH OUTPUT KYA AIGA ERROR YA JITNE CHARACTER COUNT HUE UTNA HI ??
LEFT SYSTEM PE RUN NI HORA
5:40
Kaise ho
Accha hu, How are you?
Sir ye sql class 12 ke liye imp hai
Yes, obviously
@@codeitup tnk sir:-)
Sir a ka ASCII value to 97 hota hai
Yes a-97, b-98 and so on...
A-65, B-66
@@codeitup Thank you sir😁
Who is here for CUET Preparation ?
Nyc
Thanks 🤗
a=97 not 98
Hi sir
Please Use Live chat option when premiering.
Hello sir
Hello Sourav ! Please Use Live chat option when premiering.
char
Thanku sir. YOU ARE AWESOME
Thanks & most welcome😊
Thank you so much sir😊😊😊😊😊
Welcome dear !
Thanks sir
Sir pls explan Bubble sort
Thank you so much sir 😊
Most welcome!