Showing posts with label MYSQL. Show all posts
Showing posts with label MYSQL. Show all posts

Thursday, November 7, 2019

Aggregate funtion in mysql

AVG()

BIT_AND()

BIT_OR()

BIT_XOR()

COUNT(DISTINCT)

COUNT()

GROUP_CONCAT()

MAX()

MIN()

STD()

STDDEV_POP()

STDDEV_SAMP()

STDDEV()

SUM()

VAR_POP()

VAR_SAMP()

VARIANCE()

Set password in mysql xampp

You want to edit this file: "\xampp\phpMyAdmin\config.inc.php"

change this line:

$cfg['Servers'][$i]['password'] = 'WhateverPassword';

PHP THREE