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

Unlock the power of SQL Data Manipulation Language (DML) commands and SELECT statements with our comprehensive CZcams tutorial! 🚀
🔥 Dive into the world of SQL as we cover the essential DML commands: INSERT, UPDATE, DELETE, and SELECT. Learn how to manipulate data and query your database like a pro.
💡 Discover the art of retrieving specific information from your database with the SELECT command. We'll walk you through various querying techniques and practical examples.
🛠️ Get hands-on experience with real-world scenarios, and master the skills you need for effective data management and analysis.
👩‍💻 Whether you're a beginner looking to start your SQL journey or an experienced user seeking to refine your skills, this tutorial has something for everyone.
📋 Don't forget to like, subscribe, and hit that notification bell to stay updated with more SQL tutorials and tips! 📲💬
#SQL #DataManipulation #SELECTCommand #DMLCommands #DatabaseQuery #SQLTutorial #TechSkills

[@_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

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

[@nandhiniedu-wh6kf]

JavaScript video podunga romba useful ah irukum

[@suryaabhi8370]

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

[@vigneshm5595]

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

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

[@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?

[@arunprabhu6399]

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

[@elavarasants4304]

Super bro
Javascript video podunga bro helpfulla irukkum

[@arishjv1294]

Bro apdiye empty table values insert pannama csv file la irundha data load pandradhu sollunga bro using load command

[@R.mohamedmanasManas-xf9gz]

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

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

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

[@jjtuition]

Clear explanation

[@surendarmurthi551]

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

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

[@vijaysakthy5777]

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

[@priyadharshinir7261]

Thank u so much broo ❤❤

[@mncreative-321]

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

[@vlcuplevlogs]

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

[@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"

[@jayastar8059]

Hi bro can you please update Java full tutorial.

[@poovarasan_]

Javascript from scratch videos podunga bro

[@kingsgowthas2932]

Spr❤bro

[@nakathsharu7998]

SQL video fullah sikiramah upload pannunga bro.

[@VPN7TECH]

Super

[@karthicksaran7355]

Bro spread sheet corrupt recover video podunga bro

[@jencysaral7941]

Bro java tutorial podunga

[@sriashwin2004]

Bro java tutorial video podunga pls

[@sanjayrs3039]

SQL Server Videos podunga bro..

[@playertamizha2.052]

Bro leed code pathi video podga bro

[@jasontimjonathan2601]

hi bro, full video eppo varum???

[@psychocinemas8262]

Relational Algebra podunga bro

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

[@harinnishreeni5196]

Bro JS video podunga full tutorial pls

[@ashwinig1032]

javascript video podunga bro

[@shakir_nizfer]

Bro,Visual Studio latest version full video upload pls from beginning to advance 🫠

[@gokul5742]

JS video podunga brooo

[@s.barathkumarbca4835]

javascript video podugah bro

[@chandrasekar6833]

Java script biginner to advance video podunga

[@hemakumar.r7110]

Django vedios podungaaa Broooo

[@shaeditz1232]

Hii bro could you pls update java full tutorial

[@mohamedalthaf1364]

A W S video podunga bro

[@VIMALESHK-zs3uj]

What is the difference between alter and update command

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

[@yogiramv5552]

Bro...teach java script....

[@sanjaikumar867]

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

[@mn8332]

Dart video plz

[@user-wt2ie9ep7j]

java script full tutorial poduga bro

[@raj47dx57]

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

[@skvsaro2k878]

Yes sir including stored procedure also please 🙏🙏

[@RacklandStephen]

enaku 1175 error varuthu bro, atha epd solve panrathu bro

[@user-bp3es1qs4m]

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;

[@sridevikannan5779]

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

[@KarthiKeyan-xl3mh]

9:19 alter use pannalama

[@user-lf5xh5rr9h]

bro plss Javascript podunga...waiting la irukom

[@kesukesavan3594]

Broo update comment work aga mattudhu brooo🥲 error uhh verudhuu

[@ranjithkumarr8207]

Hi Bro, Java Course update pannunga

[@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....

[@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..

[@ece_a_23_monika.j72]

Bro java full course

[@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...

[@user-bp3es1qs4m]

Same prblm bro

[@arulprabu7331]

There is a solution to this problem

[@arulprabu7331]

Search errror code 1175 how to solve

[@balaji.r7562]

Update key la 1175 error varuthu

[@kasthurim3186]

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

[@gopikrishnathirunavukarasu3751]

Yes it's possible..

[@balaji.r7562]

Bro enakku update key use aakala bro

[@user-uu6tl4re2b]

Html css potinka javascript podunka

[@rahulram2311]

bro post java tutorials

[@krishnapriyar5665]

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

[@Prokidz_]

Bro where is javascript
I'm waiting ✋️

[@praneshsivan6288]

Bro one small request don't teach with direct sql command many people it's difficult to study use some gui like PHP adimneer we can generate table by gui and they can generate query for us it will be better understanding.

[@pradeepbehera5807]

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'

[@NaveenKumar-xb6sz]

while update command using its shows an error code 1175 any one help how to reslove

[@IndhujaT]

SET SQL_SAFE_UPDATES = 0 ;

[@prakash3425]

Java script podunga bro

[@bvigneshwaran8904]

you are using safe update mode nu error varuthu

[@FoodWorld281]

bro please upload java script

[@SriKanth-cn8fx]

Bro Java script podunga bro

[@vlcuplevlogs]

First view bro

[@umarhaz1435]

❤

[@hackedlegend9208]

Java video poduringala

[@jawaharjawahar9614]

Javascript poduuga

[@siranjeevi.B]

use dummy
create table fruit(
name varchar(100),
price int
)
select * from fruit
INSERT INTO fruit (name,price) VALUES
("john", 2334),
("praveen", 4534),
("suresh",34353);
INSERT INTO student (name, age, dept)
VALUES
("john", 23, "csc"),
("praveen", 45, "ece"),
("suresh", 34, "eee");
select * from student;
UPDATE student
SET dept = 'computer'
WHERE dept = 'csc';
SET SQL_SAFE_UPDATES = 0;
UPDATE student
SET age = '30'
WHERE age = '23';

[@sundargv2367]

bro update comment use pannunom na 1175,1064 error varuthu

[@ArunKumar-zj1tu]

Amma bro enkum apditha varthu

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

[@ChinweOge]

🤗

[@yuaneshwarir1575]

Bro update doesn't Work

[@jagadeshwarank7789]

Bro i got 1175 error code 😞

[@Bharathraj85]

1175 error bro

[@Genoz220]

First view

[@expresscomedy813]

Bro java

[@vasanthsanthosh4911]

Hi

[@JB-HariprasathR]

Javascript 😢 tutorial bro

[@multycatjourney]

I can't update 😢 there is an error

[@AsryMR]

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

[@sakthiswaryalaganderan4236]

Error 1175

[@Cricket-vt17]

Hii nro

[@BalaBala-xd4ut]

Bro post best putty videos bro

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

[@innocentinnocent4939]

Naa Skip panna pakurathu unga video mattumthan bro

[@FoodWorld281]

bro please upload java script

[@dr.rubiya6262]

❤

[@FoodWorld281]

bro please upload java script