No video :(

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

Подписаться 765 тыс.

Просмотров 110 тыс.

50% 1

Unlock the power of SQL Data Manipulation Language (DML) commands and SELECT statements with our comprehensive RU-vid 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

Опубликовано:

17 сен 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 210

@_Shree21 8 месяцев назад

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 8 месяцев назад

Thanks ❤

@vidhyap577 7 месяцев назад

Thank you...✨

@_Shree21 7 месяцев назад

@@vhemanthvhemanthkumar8812 it's My Pleasure ✨😊

@_Shree21 7 месяцев назад

@@vidhyap577 it's My Pleasure ✨😊

@SuryaPrakash-cw9wd 7 месяцев назад

Thanks a Lot Bruhhhh

@suryaabhi8370 11 месяцев назад

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

@vigneshwaransuriyamoorthy904 10 месяцев назад

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 10 месяцев назад

Have you solved this.??

@IndhujaT 10 месяцев назад

SET SQL_SAFE_UPDATES = 0 ;

@gowthamselvaraj7793 10 месяцев назад

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

@ramyaramesh9828 9 месяцев назад

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

@kasthurim3186 9 месяцев назад

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

@vasanthraja3536 7 месяцев назад

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

@vasurc1741 5 месяцев назад

yanukku work agala bro,

@praising501 4 месяца назад

@@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 4 месяца назад

yes

@gayathrismotivsandinfos816 3 месяца назад

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.

@sathiyapriyan382 6 месяцев назад

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

@MohammedImran-dn5vw 2 месяца назад

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?

@nandhiniedu-wh6kf 11 месяцев назад

JavaScript video podunga romba useful ah irukum

@arunprabhu6399 8 месяцев назад

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

@vigneshm5595 11 месяцев назад

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

@goodboys1597 Месяц назад

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

@karthikaeyan2903 10 месяцев назад

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 10 месяцев назад

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

@karthikaeyan2903 10 месяцев назад

@@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 10 месяцев назад

Same prblm bro

@arulprabu7331 10 месяцев назад

There is a solution to this problem

@arulprabu7331 10 месяцев назад

Search errror code 1175 how to solve

@SAJIN_SKY Месяц назад

Thank you 😊

@hidha2649 11 месяцев назад

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

@vijethsva5772 10 месяцев назад

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

@sanjaikumar867 9 месяцев назад

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

@kokilavanibalakumar3021 Месяц назад

Thanks for your great teaching bro.🎉🎉❤

@ErrorMakesClever Месяц назад

Welcome!

@musicalbioarts 29 дней назад

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

@tamilarasantamilarasan6627 Месяц назад

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

@pradeepbehera5807 11 месяцев назад

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

@sudha.j5383 11 месяцев назад

same problem for me also

@kousalyagopal2903 11 месяцев назад

I too have this problem 😢

@kousalyagopal2903 11 месяцев назад

Solution: Set SQL_UPDATES=0; and run

@Deepak_7 11 месяцев назад

Same problem bro

@sudha.j5383 11 месяцев назад

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'

@madhan0772 2 месяца назад

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

@ALTHAFRAHIMANA 24 дня назад

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.

@user-jo5fr8ht3p Месяц назад

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

@art_gj_8830 10 месяцев назад

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 9 месяцев назад

yes bro i also having same problem . explain bro

@siranjeevi.B 2 месяца назад

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';

@yuaneshwarir1575 3 месяца назад

Bro update doesn't Work

@user-dv8ue1rz5e 21 день назад

Use privacy node bro

@jayastar8059 11 месяцев назад

Hi bro can you please update Java full tutorial.

@sunnyjustin8373 16 дней назад

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

@ZEE004 25 дней назад

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

@R.mohamedmanasManas-xf9gz 3 месяца назад

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

@kasthurim3186 9 месяцев назад

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

@gopikrishnathirunavukarasu3751 8 месяцев назад

Yes it's possible..

@user-bp3es1qs4m 10 месяцев назад

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

@sifath021 10 месяцев назад

Use this query. set sql_safe_updates = 0;

@s.barathkumarbca4835 11 месяцев назад

javascript video podugah bro

@gamingnaveen8139 22 дня назад

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

@yogiramv5552 11 месяцев назад

Bro...teach java script....

@raj47dx57 11 месяцев назад

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

@skvsaro2k878 11 месяцев назад

Yes sir including stored procedure also please 🙏🙏

@elavarasants4304 10 месяцев назад

Super bro Javascript video podunga bro helpfulla irukkum

@jjtuition 3 месяца назад

Clear explanation

@rajhapriya6289 10 месяцев назад

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

@pugazhpugazh1656 2 дня назад

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

@jencysaral7941 11 месяцев назад

Bro java tutorial podunga

@arishjv1294 8 месяцев назад

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

@nakathsharu7998 11 месяцев назад

SQL video fullah sikiramah upload pannunga bro.

@sitheskrishna4504 Месяц назад

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

@rahulgandhif5879 Месяц назад

Thanks a lot brother :)

@NaveenKumar-xb6sz 11 месяцев назад

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

@IndhujaT 10 месяцев назад

SET SQL_SAFE_UPDATES = 0 ;

@subhasbose4554 10 месяцев назад

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 10 месяцев назад

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

@kuttisuriya3713 10 месяцев назад

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 9 месяцев назад

@@kuttisuriya3713thank you

@nandhakumarnk2471 8 месяцев назад

@@kuttisuriya3713 its working bro tq

@Greytoasanic 5 месяцев назад

thankyou brother for the information..

@Prokidz_ 11 месяцев назад

Bro where is javascript I'm waiting ✋️

@Ajay2k04 4 месяца назад

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 2 месяца назад

also same error

@Ajay2k04 Месяц назад

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

@hemakumar.r7110 10 месяцев назад

Django vedios podungaaa Broooo

@naveen28 6 месяцев назад

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

@vijaysakthy5777 9 месяцев назад

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

@poovarasan_ 11 месяцев назад

Javascript from scratch videos podunga bro

@priyadharshinir7261 4 месяца назад

Thank u so much broo ❤❤

@vlcuplevlogs 11 месяцев назад

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

@kesukesavan3594 11 месяцев назад

Broo update comment work aga mattudhu brooo🥲 error uhh verudhuu

@manisha.k.p6986 23 дня назад

Now i had to change name in the table ! And name goes in a predefined function!

@multycatjourney 10 месяцев назад

I can't update 😢 there is an error

@AsryMR 10 месяцев назад

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

@VPN7TECH 11 месяцев назад

Super

@VIMALESHK-zs3uj 3 месяца назад

What is the difference between alter and update command

@nauzz28 11 месяцев назад

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

@Rupika532 2 месяца назад

Bro edulaye output soli thangaa really robha help full aa irukuu

@RahmathnishaShajahan Месяц назад

1175 error pls help me

@goodboys1597 Месяц назад

Bro Frist comment parrunga

@sridevikannan5779 6 месяцев назад

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

@surendarmurthi551 11 месяцев назад

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

@santhiyaranis8659 11 месяцев назад

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 11 месяцев назад

download the workbench and its package with the same version 8.0.3

@santhiyaranis8659 11 месяцев назад

@@janarthanalife4837 How should I download

@balaji.r7562 6 месяцев назад

Update key la 1175 error varuthu

@user-lf5xh5rr9h 11 месяцев назад

bro plss Javascript podunga...waiting la irukom

@krishnapriyar5665 10 месяцев назад

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

@kingsgowthas2932 6 месяцев назад

Spr❤bro

@RacklandStephen 4 месяца назад

enaku 1175 error varuthu bro, atha epd solve panrathu bro

@FoodWorld281 11 месяцев назад

bro please upload java script

@jawaharjawahar9614 11 месяцев назад

Javascript poduuga

@praneshsivan6288 11 месяцев назад

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.