SQL - lekcija 7

DROP TABLE `testtable`;

CREATE TABLE `testtable`

(

`id` INT(42) NOT NULL AUTO_INCREMENT,

`user` TEXT,

`pass` VARCHAR(10) NOT NULL,

`age` INT(3) DEFAULT 5,

PRIMARY KEY(`id`)

);

DESCRIBE `testtable`;

#SHOW INDEXES FROM `testtable`;

_________________________________________

SELECT AVG(column_name) FROM table_name; - vidējo kolonna vērtību;

SELECT AVG(column_name) AS xxx FROM table_name; - vidējo kolonna vērtību;

SELECT AVG(column_name) as `average` FROM table_name;