IS NULL-IS NOT NULL-HAVING-UCASE-LCASE Commands Application On The HeidiSQL For The Using Windows

in utopian-io •  7 years ago  (edited)

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

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Thank you for the contribution. It has been approved.

You can contact us on Discord.
[utopian-moderator]

Thank you so much

Hey @fuzeh, I just gave you a tip for your hard work on moderation. Upvote this comment to support the utopian moderators and increase your future rewards!

Hey @sadikemrah I am @utopian-io. I have just upvoted you!

Achievements

  • You have less than 500 followers. Just gave you a gift to help you succeed!
  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x