MySQL Tutorials For Beginners

MySQL Tutorials For Beginners List

If you’re a beginner, or even more advanced, this MySQL Tutorials For Beginners will be a good resource for you. In learning web development, you’re going to need to know some amount of SQL or MySQL at some point. The whole point of building dynamic websites is to be able to tie into a database to store and retrieve information. Just like when learning about how to use PHP Frameworks, one must have some amount of knowledge about OOP, or object oriented programming.…

What is a MySQL Join?

introduction to mysql

Now that we have covered all of the basics in MySQL, we’ll finish things up with a few additional points about MySQL that you are likely to come across. One of these topics is the idea of a join. So what is a join? When we do a join in MySQL, what we are doing is in essence, joining two tables together so that you can select data from both tables.…

MySQL Group By Having Limit Offset and More!

MySQL Group By Having Limit Offset

We’re moving onward in our MySQL Journey! This episode will take a look at many useful features of the language and how you can use them. As always, we’ll simply be operating on the data that we already have in the friends table we’ve been working with so far. We’ll cover features like group by and aggregate functions. They typically go together, much like peanut butter and jelly.…

What are MySQL Operators?

MySQL Operators

MySQL Operators are your friend in fact. In MySQL, just as in all programming languages, we have these nifty little things called operators. Operators are pretty darn important, as they allow us to perform meaningful operations on our data. Some of the MySQL operators include LIKE, LIKE%…%, NOT LIKE, =, !=, REGEXP, REGEXP^…$, NOT REGEXP, =”, !=”, IN(…), NOT IN(…), BETWEEN, NOT BETWEEN, IS NULL, and IS NOT NULL.…

Working With Common MySQL String Functions

MySQL String Functions

MySQL has many built in functions for dealing with strings. Many times, we can perform these operations using whatever programming language we happen to be using with MySQL such as PHP. Other times however, it is really helpful to be able to manipulate strings right in our MySQL statements. In this episode we’ll take a look at working with strings and doing things like setting them to all upper or lowercase, reversing their order, replacing characters with other characters, gluing strings together with concatenation, and much more.…