i think sql is not really changed over the years, i'm new to mysql btw. just an assumption. so it can help no matter what year it is as long as it is not changing. sorry for my bed england
Omg I finally get this now thank you, I should mention you in my graduation speech. If I ever complete Computer Science it will be solely because of you.
Bucky I don't know how should I thank you. You put real efforts into making these videos as understandable as they are for us. Your tutorials have helped me learn Mysql within only a couple of days. I just wish a long healthy life for you. God bless you & thank you!
You are a life saver. I was doing the tutorial from W3Schools and I was completely in the dark when I got to the Joins section, I didn't understand how to do it. Your tutorial made it VERY easy to understand. Thanks a bunch, I've liked and subscribed and I'll be sure to follow your tutorial from now on.
dude, thenewboston, you saved my butt this semester. Thanks for your help on java and mySQL. I can't find any good information on these programs. It seems like everyone is keeping the actual code a secret. Thanks man
you are the man. i've been knocking myself out for 24 straight hours trying to figure out my query and you nailed it in 8 minutes! i am in ore of you lol
Thank you very much for this video, I am an intern for a computer games company and the only task I got is to program a database for the products that the company sells. I have been trying to understand joins for 3 month now and now I finally made it thanks to this tutorial.
I enjoy your database tutorials. I was so confused prior to watching them. Thank you so much! My problem is finding all that relate to queries (of yours) all in one place. Any suggestions?
Hey Bucky ! You goes so productive ! :O I discovered this new series perhaps yesterday and it was like tut number 7 and now you're already number 22 ! xD Anyway let's see that.
Hee hee, that is ... unusual ... to say the least. And this example is for selling pretend things on Ebay. So who does he think is going to buy a used diaper?
Excellent tutorials. I just wanted to know how to join tables but now I want to watch all of your videos. Just one little advice: you should change your profile picture to a more professional one. These are formal videos so the people who's looking for them will choose the person who looks more professional and acknowledged. Anyway, keep it up! :)
this is one of the best helpfull course that i was looking for in database relationship using phpmyadmin sir .. my greetings from africa specially djibouti
hiya, this makes a lot of sense, even for a beginner like me. Please could you tell me which software you are using to write your queries, and if this could be done for excel table joining, thanks.
What happens when the WHERE statement specifies two columns that have completely different information/does not match? Depending on the column I choose, I can get some output (instead of empty set) and trying to figure out why that is since the columns have different information.
Great tutorial! Thank you for making a posting. I am still getting my head around joins and their purpose so please excuse a beginner's question: is the general purpose of a join to retrieve with a single query what might take 2 or more queries? Thanks again. Peace.
I suppose you mean "items.seller_id". You definitely could do "items.seller_id" to explicitly specify in which table the 'seller_id' can be found but in this case there is no 'seller_id' in the 'customers' table so there is no ambiguity for the DBMS. He uses 'customers.id' because both the 'customers' and the 'items' table contain a column with the name 'id'. Hope this clarifies!
+Philip Song yes, he didn't do items.seller_id since it was the only "seller_id" in all of the tables, so it couldn't be jammed up as it would be if he hadn't specified the table for "name" or "id"
how about if I wat an specific id? how do you write it? for example, I wat to know all the items for customer id 13, how i idicate to select this specific ID o the WHERE command?
SELECT customers.id, customers.name, items.name, items.cost FROM store.customers, store.items WHERE customers.id=seller_id and customers.id = 13 ORDER BY customers.id
u can even save dis table using CREATE TABLE table_name as SELECT .....n d whole query ma question is how can u update dis join table because when i enter new values its not refelctd in ma join table..can u help me out in dis??
cool.. its been awhile since i watched your tutorials, ...anyways, this might be off topic but what do you guy think about the: Internet Blacklist Legislation>SOPA and PIPA? I came across this issue when I was looking for something at Wikipedia
SELECT column_name FROM tbl_name WHERE condition / condition with values. (values inside the the quotation marks) Eg. SELECT name FROM customers WHERE id = '1'; Sorry for my informal english. Not my primary language. Also this is just one of the possible solutions that can work, there may be more and much effective.
I have a question.. isn't it better to use the INNER JOIN & ON function? like this: SELECT c.id, c.name, i.name, i.cost FROM customers c INNER JOIN item i ON c.id = i.id ORDER BY c.id;
@adrianqx Then you wouldn't need to be joining them in the first place. Join is just for linking the same thing multiple tables - In this case, the id of the seller, which is called id in customers, and seller_id in items. Both types of id represent the same person, the seller, so the tables can be joined via this column.
4:26 Mofos must really need dem gem socks. ..also, how did they each bid (a minimum of 500 pennies) but the socks are under $3? People spending fraction pennies or somethin'? Some Scroogin' goin' on up in this 'ere :V
very nice video sir ,sir i have 2 table ,i want to joint both and view in one how can i joint this two table A) name,rollno,class,subject and table B) date ,attendance status , how to can joint this table ??? plz
8 years later, your tutorials still helps students
Not just students, admins in education too! :D
i think sql is not really changed over the years, i'm new to mysql btw. just an assumption. so it can help no matter what year it is as long as it is not changing. sorry for my bed england
not just 8, 12
@@bezelyesevenordek really, cause it looks completley different from the mysql i use
10 years later, your tuts are still helping students
It's been a long time since I watched a Buck's video for the first time, but the feeling remains the same: you're the best, man!
Omg I finally get this now thank you, I should mention you in my graduation speech. If I ever complete Computer Science it will be solely because of you.
FleurOlivia did you finish?
So did u graduate lol
dude come back and tell us!
Looks like she didn't graduate. LMAO
We will never know, seems like a dead channel lol
Bucky I don't know how should I thank you. You put real efforts into making these videos as understandable as they are for us. Your tutorials have helped me learn Mysql within only a couple of days. I just wish a long healthy life for you. God bless you & thank you!
You are a life saver. I was doing the tutorial from W3Schools and I was completely in the dark when I got to the Joins section, I didn't understand how to do it. Your tutorial made it VERY easy to understand. Thanks a bunch, I've liked and subscribed and I'll be sure to follow your tutorial from now on.
No one teaches better than him.
Ive learned Python, and now this. All of the tutorials are just the best on the internet.
Excellent tutorial. I’ve been writing queries for a month and this will really help me. Thank you.
11 years later your tuts are still helping students!
You helped me out a LOT. Your whole youtube page is great for learning some stuff before a test. Thank you ^^
Wow, you have a really good way of explaining the logic of the sql world. Thanks for the video !
This really helped me out with a custom query I needed for a site. Thank you for posting!
This guys knowledge knows no bounds!!
So many videos out there on joins. This one is my favourite!
I've looked at a lot of MySQL videos, and this video has very good explanations. Also, its nice that you have some humor too. Thanks!
bucky, this video helped me tremendously. the way you explained it is exceptional.
dude, thenewboston, you saved my butt this semester. Thanks for your help on java and mySQL. I can't find any good information on these programs. It seems like everyone is keeping the actual code a secret. Thanks man
Awesome!I'm looking forward to your more advanced tutorials for my school work
11 years earlier, still helping students. thank you so much
Why can't production databases be this entertaining?
Hahahaha... Sooooo true..
this was super helpful! Thanks for taking your time, explaining, and then showing as you go :)
Good stuff dude, thanks for your clear and concise tutorial on this
you are the man. i've been knocking myself out for 24 straight hours trying to figure out my query and you nailed it in 8 minutes! i am in ore of you lol
Thank you very much for this video, I am an intern for a computer games company and the only task I got is to program a database for the products that the company sells. I have been trying to understand joins for 3 month now and now I finally made it thanks to this tutorial.
Great tutorial! I would also like to know if its possible to turn the results into a new table in the database display on a site using php. Thank you
I love how you explain in real life examples
Thank you so much Bucky your tutorials made it so easy to understand than those hours long lecture.
Thank so much man, longtime watcher!
I enjoy your database tutorials. I was so confused prior to watching them. Thank you so much! My problem is finding all that relate to queries (of yours) all in one place. Any suggestions?
Thank you , tutorial is very clear . I have hearing problem and I couldn't understood a single word you were speaking , but I know this now.
holy crap. Joins used to confuse the crap outta me. now I feel like a genius. thanks bucky!
Straight to the point. I love it!!
Hey Bucky ! You goes so productive ! :O
I discovered this new series perhaps yesterday and it was like tut number 7 and now you're already number 22 ! xD Anyway let's see that.
Jesus this amazing thank you very much I was really stuck
Anyone else laugh at "used diaper from my sister"?
+Vector Vent Me! I have been following his videos and this phrase has come up more than 10 times :P
Hee hee, that is ... unusual ... to say the least.
And this example is for selling pretend things on Ebay. So who does he think is going to buy a used diaper?
@Mc Ezra yu forgot manufacted BOWs
@Mc Ezra it's true medical companies make artificial virus for $$
0 bids though AHAHHAH
8 years old still saving the day
i'm new to mysql and this helped me so much! thank you!
Love this dude! Thanks Bucky! I wish you were my instructor. :-)
This is is video should be more popular. About to get that A now
Best join tutorials .Bucky is the best online teacher .i ve learned java,c++,javascript and now sql thanks to him .ty dude
This could really come in handy! Thanks :)
joins are probably the trickiest part of mysql. thanks for explaining
+Haider Ali Khichi : I agree. have you made any headway?
Thank you very much for helping us bro 🙏
Excellent tutorials. I just wanted to know how to join tables but now I want to watch all of your videos. Just one little advice: you should change your profile picture to a more professional one. These are formal videos so the people who's looking for them will choose the person who looks more professional and acknowledged. Anyway, keep it up! :)
very good explanation. very clear and easy to understand
this is one of the best helpfull course that i was looking for in database relationship using phpmyadmin sir ..
my greetings from africa specially djibouti
bucky bro now i found this is a little bit usefull tutorial thank you .
hiya, this makes a lot of sense, even for a beginner like me. Please could you tell me which software you are using to write your queries, and if this could be done for excel table joining, thanks.
This is exactly what i need thanks thenewboston!
great job bucky!! keep up the good work.
Wow!! You explained it so well 👍👍
THIS VIDEO SAVED MY LIFE
What happens when the WHERE statement specifies two columns that have completely different information/does not match? Depending on the column I choose, I can get some output (instead of empty set) and trying to figure out why that is since the columns have different information.
Great tutorial! Thank you for making a posting.
I am still getting my head around joins and their purpose so please excuse a beginner's question: is the general purpose of a join to retrieve with a single query what might take 2 or more queries? Thanks again.
Peace.
joining tables is a complicated word for using two or more tables in one command
I suppose you mean "items.seller_id". You definitely could do "items.seller_id" to explicitly specify in which table the 'seller_id' can be found but in this case there is no 'seller_id' in the 'customers' table so there is no ambiguity for the DBMS. He uses 'customers.id' because both the 'customers' and the 'items' table contain a column with the name 'id'. Hope this clarifies!
you do a great jobs on your videos. Do you have anything on Php PDO security?
I HOPE YOU ARE MY PROFESSOR
thenewboston unsung heroes
can I put AND statement after the WHERE clause to put another related tables?
Thank you sir ,Your vidio is really helped me
hi, do you have the notes for each lecture, includes the queries and explanation?/thanks
best join tutorils i ever saw
You have the best boss.
You got a new subscriber
in the query at 6:29, is it also correct to write:
WHERE customers.id = items.seller_id?
+Philip Song yes, he didn't do items.seller_id since it was the only "seller_id" in all of the tables, so it couldn't be jammed up as it would be if he hadn't specified the table for "name" or "id"
thank you wise stranger
how about if I wat an specific id? how do you write it? for example, I wat to know all the items for customer id 13, how i idicate to select this specific ID o the WHERE command?
did you ever find the answer cause i need it :P
SELECT customers.id, customers.name, items.name, items.cost
FROM store.customers, store.items
WHERE customers.id=seller_id and customers.id = 13
ORDER BY customers.id
Sir, when we are adds more than one tables using the where clause
u can even save dis table using CREATE TABLE table_name as
SELECT .....n d whole query ma question is how can u update dis join table because when i enter new values its not refelctd in ma join table..can u help me out in dis??
Great tutorial, thanks
Very well explained.
How to do delete and update query using join please tell me
ty for the video!
Can I put the joined tables together into a Permanent table?
hello....juz want to ask....how to show output Address in one box for table add1,add2,add3,poskod,state....plz help me....tq in advanced
Nice tutorial sir, thank you.
Thank you :D it works!
I never comment on videos, but THANK YOU.
One thing I dont get is that he pulled up the Customer.Name but the Seller.Name populated instead?
Would it also mork if i say customers.id = items.seller_id?
cool.. its been awhile since i watched your tutorials,
...anyways, this might be off topic but what do you guy think about the:
Internet Blacklist Legislation>SOPA and PIPA? I came across this issue when I was looking for something at Wikipedia
my question is insert data in 2 table with 1 qurey is it possible??
Why is seller ID not a foreign key of userId? Why is it named differently?
Thank you! Amazing.
How is the Seller ID matched to the User ID in the first place?
i dont understand how he linked 'seller_id' to the original customer.id as i am just getting 0?
How do you select a specific row? For example, I want to select a single user's info.
SELECT column_name FROM tbl_name WHERE condition / condition with values. (values inside the the quotation marks)
Eg.
SELECT name FROM customers WHERE id = '1';
Sorry for my informal english. Not my primary language. Also this is just one of the possible solutions that can work, there may be more and much effective.
I have a question.. isn't it better to use the INNER JOIN & ON function?
like this:
SELECT c.id, c.name, i.name, i.cost
FROM customers c INNER JOIN item i ON c.id = i.id
ORDER BY c.id;
@adrianqx Then you wouldn't need to be joining them in the first place. Join is just for linking the same thing multiple tables - In this case, the id of the seller, which is called id in customers, and seller_id in items. Both types of id represent the same person, the seller, so the tables can be joined via this column.
thanks it works
what is the difference between this method and using "JOIN" ?
keep doing this good thing
why didn't you use the left join function?
item: 'used diaper from my sister'??? LOL
4:26
Mofos must really need dem gem socks.
..also, how did they each bid (a minimum of 500 pennies) but the socks are under $3? People spending fraction pennies or somethin'?
Some Scroogin' goin' on up in this 'ere :V
what happens if 2 tables dont have any column in common ?
uhmm, do you have a tut about joining more than 2 tables?
Great work
thanks a lot
very nice video sir ,sir i have 2 table ,i want to joint both and view in one how can i joint this two
table A) name,rollno,class,subject and table B) date ,attendance status , how to can joint this table ??? plz
Fuck the boss, you're your own boss Bucky.
whahaha this is still the best tutorial ever, "used diaper from my sister"
HI Bucky, listen i get what you did.now how does one create a new table with the results on the query you executed
Thanks :)
Thank you so freakin' much!!