INSTR-LEFT-RIGHT-LPAD-RPAD Commands's Application On The HeidiSQL For Using Windows
HeidiSQL is an open source database. We can store and manage our datas on the HeidiSQL. Also we can connect our MySql database on the HeidiSQL.
What Will I Learn?
- In this video we will learn how to switch between data tables and query views in HeidiSQL application.
- We will learn how can we write and display our queries on the HeidiSQL Database in this video .
- We will learn how can we display our selected tables on the HeidiSQL Database.
- We will learn what is the INSTR command and how can we use this command on the HeidiSQL.
- Also we will learn in this video, what is the LEFT command and how can we use this command on the HeidiSQL application.
- In this video we will learn what is the RIGHT command and how can we use RIGHT command on the HeidiSQL Database application.
- Also we will learn what is the LPAD command and how can we use this command on the HeidiSQL application in this video.
- We will learn what is the RPAD command and how can we use RPAD command on the HeidiSQL database application in this video.
Requirements
- We need to HeidiSQL application for the create DataBase and Tables . HeidiSQL is an open source database. We can download it free from here.
- We need to WampServer application for the connect to MySql. 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. We can stores and manages our datas on the HeidiSQL database application. We can download it on the Requirements Parts.
We can connect 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 database application. We can display our queries results on the HeidiSQL.
We can gives the position of the our looking character in another string on the HeidiSQL.
Also we can takes characters on the our selected areas' s left part by the specified number on the HeidiSQL database application.
We can takes characters on the our selected areas' s right part by the specified number on the HeidiSQL database application.
Also we can fill our specified characters our selected areas' s left part by the our specified number on the HeidiSQL application.
We can fill our specified characters our selected areas' s right part by the our specified number on the HeidiSQL application.
Commands I Used
INSTR i used this command for the gives us the position for the looking character
LEFT i used this command for the takes characters on the our selected areas' s left part with the specified number
RIGHT i used this command for the takes characters on the our selected areas' s right part with the specified number
LPAD i used this command for the fill our specified characters on the our selected areas' s left by the specified number
RPAD i used this command for the fill our specified characters on the our selected areas' s right by the specified number
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)
Posted on Utopian.io - Rewarding Open Source Contributors