#5 DML Commands in SQL | Insert, Update, Delete, Select | sql tutorial for beginners in tamil

[@_Shree21]

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

[@vhemanthvhemanthkumar8812]

Thanks ❤

[@vidhyap577]

Thank you...✨

[@_Shree21]

@@vhemanthvhemanthkumar8812 it's My Pleasure ✨😊

[@_Shree21]

@@vidhyap577 it's My Pleasure ✨😊

[@SuryaPrakash-cw9wd]

Thanks a Lot Bruhhhh

[@suryaabhi8370]

Bro I am Surya from banglore. tomorrow I have dbms exam tq for putting this video

[@vigneshwaransuriyamoorthy904]

13:02:35 update fruit set price=110 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.000 sec

[@D-SanthoshKumarR]

Have you solved this.??

[@IndhujaT]

SET SQL_SAFE_UPDATES = 0 ;

[@gowthamselvaraj7793]

I too got same error and Now, I am clear by seeing your comment bro, Thanks..

[@ramyaramesh9828]

could you explain this , what you have said@@IndhujaT

[@kasthurim3186]

Thank you for your answer☺☺. I also met with same error@@IndhujaT

[@vigneshm5595]

I am exciting waiting for this video sir🎉Tq so much

[@nandhiniedu-wh6kf]

JavaScript video podunga romba useful ah irukum

[@sathiyapriyan382]

i faced the problem now
so i go to edit-> its disable the safe updates -> click ok
then exit the workbench
open the MYSQL workbench
kindly below this command
use db_name - execute its row affected
now u update command
update table_name set age=20 where name="john"
its Updated,
then show the tables
select * from table_name

[@vasanthraja3536]

Update student set department="computer" where department="CSE"
Command work agala bro

[@vasurc1741]

yanukku work agala bro,

[@praising501]

@@vasurc1741 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

[@ARCHANAMOHANARANGAN]

yes

[@gayathrismotivsandinfos816]

For me tooo

[@arulvarman356]

bro SQL_SAFE_UPDATES is enabled for you .Use the command 'SET SQL_SAFE_UPDATES = 0' and try updating again it will work.

[@kokilavanibalakumar3021]

Thanks for your great teaching bro.🎉🎉❤

[@ErrorMakesClever]

Welcome!

[@arunprabhu6399]

Bro I can't update or delete a value without using limit clause! Is that necessary to apply that limit clause always?

[@R.mohamedmanasManas-xf9gz]

நன்றிகள் தலைவா!

[@priyadharshinir7261]

Thank u so much broo ❤❤

[@RohithRaj-t7k]

Error 1175 . You are using safe update mode nu varudhu bro ena panradhu therila 9:58

[@sifath021]

Use this query.
set sql_safe_updates = 0;

[@NithishRajkumar-w6m]

Delete panniru

[@raj47dx57]

Sql video daily upload pannunga bro it’s my humble request 😊

[@skvsaro2k878]

Yes sir including stored procedure also please 🙏🙏

[@SAJIN_SKY]

Thank you 😊

[@vlcuplevlogs]

First like naravya viedo podunga 🎉 we are understanding everything form your viedo

[@MohammedImran-dn5vw]

bro direct update is not working bro. but after implementing the SET SQL_SAFE_UPDATES =0; the particular value are updated , why not working direct update?

[@SaranyaG-d6k]

Thank you

[@pradeep-2901]

Bro value update panum bodhu you are using safe update mode nu error kaamikudhu bro please solution solunga 14:01

[@sudha.j5383]

same problem for me also

[@kousalyagopal2903]

I too have this problem 😢

[@kousalyagopal2903]

Solution:
Set SQL_UPDATES=0; and run

[@Deepak_7]

Same problem bro

[@sudha.j5383]

whether we have to write it as a code?if i write this as a code and run it is showing this error sis.@@kousalyagopal2903 Error Code: 1193. Unknown system variable 'SQL_UPDATES'

[@YogaLakshmi-h8x]

shall we use alter instead of update?

[@elavarasants4304]

Super bro
Javascript video podunga bro helpfulla irukkum

[@AM_I_SuperHeroO1]

Spr❤bro

[@subhasbose4554]

hey John i have these error what can do for that👇
12:59:17 update student set Marks= 8 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.000 sec

[@Ghost-17206]

Bro also for me this error occurs in exact line what can i do bro ?

[@kuttisuriya3713]

U need change in SQL work bench.. go edit➡️ preferences...➡️SQL editor,and scroll down and disable the "safe updates" and click ok and restart your workbench. Sure it will work ☺️

[@Janani00222]

​@@kuttisuriya3713thank you

[@nandhakumarnk2471]

@@kuttisuriya3713 its working bro
tq

[@Greytoasanic]

thankyou brother for the information..

[@Amirthamizh]

0 5 22:48:26 update fruit set price=150 where name="apple" Error Code: 1046. No database selected
Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. 0.000 sec
[Hi bro i got this error i also untick the safe update box but still i got this error so kindly help me out]

[@rahulgandhif5879]

Thanks a lot brother :)

[@hidha2649]

Anna unga vidio pathu than python padichan Anna, I am from srilanka. So a.l padkkrn .neenga flow chart konjam clear panni thara eluma bro

[@sanjaikumar867]

update student set age=27 where name="John"

[@yuvarajmanikandan5446]

plz explain i got this error: UPDATE STUDENT SET DEPARTMENT="CSE" where NAME="RAHUL" 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.000 sec

[@jjtuition]

Clear explanation

[@art_gj_8830]

bro while updating contents of table i faced one error while executing like "you ar using safe update mode " and source code implementing area displays that
"department is not valid at this position,expecting EOF , ; , what can i do ?

[@mkhvdo586]

yes bro i also having same problem . explain bro

[@Moni-itzme]

Anna thank u so much❤tmrw i have my class 12 cs exam😅

[@ErrorMakesClever]

All the best

[@Moni-itzme]

@ErrorMakesClever i done my exam very well bcoz of u bro tnk. U so much

[@karnamorthy1233]

Bro enaku varchar taa Venum naa epdi in the tables.... We can't use same letters rights in the column

[@yuvarajmanikandan5446]

I GOT A ERROR: PLZ HELP ME: 16 17:03:39 create table FRUITS(
Name varchar(100),
Price 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 4 0.000 sec

[@karthikaeyan2903]

update student set department="computerscience"where department="aero" 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.000 sec
whats the error here sir?

[@arulprabu7331]

Yes bro I face the same problem so can we do?

[@karthikaeyan2903]

@@arulprabu7331 disable the safe mode by going to preference option > SQL editor then scroll down there will be check box disable that now it works...

[@RohithRaj-t7k]

Same prblm bro

[@arulprabu7331]

There is a solution to this problem

[@arulprabu7331]

Search errror code 1175 how to solve

[@goodboys1597]

Bro enaku error varuthu bro error code 1175 ....
I can't update table bro
Please kindly tell something about it bro

[@nandhinisubramani8560]

same

[@KarthiKeyan-xl3mh]

9:19 alter use pannalama

[@naveenmohan-n1n]

brother in this video i have one doubt i have insert the mutiple (name, age , dep) it have any key is in sql and add one by one , kindly please tell me

[@Interestingfacts-14]

Hi naa...
Ipo name vandhu string ileya so athunale, we use double quotation. Aproma .. my question is ..
(Year yyyy/mm/dd, age ,salary,reg_no, report_no ) so idhuku ala... Double quotation use pananoma ile single quotes use pananoma Anna ?? Please do reply 🙏❤️

[@musicalbioarts]

AJ sir, I have a doubt
Before creating the table we should use alter command to change (for eg. You told department to dept)
While we have to change anything inside the table, we should use update command (for eg. You told about changing age from 23 to 20)
Am I right? If it is wrong, anyone pls correct me

[@kasthurim3186]

Bro.. In SQL, Can we insert all values at a same time? Is it possible?

[@gopikrishnathirunavukarasu3751]

Yes it's possible..

[@Ajay2k04]

Bro i have a error in my update code is 1175 you're using safe update mode
What i do???
my code is
Update student set dept="ECE" where dept="MECH"

[@ajaikarthik352]

also same error

[@Ajay2k04]

@@ajaikarthik352 set sql_safe_updates =0; run this code then do your update code

[@rajhapriya6289]

After saving the table, suppose i want to add elements in that previously saved table.. I can't able to edit the script how to do that

[@VPN7TECH]

Super

[@nakathsharu7998]

SQL video fullah sikiramah upload pannunga bro.

[@sunnyjustin8373]

bro had error on UPDATE student set age=23 have saved, but showing error....what the mistake can rply any one.

[@madhan0772]

Bro not working update command.pls give me solution

[@mohd_kaleefa7897]

Use before one command which is set sql_safe_updates = 0; and again put update command it will rum

[@jayastar8059]

Hi bro can you please update Java full tutorial.

[@logig618]

bro enaku update student set age=23 (wrong)kathudhu broo....what to do

[@ZEE004]

bro mysql app formate la iruka,mobile la instal panni use panra mari

[@santhiyaranis8659]

I have downloaded the sql but when I choosed the setup type as full it should that Mysql did not find the package in the current bundle suitable for package. What I do for this issue?

[@janarthanalife4837]

download the workbench and its package with the same version 8.0.3

[@santhiyaranis8659]

@@janarthanalife4837 How should I download

[@vijaysakthy5777]

Insert data ovvoru time run panathuku apram tha add panna mudiyum ah ore time la pannaudiyatha?

[@hemakumar.r7110]

Django vedios podungaaa Broooo

[@krishnapriyar5665]

Anyone can give the answer for 14:32 min questions.
I get an error

[@MohamedRazeen-v1c]

nested queries,joins video?

[@manibalabommi7154]

hii bro
for me error in
update student set age=23
and also i tried
update student set age=23 where name="smith"

[@VIMALESHK-zs3uj]

What is the difference between alter and update command

[@Rupika532]

Bro edulaye output soli thangaa really robha help full aa irukuu

[@jencysaral7941]

Bro java tutorial podunga

[@yogiramv5552]

Bro...teach java script....

[@sitheskrishna4504]

bro upadate command work aagala plz give the solution how to solve

[@s.barathkumarbca4835]

javascript video podugah bro

[@uniqueboybharathi4592]

Bro I have error in 10:01

[@Gopi1809-v1v]

Select command vantu dml kullathana varum bro nega dql solriga

[@pugazhpugazh1656]

Yenaku oru doubt itha namma excel ley itha vida fast ta pannalameyy😢

[@vijethsva5772]

Error 1175..... Solution.....
Go to Edit --> Preferences
Click "SQL Editor" tab and uncheck "Safe Updates" check box
Query --> Reconnect to Server // logout and then login
Now execute your SQL query

[@surendarmurthi551]

Bro one request visual basic beginners to advance course detailed ah teach panni videos poda mudiyuma

[@gamingnaveen8139]

Update and delete are errors ...I tried more times 😕..what reason bro..I put same what u done also error only occurs

[@naveen28]

Safe update error ku elaru application la poi trun on and off method soli irukaga......athuku innu method uh iruku..... queries la aa enable and disable panikalam....
Disable: set sql_safe_updates =0;
Enable: set sql_safe_updates =1;
This is proper method of update data......mukiyama ah queries la updates antha "s" podanu ilana error varum....elaru disable panitu update panni paruga then enable panitu update panni paruga.....this way elaru try pannuga guys.....nanu oru beginner than na therichi kita visiyam ah solalanu share panna....

[@poovarasan_]

Javascript from scratch videos podunga bro

[@deepika1835]

Update la where use pana update agala bro

[@manibalabommi7154]

c programming video basic to advance podunga bro please 😢😢😢😢😢

[@kesukesavan3594]

Broo update comment work aga mattudhu brooo🥲 error uhh verudhuu

[@nauzz28]

Bro oru web page epdi create panrathu aprm athu epdi deploy panrathu nu theliva video podunga bro clear ah… plss..

[@safwanss9990]

while using update error 1175 varuthu atha epdi solve panrathu

[@thangaveluk527]

Go to edit tab in mysql workbench and then preferences and click sql editor then scroll down and uncheck safe updates option

[@RacklandStephen]

enaku 1175 error varuthu bro, atha epd solve panrathu bro

[@RahmathnishaShajahan]

1175 error pls help me

[@goodboys1597]

Bro Frist comment parrunga

[@SandhiyaPalaniyammal]

Bro update command is not working

[@Sowmi-tn2zt]

Power Bi videos podunga bro

[@sanjayrs3039]

SQL Server Videos podunga bro..

[@sujig9041]

I have the error in update keyword

[@jasontimjonathan2601]

hi bro, full video eppo varum???

[@Prokidz_]

Bro where is javascript
I'm waiting ✋️

[@ashwinig1032]

javascript video podunga bro

[@balaji.r7562]

Update key la 1175 error varuthu

[@multycatjourney]

I can't update 😢 there is an error

[@AsryMR]

Disable Safe Update Mode🧏‍♂
SET SQL_SAFE_UPDATES = 0;

[@psychocinemas8262]

Relational Algebra podunga bro

[@yuaneshwarir1575]

Bro update doesn't Work

[@sgowtham-c2y]

Use privacy node bro

[@chandrasekar6833]

Java script biginner to advance video podunga

[@harinnishreeni5196]

Bro JS video podunga full tutorial pls

[@tamilarasantamilarasan6627]

SET SQL_SAFE_UPDATES = 0;
for the error code 1175 you just run this code and turn off the safe updates

[@murugansubramaniyan916]

Error 1175 Disable or untick the safe Update close workbench then run same comment it run successful ​

[@bvigneshwaran8904]

you are using safe update mode nu error varuthu

[@balaji.r7562]

Bro enakku update key use aakala bro

[@ALTHAFRAHIMANA]

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.

[@shaeditz1232]

Hii bro could you pls update java full tutorial

[@sundargv2367]

bro update comment use pannunom na 1175,1064 error varuthu

[@ArunKumar-zj1tu]

Amma bro enkum apditha varthu

[@21CS031NITHIYAJ]

bro plss Javascript podunga...waiting la irukom

[@mohamedalthaf1364]

A W S video podunga bro

[@karthicksaran7355]

Bro spread sheet corrupt recover video podunga bro

[@playertamizha2.052]

Bro leed code pathi video podga bro

[@JohnMaria-d3w]

Html css potinka javascript podunka

[@sridevikannan5779]

update fruits set price=60 where name="Banana" for this line the error code comes like 1175