PHP mysql select average program example
PHP mysql select average program example PHP MySQL code to to calculate average. <!doctype html> <html lang=”en”> <head> <meta
Read more
mysql
MySQL AVG() function
MySQL AVG() function AVG function to calculate the average value of a set of values or an expression. The AVG() function
Read more MySQL count function
MySQL count function The COUNT() function returns the number of rows that matches a specified criteria. COUNT function to count the
Read more MySQL MIN() and MAX() Functions
MySQL MIN() and MAX() Functions The MIN() function returns the smallest value of the selected column and the MAX()
Read more MySQL UPDATE Statement
MySQL UPDATE Statement The UPDATE statement is used to modify the existing records in a table. UPDATE Syntax: UPDATE tablename SET col1 = val1, col2 = value2, …
Read more MySQL where condition
MySQL where condition WHERE Syntax SELECT column1, column2, … FROM table_name WHERE condition; Note: The WHERE clause is not only used in SELECT statement,
Read more mysql create index on table
mysql create index on table CREATE INDEX Syntax Creates an index on a table. Duplicate values are allowed: CREATE INDEX index_name
Read more mysql : create database and table
mysql : create database and table
Read more MySQL Server Logs
MySQL Server Logs MySQL Server has several logs that can help you find out what activity is taking place. By
Read more mysqld dead but subsys locked
mysqld dead but subsys locked Backup for future Safety: cp /var/lock/subsys/mysqld /root/mysqld than delete it rm /var/lock/subsys/mysqld then close all
Read more