Create An Application With Using BIN-CASE-COALESCE-CONV-DATABASE Commands On The HeidiSQL For Using Windows
HeidiSQL is a database application. We can store and manage our datas on the HeidiSQL database . We can connect our MySql database tables on the HeidiSQL application.
What Will I Learn?
- in this video we will learn how to switch between data tables and query views in HeidiSQL application.
- Also we will learn how can we write and display our queries on the HeidiSQL application in this video .
- We will learn how can we display our selected tables on the HeidiSQL Database application in this video .
- In this video we will learn what is the BIN command and how can we use BIN command on the HeidiSQL database.
- Also in this video we will learn what is the CASE command and how can we this command on the HeidiSQL database application.
- We will learn also in this video what is the COALESCE command and how can we use COALESCE command on the HeidiSQL database application.
- Also in this video we will learn what is the CONV command and how can we use this command on the HeidiSQL database application.
- We will learn also what is the DATABASE() command and how can we use this command on the HeidiSQL database application in this video.
Requirements
- For the create DataBase and Tables we need to HeidiSQL database. HeidiSQL is an open source database. We can download it free from here.
- For the connect to MySql we need to WampServer program. WampServer is an open source program. Click here for the download wampserver.
- Windows 32-64
Difficulty
- Intermediate
Description
HeidiSQL is an open source database application. Also we can stores and manages our entries on the HeidiSQL database . We can download it on the Requirements Parts.
We can connect our MySQL database's datas on the HeidiSQL database application. We should have WampServer program for the connect to MySql . We can download it on the Requirements Parts.
Also we can write our queries on the HeidiSQL database application and we can display our queries results on the HeidiSQL.
Also with HeidiSQL database application we can convert decimal number to binary number.
We can lets us evaluate conditions and return a value when the first condition we have on the HeidiSQL database application.
Also we can take the first not null value in the a specified list on the HeidiSQL database application.
We can convert a number from one number base to another number base on the HeidiSQL database application.
Also we can find our default database name on the HeidiSQL database application.
Command I Used
BIN I used this command for the convert binary base our number
CASE I used this command for the take value when the first condition met
COALESCE I used this command for the take the first not null value
CONV I used this command for the conver a number from number base to another number base
DATABASE() I used this command for the find our database
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)
- MID-LENGTH-ROUND-NOW Commands Application On The HeidiSQL (ENG)
- Create And Define Constraints On The HeidiSQL (ENG)
- CONCAT-CONCAT_WS-ASCII-FIELD-FIND_IN_SET Command's Application On The HeidiSQL(ENG)
- INSTR-LEFT-RIGHT-LPAD-RPAD Commands's Application On The HeidiSQL(ENG)
- REPEAT-LOCATE-REPLACE-REVERSE Commands' s Application On The HeidiSQL(ENG)
- LTRIM-RTRIM-TRIM-POSITION Commands Application On The HeidiSQL(ENG)
- Create An Application With Using Mathematical Commands On The HeidiSQL(ENG)
Posted on Utopian.io - Rewarding Open Source Contributors