CONCAT-CONCAT_WS-ASCII-FIELD-FIND_IN_SET Command's Application On The HeidiSQL Using For Windows
HeidiSQL is an open source application for the store and manage our datas. We can create queries on the HeidiSQL. Also we can connect our MySql database on the HeidiSQL.
What Will I Learn?
- We will learn how to switch between data tables and query views in HeidiSQL application in this video .
- In this video we will learn how can we write and display our queries on the HeidiSQL Database.
- We will learn what is the CONCAT command and how can we use this command on the HeidiSQL.
- Also we will learn what is the CONCAT_WS command and how can we use CONCAT_WS command on the HeidiSQL.
- In this video we will learn what is the ASCII command and how can we use ASCII command on the HeidiSQL.
- We will learn what is the FIELD command and how can we use this command on the HeidiSQL.
- Also we will learn what is the FIND_IN_SET command and how can we use FIND_IN_SET command on the HeidiSQL.
- We will learn how can we display our queries result on the HeidiSQL.
Requirements
- For the create DataBase and Tables we need to HeidiSQL application . HeidiSQL is an open source database. We can download it from here.
- For the connect to MySql we need to WampServer application . WampServer is an open source program. Click here for the download wampserver.
- Windows 32-64
Difficulty
- Intermediate
Description
HeidiSQL is an open source application. We can stores and manages our datas on the HeidiSQL program. We can download it on the Requirements Parts.
We can manages and stores our MySQL database's datas on the HeidiSQL. We should have WampServer program for the connect to MySql . We can download it on the Requirements Parts.
We can write our queries on the HeidiSQL application. We can display our queries results on the HeidiSQL.
Also we can combine our selected words on the HeidiSQL database and we can display our combine on the query part.
We can get a char between our selected word when we make a concanete on our selected words.
Also we can return ascii codes of the first character on our areas which area we select.
We can turn the position of the selected character on our list. It will turn which character' s position do will know.
Also we search number of looking char on our defined string list on the HeidiSQL.
Command I Use
CONCAT i used this command for the combine our selected words.
CONCAT_WS i used this command for the get a char between our selected words.
ASCII i used this command for the take ascii codes on the first character on our selected areas.
FIELD i used this command for the turn the position of the selected value.
FIND_IN_SET i used this command for the take the number of looking char on our string list.
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)
Posted on Utopian.io - Rewarding Open Source Contributors