You deserve more views brother. As always, great tutorial!
@DaveGrayTeachesCode3 жыл бұрын
Thank you!
@Karmagasm3 жыл бұрын
I was just thinking about MySQL the other night and now here you are with a crash course, thank you.
@DaveGrayTeachesCode3 жыл бұрын
You're welcome. I'll start integrating it with PHP and Node JS in upcoming tutorials.
@eric_ng52532 жыл бұрын
I must confess that you're the best tutor i have ever come across on this platform your tutorials have guild me through my journey of becoming a dev engineer....Thank you
@DaveGrayTeachesCode2 жыл бұрын
You're very welcome! 🙏💯
@ma-ez3zh3 жыл бұрын
For what you did around the 19:04 mark in the video, I used this command with a couple of subqueries and it worked (in case you couldn't remember Dave Grohl's emp_no or hire_date from the other table): INSERT INTO titles (emp_no, title, from_date) VALUES( (SELECT emp_no FROM employees WHERE first_name = 'Dave' AND last_name = 'Grohl'), 'Rock Star', (SELECT hire_date FROM employees WHERE first_name = 'Dave' AND last_name = 'Grohl') )
@DaveGrayTeachesCode3 жыл бұрын
Nested queries! Good job exploring options and expanding on the tutorial info.
@alfredoalejandromaidana4673 Жыл бұрын
Mr Gray you are an awesome instructor, Greetings from Buenos Aires, Argentina!
@DaveGrayTeachesCode Жыл бұрын
Thank you! And hello to Argentina! 👋
@basilistigris6403 жыл бұрын
best video on mysql crud operations i wacth, each step details explained perfect as always by Dave Gray.
@DaveGrayTeachesCode3 жыл бұрын
Thank you again, Basilis! 💯
@ahmad-murery3 жыл бұрын
Well done Dave, just a few notes from a beginner point of view (I'm not but pretending): If I am new to SQL/Databases I might not be able to follow your instruction as I wouldn't know how tables are structured (rows, columns, primary key, …), so a short intro on tables would be helpful (I think), Also, I found it not so easy for new comers to understand the JOIN clause without an illustration of the two joined tables where one can visually locate the two joined columns (with the relationship in between), the tables aliases and how we can use this relation to extract needed data from both sides of the relationship/tables. Waiting for the PHP integration video
@DaveGrayTeachesCode3 жыл бұрын
Good notes Ahmad. Students all learn differently. I always hope (and encourage) exploration on their own as well. I know there is always room for improvement though, and I appreciate your notes and perspective. My motto is "Strive for progress, not perfection". It keeps me productive! :)
@ahmad-murery3 жыл бұрын
@@DaveGrayTeachesCode I love teaching and I've taught quite a few of students/friends, my comments are mostly written based on what I've experienced with them. I had a small discussion with my brother about different education systems and how they affect the students' learning experience and we concluded that letting students do their own researches is better for them in the long run my main purpose for me to subscribe to your channel (and some others) was to know more about teaching methods and techniques. So, Thanks a lot for the clarification and sorry if you get annoyed with me
@DaveGrayTeachesCode3 жыл бұрын
Not annoyed at all Ahmad 🙂 I appreciate your notes and feedback. Thank you! Always working towards improvement 🙏💯
@cuberos7430 Жыл бұрын
You're amazing and my hero
@DaveGrayTeachesCode Жыл бұрын
Thank you for the kind words!
@gilbertojunior17123 жыл бұрын
Incredible content Thanks Dave
@DaveGrayTeachesCode3 жыл бұрын
You're welcome!
@rangabharath42533 жыл бұрын
Awesome as always. Thanks
@DaveGrayTeachesCode3 жыл бұрын
Thanks!
@viniciusm.m.78223 жыл бұрын
:D thanks, prof. Dave! God bless!
@DaveGrayTeachesCode3 жыл бұрын
You're welcome! 💯
@ivailopetrov28272 жыл бұрын
What are your thoughts about the LAMP VS Node stack?
@DaveGrayTeachesCode2 жыл бұрын
Both are useful. LAMP has powered the web for years. I prefer Node because I like JS, but either tool can be used to create what is needed. Also, each part of the stack can be different. For example, I frequently use Node with SQL at work. 🚀
@artisticcreature Жыл бұрын
Hey brother thank you , I just had one problem with it ,when I tried to run the code its throwing me an error saying "no database selected " what could be the reason ?
@DaveGrayTeachesCode Жыл бұрын
You need to select the database that you are querying.
@abdulrahmanagboolaosho3582 Жыл бұрын
I never knew you did php
@DaveGrayTeachesCode Жыл бұрын
A little bit. Considering another short series for building a REST API with PHP and SQL.
@haroldpascua4285 Жыл бұрын
Thanks a Lot, this is very Helpful! i gave you Like and Subcribe