How to Update a Column in MySQLIn Feburary 2016 26,

In Feburary 2016 26,
Open MySQL monitor and log in with your username and password.
Select the database you wish to update. For example, to use the database named TARDIS, type in the following at the command prompt:use TARDIS;
Type in the SQL statement to update your column. To update the Date column of a table named 'Destination' where the Location is equal to 'Gallifrey' you can use the following SQL statement:UPDATE DestinationSET Date='2011-11-11'WHERE Location='Gallifrey';If updating more than one column, for example 'Date' and 'Time,' you can use the following statement:UPDATE DestinationSET Date='2011-11-11', Time='11:11:11'WHERE Location='Gallifrey';
Press Enter to submit the changes.
Update Columns Using phpMyAdmin
Open phpMyAdmin and log in.
Click the name of the database you wish to update columns for.
Find the table you'd like to change, and click on the 'Browse' icon next to it.
Put a check mark on all the records that need to be updated and click on the pencil icon or the 'Change' icon.
Edit the text on all the columns you wish to update and click on 'Go.'
In Feburary 2016 26,

How to Use the SUM Function in MySQLIn Feburary 2016 19,

In Feburary 2016 19,
Use the SUM aggregate function. SUM will add all of the selected columns together.
Notice how, in this example, you'll sum all of the negative balances to calculate the total amount owed to you by your customers. The result returns in a column called SUM(balance). Example:
SELECT SUM(balance) FROM customers WHERE balance
Use the AVG Function in MySQL
Use the AVG aggregate function. This aggregate is similar to SUM. However, instead of adding the columns, it adds them and then divides by the total number of columns, giving you an average of the column values.
Use AVG in much the same way SUM is used. Here, the example calculates the average amount of money owed by customers. Results return in a column called AVG(balance). Example:
SELECT AVG(balance) FROM customers WHERE balance
Use the COUNT Function in MySQL
Use the COUNT aggregate function. This function is slightly different than SUM or AVG. It returns the number of rows returned, which can be useful in a number of situations--for example, to see the number of customers who owe money.
See how this example counts the customers who owe money and returns the result in a column called COUNT(
). Example:
SELECT COUNT(
) FROM customers WHERE balance
Use the DISTINCT COUNT Function in MySQL
Use the DISTINCT COUNT aggregate function. The function can be used to return the number of distinct rows, meaning those rows with differing values. Theoretically, you might have a lot of customers with the same phone number. To get the number of households your customers live in, you can use this type of query.
Use the following example to return the number of customers with distinct phone numbers. Customers with the same phone number will not be counted. The results are returned in a column called COUNT(DISTINCT ph_number). Example:
SELECT COUNT(DISTINCT ph_number) FROM customers;
In Feburary 2016 19,

How to Configure a Router for FTPIn Feburary 2016 17,

In Feburary 2016 17,
Go to the configuration page for your router, which is often online and available via the router manufacturer's website.
Access the page for the router's port range forwarding. The link or tab for applications is usually the place to go.
Input 'FTP' in the first available box under the 'Application' column. In the row for this new application, put '21' underneath both 'Start' and 'End.'
Select 'TCP' in the drop-down box under 'Protocol' for the same row with your inputted FTP application. Under 'IP Adress,' input the address for the machine with your FTP server.
Create a second application row under the FTP row, inputting 'PSAV' in the Application box. Input the port range for your FTP server in the Start and End boxes. Input 'TCP' and the same IP address for the FTP server.
In Feburary 2016 17,