@(geeks show ) InWorst case you may think that nobody i.e 0 watching this playlist Noo you are wrong I'm watching this playlist twice ❤️❤️❤️ Make more videos on SQL THANX
NULL to isme kaise change krte h sir. Mine IFNULL aur IS NULL ka use kia tha lekin kuch hua ni usse table me permanently change krne k liye, Jaise agar baki bachi hui null value ko change krna h to kaise karenge
Pls any one help in this scenario If colA and colB values are even update to even If any one column is even then update single Non of the values are even update null
I have a table in that there is a column 'EMAIL' In which first half is already filled Now i want to update rest half at a time without changing the first half.How can i do this??
Yes, By nested queries : First write query that selects from and to locations BY USING LIMIT, Then write one more query as you want to have data BY USING GENERAL QUERY KNOWLEDGE.
Describe your table structre , If stid is your first column the following command works ADD COLUMN column_name datatype(size) First; if it was after any column in the table then try this ADD COLUMN column_name datatype(size) After Column_name;
The only reliable video that explain easily how to update using case and select.
The language stinks.
@(geeks show ) InWorst case you may think that nobody i.e 0 watching this playlist
Noo you are wrong I'm watching this playlist twice ❤️❤️❤️
Make more videos on SQL
THANX
nicely explained....was searching for the solutions in various videos...but it finally ends here....!! grt work
This was new things to me...no one explain like this sir.... Thank you sir🙏🙏
big fan of your teaching style..
Sonam 145 no pe hi first ho gyi😂😂😂
Task: UPDATE Student SET mark=350
WHERE stid=6;
Reply me if is it right?
NULL to isme kaise change krte h sir. Mine IFNULL aur IS NULL ka use kia tha lekin kuch hua ni usse table me permanently change krne k liye, Jaise agar baki bachi hui null value ko change krna h to kaise karenge
Pls any one help in this scenario
If colA and colB values are even update to even
If any one column is even then update single
Non of the values are even update null
UPDATE STUDENT SET MARK=350 WHERE STID=6;
Sonam bechari fail hogyi🤣
😂
Update my_tab
set mark= 350
Where stu_id=6;
I have a table in that there is a column 'EMAIL' In which first half is already filled
Now i want to update rest half at a time without changing the first half.How can i do this??
by using insert into command
Yes,
By nested queries :
First write query that selects from and to locations BY USING LIMIT,
Then write one more query as you want to have data BY USING GENERAL QUERY KNOWLEDGE.
I want to arrange name column on left side before stid suggest the query
Describe your table structre ,
If stid is your first column the following command works
ADD COLUMN column_name datatype(size) First;
if it was after any column in the table then try this
ADD COLUMN column_name datatype(size) After Column_name;
@@kotagirivenkatesh this query adds new column but not modifies as required
Sir, Is sonam your ex?
😂
I think sonam is your EX
Rahul mera hai hai usko vo first hahahahahaha
sonam gupta bewafa hain!!!