What kind of tutorials are you interested in?
tutorial language
English German Turkish
tutorial type
all
video
html
tutorials per page
10
15
25
sort tutorials
date
click
rating
MySQL » 24.05.2007 » by biohazard
0faves
.. 0.0 / 10 .. (0 votes)
This lesson will teach you how to use the aggregate function AVG().
607 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)
MySQL » 24.05.2007 » by biohazard
0faves
.. 0.0 / 10 .. (0 votes)
This lesson will teach you how to use the aggregate function SUM().
587 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)
MySQL » 24.05.2007 » by biohazard
0faves
.. 0.0 / 10 .. (0 votes)
This lesson will teach you how to use the aggregate function COUNT().
627 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)
MySQL » 24.05.2007 » by biohazard
0faves
.. 0.0 / 10 .. (0 votes)
After you have mastered the basics of MySQL, it's time to take the next step and take on Aggregate Functions.
716 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)
MySQL » 24.05.2007 » by biohazard
0faves
.. 0.0 / 10 .. (0 votes)
Imagine that you have a MySQL table that holds the information of all the employees in your company. One of the columns in this table is called "seniority" and it holds an integer value of how many months an employee has worked at your company. Your job is to update these numbers every month.
750 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)
MySQL » 24.05.2007 » by biohazard
0faves
.. 8.0 / 10 .. (1 vote)
This lesson will teach you how to do a specialized join: left join.
881 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)
MySQL » 24.05.2007 » by biohazard
0faves
.. 5.0 / 10 .. (1 vote)
Thus far we have only been getting data from one table at a time. This is fine for simple takes, but in most real world MySQL usage you will often need to get data from multiple tables in a single query.
892 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)
MySQL » 24.05.2007 » by biohazard
0faves
.. 0.0 / 10 .. (0 votes)
It would be nice to be able to make MySQL results easier to read and understand. A common way to do this in the real world is to order a big list of items by name or amount. The way to order your result in MySQL is to use the ORDER BY statement.
611 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)
MySQL » 24.05.2007 » by biohazard
0faves
.. 0.0 / 10 .. (0 votes)
In a previous lesson we did a SELECT query to get all the data from our "example" table. If we wanted to select only certain entries of our table, then we would use the WHERE keyword.
574 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)
MySQL » 24.05.2007 » by biohazard
0faves
.. 0.0 / 10 .. (0 votes)
You have seen two types of MySQL queries thus far: the query which we used to create a table and the query we used to insert data into our newly created table.
647 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)