REPEAT-LOCATE-REPLACE-REVERSE Commands' s Application On The HeidiSQL For Using Windows
HeidiSQL is an open source application for the using windows. We can store and manage our entries on the HeidiSQL application. Also we can connect our MySql database entries 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 application.
- Also in this video We will learn how can we display our tables on the HeidiSQL Database application.
- We will learn how can we create a new area for the display our result on the HeidiSQL application.
- In this vide we will learn what is the REPEAT command and how can we use this command on the HeidiSQL.
- We will learn what is the LOCATE command and how can we use LOCATE command on the HeidiSQL database application.
- Also we will learn what is the REPLACE command and how can we use REPLACE command on the HeidiSQL application in this video.
- In this video also we will learn what is the REVERSE command and how can we use REVERSE command on the HeidiSQL database application.
Requirements
- For the create DataBase and Tables we need to HeidiSQL application. HeidiSQL is an open source database. We can download it free from here.
- For the connect to MySql database we need to WampServer application. WampServer is an open source program. Click here for the download wampserver.
- Windows 32-64
Difficulty
- Intermediate
Description
We can stores and manages our datas on the HeidiSQL database application. HeidiSQL is an open source database application.We can download it on the Requirements Parts.
We can connect our MySQL database's datas on the HeidiSQL database application. For the connect to MySql we should have WampServer application. We can download it on the Requirements Parts.
We can write our queries on the HeidiSQL database application queries part. We can display our queries results on the HeidiSQL with the create a new area.
We can repeat an area or a string by the our specified number of the time on the HeidiSQL database application.
Also we can returns the first position of our looking character on a string or an area on the HeidiSQL database application.
We can replace all character of a specified character on a string or an area on the HeidiSQL application.
Also we can reverse a string or a specified area on the HeidiSQL database application.
Commands I Used
REPEAT i used this command for the repeat a string or an area's entires
LOCATE i used this command for the take the position our looking character on a string or an area
REPLACE i used this command for the replace our specified character on a string or an area
REVERSE i used this command for the reverse a string or our selected area
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)
Posted on Utopian.io - Rewarding Open Source Contributors