PHP mysql select average program example

php-mysql

PHP mysql select average program example PHP MySQL code to to calculate average.   <!doctype html> <html lang=”en”> <head> <meta charset=”utf-8″> <meta name=”viewport” content=”width=device-width, initial-scale=1″> <title>Example of  avg function in php MySQL – Blog.eduguru.in</title> <meta name=”description” content=”Example of  avg function in php MySQL”> <link rel=”stylesheet” href=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css”> </head> <body> <div class=”container”> <div class=”row”> <div class=”col-md-12″> <h2>Example … Read more

MySQL AVG() function

mysql 5.7

MySQL AVG() function AVG function to calculate the average value of a set of values or an expression. The AVG() function returns the average value of a numeric column. If the function does not find a matching row, it returns NULL The DISTINCT option can also be used to return the average of the distinct values of expr. … Read more

MySQL count function

mysql 5.7

MySQL count function The COUNT() function returns the number of rows that matches a specified criteria. COUNT function to count the number rows in a table. The return type of the COUNT function is BIGINT. The COUNT function will return zero if there was no matching row found. The COUNT(*) function returns the number of rows in a … Read more

MySQL MIN() and MAX() Functions

mysql 5.7

MySQL MIN() and MAX() Functions   The MIN() function returns the smallest value of the selected column and the MAX() function returns the largest value of the selected column. MIN() Syntax SELECT MIN(column_name) FROM table_name WHERE condition; MAX() Syntax SELECT MAX(column_name) FROM table_name WHERE condition;

Pascal trangle program in c

Pascal trangle program in c Pascal Triangle is a Triangle form which, each number is the sum of immediate top row near by numbers. The Value of edge is always 1. 1 1 1 1 2 1 1 3 3 1 1 4 6 4 1 Let’s Start C program:   #include <stdio.h> int main() … Read more

MySQL UPDATE Statement

mysql 5.7

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, … WHERE condition; Be careful when updating records in a table! Notice the WHERE clause in the UPDATE statement. The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records … Read more

File compress and uncompress in linux

file compression and uncompression in linux

File compress and uncompress in linux gzip command compresses files. Each single file is compressed into a single file. The compressed file consists of a GNU zip header and deflated data. If given a file as an argument, gzip compresses the file, adds a “.gz” suffix, and deletes the original file.   gzip file Compress file to create file.gz. … Read more

Create user in linux

Linux_Fedora

Create user in linux   Use the adduser command to add a new user to your system. Be sure to replace username with the user that you want to create. adduser username Use the passwd command to update the new user’s password. Set password for a user in linux passwd username Set and confirm the … Read more

Bihar Board 10th Result 2019 | BSEB 10th Result 2019

BSEB result

Bihar Board 10th Result 2019 | BSEB 10th Result 2019 Latest: Bihar Board 10th Result 2019 will be announced in the 4th week of June 2019. Result: The Students of BSEB will be able to Find the Bihar Board 10th Result 2019 from the official website: biharboardonline.bihar.gov.in How to check Bihar Board 10th result 2019 Step 1: Visit … Read more

Create and View file in linux

Linux_Fedora

Create and View file in linux The ‘cat’ command is used to display text files. It can also be used for copying, combining and creating new text files.  Let’s see how it works. To create a new file, use the command vi filename Press a to enter into insert mode or append mode Start writing … Read more