Cheat Sheet / Transcript is Here : http://goo.gl/Z1p50M Best MySQL Book : http://goo.gl/zJC254 Support Me on Patreon : https://www.patreon.com/derekbanas …
Original source
Cheat Sheet / Transcript is Here : http://goo.gl/Z1p50M Best MySQL Book : http://goo.gl/zJC254 Support Me on Patreon : https://www.patreon.com/derekbanas …
Original source
28 responses to “MySQL Tutorial”
trigger, view, procedure storage, function.
Derek Banas you are the best! Thank you so much
Thanks bro after watching your video SQL seems to be a piece of cake 😀
Thanks Derek for the quick lesson.
Thank you very much, this was very helpful.
hmm no triggers?
I need help. My sql workbench looks totally different from his and I don't know where to start. There's no server administration thing on the homepage.
It's 3am, and the first day of my first real job starts at 8am. I was told to review SQL and familiarize myself with Perl, so I sat down with my computer and watched both of your tutorials. I just finished watching them back to back. I'll find out if your tutorials are any good very soon haha, no they definitely are. I feel very prepared and I sincerely thank you for that. Fingers crossed that they only ask about what you covered! Thanks again and keep up the great work.
I have a table call member and which has FName,DOB columns. I was able to get age from the DOB Now need to get AgeRange field based on following range(0-18,19-30,30-99) for my C# project. How do I achieve this in SQL
"SELECT FName,DOB, TIMESTAMPDIFF(YEAR,DOB,CURDATE()) AS Age,Mobile FROM members"
Please help me .
Yes, I did watch the whole video. THank you, it was one of the better vid's that I have seen. It gave me a good way to get a new data base started. Now, I need to find out how to join on the back end of a web site..
You didn't set any foreign key in any example before referencing joins.
How come at 12.46 you set the Primary Key to NULL, yet when you created it earlier you set it to NOT NULL, does that not generate an error?
Time stamps would be highly appreciated @Derek Banas. This video is my go to from time to time.
Thank you
Thank you for the information packed video.
I hate passwords.
how did u clear screen in sql terminal?
It's late evening and the 4th time watching, pausing and typing data and I can tell that so far command line is much easier than workbench for simple things. (Linux here)… my only struggle is to comprehend the Primary key Foreign Key relation but will work on that… Thank you, Derek!
PS: My pet hates – misspelling when inserting data but long live up-arrow key! 🙂
say i make a typo in the command line in windows, how do you make changes? i am under the impression that it's not possible. is typing in notepad prior common practice?
Watched it all in one go and learned a lot, fast. Very well put together. Excellent video.
for those who want to follow this in 2017
install
mysql-workbench-gpl-5.2.47-win32.msi
Wow. Kind of funny to find a Youtuber from Yakima…Great job on the vid btw.
Great presentation
Incredibly helpful for me as someone new to MySQL! Much appreciated!
It took me a whole morning unable to run MySQL. It turned out that I forgot to remember the temporary password generated after installation. I think this is important to take note. Hope others won't make the same silly mistake as me ?.
Great video !
I think you need to correct the primary key for the score table as test_id, student_id at 36:39 .
I thought this was a great tutorial. I had to pause many times to understand and take notes but I prefer that to a slower paced video. Thank you.
I had no idea what sql was before this video, now I'm sure I got the basics and understand what it is and how it works. Thank you! this is going to get me a cool job I'm applying for 😛