we can add multiple rows in a table in single line, i tried and it worked for example : table name = fruit price=100,200 insert into fruit values ("mangoes",100),("apple",200);
Html , css over unga vidios parthu coding la oru interest vanthuruku superb explanation easy to understand same as next javascript podunga bro please !!🙏
9:25 q: How do you delete a column where mobile number is null? we should delete the column write so we should use ALTER TABLE costomer DROP COLUMN phone_number; 🤔
19:24:42 delete from fruit where name="apple" Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.016 sec what i do
Hi bro I have learned python from your video I need your guidance. I have 8 years of experience in total- first 5 yrs in core field and next 3 yrs in QA testing now I like to switch my carrier but I don’t know what to choose can you please suggest me. I will be waiting for you reply.
0 7 19:34:05 create table customer( customer_id int, customer_Name varchar(100), customer_Address varchar(100), city varchar(100), State varchar(100), Pin_Code int, ) Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 8 0.000 sec
I was using the shortcut Crtl+Enter to execute code, that only works for the last line, to properly execute all the code it's written the correct shortcut is Crtl+Shift+Enter.
question no 5 : question is how do you delete a column where mobile_number is null ? null ndra column thana delete pannanum aana antha whole row delete aagirukku ????
go to click EDIT , select PREFFERENCE , click SQL EDITOR , scroll down SAFE UPDATE BOX click to DISABLE, OK .... click to QUERY option RECONNECT TO SERVER. 1170 error problem solved .. thank u guys
Panirpinga nu nenaikira is a word
Time edukkum, paravala ukanthu panunga is an emotion 😄
"pannirpeengannu nambren" is his signature😉😄
we can add multiple rows in a table in single line, i tried and it worked
for example : table name = fruit
price=100,200
insert into fruit values ("mangoes",100),("apple",200);
Html , css mudichitom unga videos paathu than ❤ superb explanation easy to understand same as next javascript podunga bro please please
✌🏻🕺🏻
Bro - after seeing your video only I have started learning SQL. Super explanation. Looking for next video
Bro please Java Script tutorial podunga pls pls
Bro check the video he already post the javascript video
Html , css over unga vidios parthu coding la oru interest vanthuruku superb explanation easy to understand same as next javascript podunga bro please !!🙏
Java ku oru tutorial podumga brother it will be more useful 💟💟💟
Very useful brother😊
From Sri Lankan A/L student ❤❤
Javascript tutorial upload pannunga bro please
Thanks for the excellent tutorial bro.
Bro thank you so much na course padichitu iruka apo puriyala but unga video pathadhum ellam theliva theriudhu ❤
Thank you!
9:25
q: How do you delete a column where mobile number is null?
we should delete the column write so we should use
ALTER TABLE costomer
DROP COLUMN phone_number;
🤔
yah this was working, great man......
👍
Really thank you for your teaching bro..... awesome teaching...✨💯💓
Thanks and welcome
Bro nice series'. Thanks for making this. In this video 5th question alone seems confusing
bro you are my life saver💜
Bro while using null why table data are also deleted? explain bro please
Spr❤bro
An Exercise No.5 question is asked to remove the column only, not row. Please review it
yes but he deleted row
8:07 intha syntax crt ah poten bro error varuthu...athe update and where use pannalum eppadi tha error varuthu....solution sollunga plz
Send the script here
Bro....html,css,course complete paniga...NXT javascript podunga bro....web developer front end pathi complete panuga bro
Ama brother JavaScript tutorial upload pannunga pls.... Dailiyum ethirpathutu irukan... Neenga yeppo upload pannuvinga nu... Pls make it fast bro
Bro please upload javascript tutorial soon it could be very useful to us
We all ask you the javascript tutorial. Will you provide us or not..... Plz tell😢
Bro Java script podunga beginner to advanced
19:24:42 delete from fruit where name="apple" Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.016 sec what i do
Same problem bro !! What will i do for that error?
in settings...choose preference ...in that you ll have the last option uncheck the safe mode...you ll get it...i too faced the same
Hi bro I have learned python from your video I need your guidance. I have 8 years of experience in total- first 5 yrs in core field and next 3 yrs in QA testing now I like to switch my carrier but I don’t know what to choose can you please suggest me. I will be waiting for you reply.
thanks a lot bro
0 7 19:34:05 create table customer(
customer_id int,
customer_Name varchar(100),
customer_Address varchar(100),
city varchar(100),
State varchar(100),
Pin_Code int,
) Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 8 0.000 sec
Neega work bench la use pandregala illa ... terminal la use pandregala ....
we are waiting for javascript bro!!❣
Harvard CS50 course paathi Video Podunga bro
SET SQL_SAFE_UPDATES=0;
anna delete command, update command work aagamatuthu naa🥺
Zip code integer thana athu eppadi varchar la potu iruginga bro
bro ALTER TABLE CUSTOMER CHANGE column customer_address address varchar(30); it doesn't works.
8:52 delete agala bro
Bro in the practice sum 2, when i use ; to insert all the inputs the last line only print instead of 1,2,3.
I was using the shortcut Crtl+Enter to execute code, that only works for the last line, to properly execute all the code it's written the correct shortcut is Crtl+Shift+Enter.
1:27
2:37
9:35
Mojo language pathi poduga please 😊
Bro delete and update panna you are using safe mode varudhu bro give me solution for that problem 😢😢
Query - reconnect to server
Disable the Safe Mode option from edit and you can also disable the safe mode option By using Query
@@testuser-sm7ejepdi bro disable pandrathu
Bro zip code int varathaa
An Exercise No.5 question is asked to remove the column "Mobile_number " Null value" only, BUT deleted all other column data. Please review it
Bro teach c++
bro put video about how to connect mysql and work in vs code and see our datas in database
(Q:3) ALTER TABLE customer RENAME COLUMN customer_address TO address;
bro first question zip code should be int datatype but you used varchar is it correct..plz correct me if i am wrong
Javascript tutorial video upload please bro
Data insert pandrapa same column values mattu repeat aaguthu
1row affected nu varuthu bro pls solve this
Bro sql command line use pannalama
Update delete yanaku agaveh matithu code worng karuthu
bro idula zipcode ku int data type use panlam la
9.22 deleted a row.we have to delete that coloumn only right?
13:00
Sir 4 values insert panna run pannum pothu mistake aaguthu sir.. Vantha row return aaguthu illa 1 row miss aaguthu.. What error sir
question no 5 : question is how do you delete a column where mobile_number is null ? null ndra column thana delete pannanum aana antha whole row delete aagirukku ????
Same doubt
myself too could you please explain me this
I got error code 1264 while updating the mobile number to the specific name. Why this mistake happened to me?
Dotnet ku scope irukka broo solunga brooooo
Dotnet tutorial podunga broooo plzz
One doubt bro sql update pannu poothu
Error code :1175 safe update mode nu varuthu anyone pls help😢
Set SQL_UPDATES =0; and run bro
@@kousalyagopal2903 eppadi run panna prob solve agiduma
@@kousalyagopal2903 tq sis
Then na settings la pooi safe mode nu off panne work agiruthu. Sis
@@kousalyagopal2903 then which purpose to use this syntax
@@JB-HariprasathR Edit preferences kuduthu panna apoo enku work aagala bro... So ithu pannen ..ipoo ok aagiruku
Bro all data deleted recovery panna mudiyadha
Power Bi videos podunga bro
Sql madum padicha sql developer ra pogalama?
this is my Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
yeah bro same
go to click EDIT , select PREFFERENCE , click SQL EDITOR , scroll down SAFE UPDATE BOX click to DISABLE, OK .... click to QUERY option RECONNECT TO SERVER. 1170 error problem solved .. thank u guys
@@_Shree21 solve agiduchi thankyou👍
SET SQL_SAFE_UPDATES=0;
Enakkum same problemtha vandhichi. Neenga editla click pannunga,adhula keela preferences option click pannunga,apram adhula SQL editor andha option click,then scroll down Anga safe update abdinu oru option irukkum adha disable pannunga.apram cancel panni veliya vaanga then refresh and open file SQL retry it.😎
Bro what is the difference between SQL and MySQL
Dml la lock option sollunga bro
Javascript tutorial podunga broo
Bro please put video to how to download my SQL and vs code in Windows 7 32 bit
bro same problem windows 7 and 8 ku support aagathu MySQL neenga upgrade than pananum or else online compiler la try panunga
Java tutorial please 🙏 🙏🙏🙏🙏
Bro you are using safe update mode nu varuthu broo
Same bro..
Bro powet bi full tutorial podunga bro plsss
Bro django course podunga
SSL.TLS program video podunga
Bro please bro js video please🙏 like html css🙏
Bro dotnet podunga broo
Java script video....plz...
Bro please i need a session of html &css because I can't able to attend that two session due to my examination please bro conduct one more session
Kivy tutorial podunga bro please TH-cam la tamil video clear ah illa bro please please reply
👏👏👏...
Bro Java tutorial venum
Java script language poduga pls pls
Bro Java podunga
Bro pandas library potu bro
JavaScript bro needed bro
Bro java tutorial
Plsql videos poduga please bro
BRO JAVA SCRIPT SOLIKUDUNGA BRO PLS
Java explanation bro
Bro 5 question la mobile num column iruka null value ta na delete aanu but full table delete achu eppadi...
Please reply bro😢
Bro Java script podunga bro
Mobile number ku ethuku bro var use panniga .. athu ellame numbers thana ... yarukavathu thericha sollunga ❤️
int use panna chinna digits tha bro poda mudyum, apdillana varchar tha podanunu avasiyam ila instead use "bigint"(int ku bathila bigint)
@@SanthoshS-r9g Ohh ok thanks bro ❤️
@@SanthoshS-r9g unga kita personal ah pesa mudiyuma bro .. Konjam doubts iruku .. clarify panna .. Use fulla irukum bro 🙌
JavaScript Tutorial podunga
Bro javascript tutorial podunga bro
bro insert panna
error 1146 nu kathudu
BRO JAVA SCRIPT SOLIKUDUNGA BRO PLS
Javascript video podunga bro
BRO JAVA SCRIPT SOLIKUDUNGA BRO PLS