MID-LENGTH-ROUND-NOW Commands Application On The HeidiSQL For The Using Windows
HeidiSQL is an open source application. HeidiSQL is a database application. We can stores and manages our datas on the HeidiSQL. Also we can manage our entrieson this application.
What Will I Learn?
- We will learn how to switch between data tables and query views in HeidiSQL application in this video.
- Also we will learn how can we write and display our queries on the HeidiSQL.
- In this video we will learn how can we create a different area for the display our datas on new created area on the HeidiSQL.
- We will learn what is the MID command and how can we use MID command on the HeidiSQL database.
- Also we will learn what is the LENGTH command and how can we use this command on the HeidiSQL in this video.
- We will learn how can we use ROUND command and what is the ROUND command.
- Also we will learn what is the NOW command and how can we use NOW command on the HeidiSQL.
- We will learn what is the NOW command's parameters and how can we use this parameters on the HeidiSQL in this video.
Requirements
- For the create DataBase and Tables we need to HeidiSQL program. HeidiSQL is an open source database and this programram is free. We can download it from here.
- For the connect to MySql we need to WampServer application. WampServer is an open source program and WampServer is a free program. Click here for the download wampserver.
- Windows 32-64
Difficulty
- Intermediate
Description
HeidiSQL is an open source database application. We can stores and manages our entries on the HeidiSQL application. We can download it on the Requirements Parts.
Also we can manages and stores our MySQL database's entries on the HeidiSQL. We should have WampServer program for the connect to MySql. We can download it on the Requirements Parts.
We can display our tables on the HeidiSQL with the write related commands on the HeidiSQL query.
We can display our selected entries up to the desired length, starting with the desired character.
Also we can bring to length of the area which area' s length i want to see on the HeidiSQL Database's table.
We can round our decimal number entries to the nearest integer number.
Also we can take our system time on the HeidiSQL queries. We can use time parameters on the HeidiSQL.
We can use DAY-MONTH-YEAR time's parameters on the HeidiSQL database.
Cammonds I Use
MID i used this command for the display selected entries up to the desired length, starting with the desired characters.
LENGTH i used this command for the bring the length of the selected area
ROUND i used this command for the round decimal number to the nearest integer number
NOW() i used this command for the geting system time
DAY(NOW()) i used this command for the geting system day number
MONTH(NOW()) i used this command for the geting system month number
YEAR(NOW()) i used this command for the geting system year
Video Tutorial
Curriculum
- Create DataBase,Create Table, Stores data,Delete Table on HeidiSQL(TR)
- SELECT-ORDER BY-UPDATE-DELETE Commands on HeidiSQL(TR)
- LIMIT-LIKE-IN-BETWEEN Commands on HeidiSQL(TR)
- INNER JOIN- LEFT JOIN-RIGHT JOIN Commands on HeidiSQL(TR)
- UNION-INSERT INTO SELECT-ALTER ADD-ALTER DROP Commands on HeidiSQL(TR)
- CREATE VIEW-SELECT VIEW-DROP VIEW-INDEX Commands on HeidiSQL(TR)
- AVG-FIRST DATA-LAST DATA-COUNT-LIMIT Commands Application on HeidiSQL(ENG)
- MAX-MIN-SUM-GROUP BY Commands Application On The HeidiSQL (ENG)
- IS NULL-IS NOT NULL-HAVING-UCASE-LCASE Commands Application On The HeidiSQL(ENG)
Posted on Utopian.io - Rewarding Open Source Contributors