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().
616 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().
597 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().
637 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.
730 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.
765 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.
902 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.
915 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.
626 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.
586 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.
656 views ... goToHome ... reportThis ... shareThis ... addToFaves ... comments(0)