IS NULL-IS NOT NULL-HAVING-UCASE-LCASE Commands Application On The HeidiSQL For The Using Windows
HeidiSQL is a database application. HeidiSQL is an open source program. We can stores and manages our datas on the HeidiSQL.
What Will I Learn?
- In this video we will learn how to switch between data table query views in HeidiSQL application.
- We will learn how to write and display queries on HeidiSQL.
- Also we will learn how can we write our queries.
- We will learn what is the IS NULL command and how can we use it on the HeidiSQL.
- Also we will learn what is th IS NOT NULL command and how can we use it on the HeidiSQL.
- We will learn what is the UCASE command and how can we use UCASE command on the HeidiSQL.
- Also we will learn what is the LCASE command and how can we use LCASE command on the HeidiSQL.
- We will learn what is the HAVING command an how can we use HAVING command on the HeidiSQL.
- We will learn how can we define a condition for the take our selected areas.
- Also we will learn how can we create a different area for the display our datas on new area.
Requirements
- We need to HeidiSQL application. HeidiSQL is an open source database and HeidiSQL is free. We can download it from here.
- We need to WampServer application for the connect to MySql. WampServer is an open source program and WampServer is a free application. Click here for the download wampserver.
- Windows 32-64
Difficulty
- Intermediate
Description
HeidiSQL is an open source database. We can stores and manages our datas on the HeidiSQL program. We can download it on the Requirements Parts.
Also we can manages and stores our MySQL datas on the HeidiSQL. We shoul have WampServer applicaiton for the connect MySql. We can download it on the Requirements Parts.
We can display our tables on the HeidiSQL . Also We can display our areas in the tables which table i choose.
We can create a new area for the display selected areas.
Also we can change our datas words to upper case on the HeidiSQL. And we can display them with different area.
We can change our datas words to lower case on the HeidiSQL. And we can display them with different area.
We can take our empty areas on the HeidiSQL which area i want. I can display another areas with our empty areas.
Also we can take our not empty areas on the HeidiSQL which area i want. I can display another areas with our not empty areas.
I can take some areas which area has got our determined condition.
Commands I Use
IS NULL i used this command for the take our empty datas in the selected area.
IS NOT NULL i used this command for the take not empty datas in the selected area.
UCASE i used this command for the change upper case which area's data i want.
LCASE i used this command for the change lower case which area's data i want.
HAVING i used this command for the take datas which datas have got our determine condition.
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)
Posted on Utopian.io - Rewarding Open Source Contributors