MySQL Tutorial for Beginners - 5 - Deleting Data From a Database

  Рет қаралды 217,079

CodePotion

CodePotion

Күн бұрын

Пікірлер: 62
@AlexA36717
@AlexA36717 2 жыл бұрын
11 years later and you still the goat
@yoll6329
@yoll6329 2 жыл бұрын
Still useful 10 years later may God bless you Thanks
@mirzamohammedbaig6766
@mirzamohammedbaig6766 10 жыл бұрын
hello thnxx very muchfor this explanation i am currently living in riyadh and in my school teacher dosent explain much or not convinent for us but u have explained in such a way that i understand it eaisly and scored good marks god bless you
@aeversor
@aeversor 12 жыл бұрын
thanks for the videos it was EXTREMELY helpful! i like the approach you take by taking things slowly, explaining evertyhing in detail and going through the process step by step. This way, beginners like myself are really able to understand how to do basic commands. great job! i think you could do even better by explaining the installation process. personally, i was lost trying to figure out which SQL installer i needed. i got that sorted out though! :)
@mathan.g5739
@mathan.g5739 6 жыл бұрын
Thanks for your MySQL database example of all statement explained very well
@benedictosalas1116
@benedictosalas1116 13 жыл бұрын
thank you for uploading this video.. it help us a lot, because we are constructing a java system with mysql, and it was a case study... thank u... and god bless you...
@sivaram6124
@sivaram6124 12 жыл бұрын
these videos are so helped to me friend. the way you explain is very nice, even a novice can understand what mysql is. please post remaining videos also
@tomchurch1
@tomchurch1 10 жыл бұрын
Thank you for making these tutorials. You really helped me learn how to code.
@isuriperera8207
@isuriperera8207 10 жыл бұрын
Thanx! very helpful,but make sure to increase the volume...
@XTIANL0RD
@XTIANL0RD 11 жыл бұрын
He just meant that as an example. However, you can use that column to keep some user hidden to all your users. For example if you are going to use this table to create a list of all user for management, standard user will have access to user with variable visible=1 and administrators will have access to users with variable visible 1 and 0.
@wangtenghong
@wangtenghong 11 жыл бұрын
Thanks for the uploader & video producer, it is very helpful to me
@LearnWithSiddhiKrishnamrut
@LearnWithSiddhiKrishnamrut 13 жыл бұрын
Thanks for your cool videos, It would be nice if you can upload some video about connecting PHP and MySQL togehter in any server like Apache ... Thanks in advance
@kangemanmaipmokiuah226
@kangemanmaipmokiuah226 9 жыл бұрын
you quite innocent Indian guy i believe that... coze you helpme allot..
@shubhamkawade317
@shubhamkawade317 6 жыл бұрын
Tum bhot mast kaam krta hai primetuber bhai
@loveybareja7378
@loveybareja7378 5 жыл бұрын
please upload some videos on Pl/SQL concepts like functions, procedures, packages and triggers
@sidmezio
@sidmezio 9 жыл бұрын
Thank you very much, you helped a lot with this tutorial. It is truly inspiring. :) Keep up the good work. I just subscribed! You also have my like sir!
@juarisepah7628
@juarisepah7628 4 жыл бұрын
simple and well broken down
@suchanderreddy
@suchanderreddy 12 жыл бұрын
reaaly good for beginners like me.nice videos my frnd. pls upload videos relating to working on mysql workbench.
@hewan681
@hewan681 4 жыл бұрын
I hope God gives you happiness, health and wealth! I mean it.
@toptek8796
@toptek8796 3 жыл бұрын
Useful, thanks
@frozenman0207
@frozenman0207 11 жыл бұрын
You should increase the volume of your voice. Helpful stuff though
@spyrex3988
@spyrex3988 4 жыл бұрын
epic tutorials thanks
@0443090333
@0443090333 13 жыл бұрын
Hi there, thanks for uploading such informative videos. They are really useful for beginners. What i didn't get there is if we delete any rows then the id does not auto increment itself. i.e when you delete the first row then everything in the first row get deleted. That's OK but why doesn't that second row id(2) get changed to 1 after deletion the first row. How can i make it working? Hope, you will reply. Bye
@anoopck1
@anoopck1 12 жыл бұрын
so simple, thank you very much... "" It would be nice if you can upload some video about connecting PHP and MySQL togehter in any server like Apache ...""
@roro506666
@roro506666 10 жыл бұрын
thanks alot its make me so happy this video
@pradeepvarma3579
@pradeepvarma3579 12 жыл бұрын
Hi primetuber....all ur videos are very clear...I have a small question for u, in this 5th one...Please tell me how to update the id number after deleting few rows?...After u deleted 1,3 and 5....the serial no (id no's) looks unordered...so how to keep them in order by keeping the data unchanged.....Thanks a lot :-)
@pavanaditya591
@pavanaditya591 8 жыл бұрын
select*from table name ORDER BY column name;
@prabhatkumarram8541
@prabhatkumarram8541 3 жыл бұрын
Thank you....❤️❤️
@midhlajali2797
@midhlajali2797 4 жыл бұрын
pls help bro, i have a doubt. how to update the length of the datatype. like for example- varchar(10) to varchar(20);
@sumanakm1157
@sumanakm1157 2 жыл бұрын
very helpfull
@bhoomikak7634
@bhoomikak7634 8 жыл бұрын
the videos are extremely helpful... but i have a doubt... if i want to delete a particular row and by mistake many rows gets deleted due to a wrong statement, then can we undo the statement? if yes how .....?
@dennisasamoah2213
@dennisasamoah2213 5 жыл бұрын
great vid
@joyjeetroy9616
@joyjeetroy9616 4 жыл бұрын
bro can't u increase the sound for this otherwise everything is amazing . thanks for the explanation
@nehapaliwal2221
@nehapaliwal2221 7 жыл бұрын
Sir I have added a new column and I wants to add the values in that particular column I am using insert command it is working bt it creates new row and I wants to insert value in existing row for that particular added column plz tell me how can I insert the value
@pavanaditya591
@pavanaditya591 8 жыл бұрын
how to delete same rows in a table. that is deleting a row which is a copy of original having the original undisturbed? could you type the query?
@mohdarish6688
@mohdarish6688 5 жыл бұрын
Make video on function and view
@varunmachupally3234
@varunmachupally3234 4 жыл бұрын
How to add a column in the table?
@krishnpalsinghchouhankp
@krishnpalsinghchouhankp 11 жыл бұрын
gud v gud,,'
@dhaneshisl
@dhaneshisl 12 жыл бұрын
thanxx, ilike the video....
@omkarkadam4733
@omkarkadam4733 7 жыл бұрын
Why "where 1" is used in query"select distinct ......."
@_thambi_
@_thambi_ 2 жыл бұрын
Watching in 💛💛2022
@Hindustan029
@Hindustan029 11 жыл бұрын
jabardast..bus kal sql ka lab exam pass ho gaye to tumhe 1 kg motichoor ke ladoo...:)..Tum pehle kyu nahi mile yaar..:)
@mughalles
@mughalles 13 жыл бұрын
Thanks very much
@Sridhar0303
@Sridhar0303 12 жыл бұрын
Hi May I know what is the purpose of that visible column please.. why it is used for is there any specific reason for that column.
@pavanaditya591
@pavanaditya591 8 жыл бұрын
it is just a column name you can even have unvisible as a column name.
@saikiranrao194
@saikiranrao194 3 жыл бұрын
Thanks broo
@nehapaliwal2221
@nehapaliwal2221 7 жыл бұрын
And sir plz tell me the difference between delete and drop command
@amitrawat8280
@amitrawat8280 7 жыл бұрын
Neha Paliwal we use drop for database and column. delete for row.
@terminalsocket3677
@terminalsocket3677 3 жыл бұрын
Thanks.
@Abenyazid
@Abenyazid 12 жыл бұрын
is this shit stops at chapter 5? cuz the guys was good and all i need more plz PM if there's a thread so i can find more of this beginners stuff
@ismailshaik522
@ismailshaik522 5 жыл бұрын
Tq bhayya
@arthere09
@arthere09 2 жыл бұрын
Thankyou
@ashrafsiddiky4041
@ashrafsiddiky4041 6 жыл бұрын
How to edit a batabases,,,,এই টা কি আছে,,,,,?
@thelonewolf7780
@thelonewolf7780 7 жыл бұрын
thank you
@rakshabhadoriya1836
@rakshabhadoriya1836 5 жыл бұрын
Order by id kyu likha hai
@bhargavisegu4347
@bhargavisegu4347 4 жыл бұрын
Could u please speak up while recording
@prernarawat4322
@prernarawat4322 5 жыл бұрын
BHAI AWAZ TO TERI AA NHI RAHI H BILKUL BHI VIDEO M
@jonkim1466
@jonkim1466 6 жыл бұрын
anyone feel sad when primetuber database is gone?=(
@manojkashyap789
@manojkashyap789 6 жыл бұрын
this tutorial voice sound so week..
@primeronaldo2307
@primeronaldo2307 2 жыл бұрын
Bro its 10 year back video
@MegaTigerUppercut
@MegaTigerUppercut 12 жыл бұрын
Since you can't be bothered to level your mic volume properly I'm skipping this since it's barely audible.
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 62 МЛН
黑天使只对C罗有感觉#short #angel #clown
00:39
Super Beauty team
Рет қаралды 36 МЛН
So Cute 🥰 who is better?
00:15
dednahype
Рет қаралды 19 МЛН
BAYGUYSTAN | 1 СЕРИЯ | bayGUYS
36:55
bayGUYS
Рет қаралды 1,9 МЛН
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Anton Putra
Рет қаралды 233 М.
I loaded 100,000,000 rows into MySQL (fast)
18:27
PlanetScale
Рет қаралды 181 М.
Learn SQL In 60 Minutes
56:24
Web Dev Simplified
Рет қаралды 2,2 МЛН
MySQL Syntax in 20 Minutes | Understanding the Main Components of SQL
19:53
SQL Tutorial for Beginners
44:57
Kevin Stratvert
Рет қаралды 2,3 МЛН
MySQL - The Basics // Learn SQL in 23 Easy Steps
17:17
Fireship
Рет қаралды 946 М.
Learn SQL Basics in Just 15 Minutes!
16:57
Kenji Explains
Рет қаралды 191 М.
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,6 МЛН
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 62 МЛН