MAX-MIN-SUM-GROUP BY Commands Application On The HeidiSQL For The Using Windows
HeidiSQL is an open source application. We can stores and manage your datas onthe HeidiSQL.
What Will I Learn?
- We will learn how to switch between data table query views in HeidiSQL application in this video.
- Also we will learn how to write and display queries on HeidiSQL.
- We will learn what is the MAX commands and how can we use it on the HeidiSQL.
- In this video we will learn what is the MIN commands and how can we use it on the HeidiSQL.
- Also we will learn what is the SUM commands and how can i use SUM commands on the HeidiSQL.
- In this video we will learn what is the GROUP BY commands and how can we use this commands on the HeidiSQL.
- Also we will learn how can we create a new area for the display our areas on the query.
Requirements
- We should have to HeidiSQL application. HeidiSQL is an open source application and HeidiSQL is free. You can download it from here.
- We should have WampServer for the connect to MySql. WampServer is an open source application and WampServer is a free application. Click here for the download wampserver.
- Windows 32-64
Difficulty
- Intermediate
Description
HeidiSQL is an open source application. We can stores and manages our dataas on the HeidiSQL application. You can download it on the Requirements Parts.
We can manages and stores our MySQL datas on the HeidiSQL. For the connect we shoul have WampServer applicaiton. You can download it on the Requirements Parts.
On the HeidiSQL we can display our tables. Also We can display our areas in the tables which table i choose.
We can found maximum datas on the selected areas. We can create a new area for the display maximum datas.
Also we can found minumum datas on the selected areas. We can create a new area for the display minumum datas.
We can display areas which i want to see on our tables near the maximum and minimum datas.
We can sum our areas which areas i want . Also we can create a new area for the display under new area.
On the HeidiSQL we can make group on the areas. We can use others commands with the group commands. Also we can create a new area on the group commands.
Commands I Use
MAX for the found maximum data.
MIN for the found minumum data.
SUM for the sum area which area i want.
GROUP BY for the group areas which areas i want.
AS i use it create a new area for the display results.
Video Tutorial
Curriculum
- Create DataBase,Create Table, Stores data,Delete Table on HeidiSQL
- SELECT-ORDER BY-UPDATE-DELETE Commands on HeidiSQL
- LIMIT-LIKE-IN-BETWEEN Commands on HeidiSQL
- INNER JOIN- LEFT JOIN-RIGHT JOIN Commands on HeidiSQL
- UNION-INSERT INTO SELECT-ALTER ADD-ALTER DROP Commands on HeidiSQL
- CREATE VIEW-SELECT VIEW-DROP VIEW-INDEX Commands on HeidiSQL
- AVG-FIRST DATA-LAST DATA-COUNT-LIMIT Commands Application on HeidiSQL
Posted on Utopian.io - Rewarding Open Source Contributors