Create An Application With Using BIN-CASE-COALESCE-CONV-DATABASE Commands On The HeidiSQL For Using Windows

in utopian-io •  7 years ago  (edited)

Create An Application With Using BIN-CASE-COALESCE-CONV-DATABASE Commands On The HeidiSQL For Using Windows

HeidiSQL is a database application. We can store and manage our datas on the HeidiSQL database . We can connect our MySql database tables on the HeidiSQL application.

What Will I Learn?

  • in this video we will learn how to switch between data tables and query views in HeidiSQL application.
  • Also we will learn how can we write and display our queries on the HeidiSQL application in this video .
  • We will learn how can we display our selected tables on the HeidiSQL Database application in this video .
  • In this video we will learn what is the BIN command and how can we use BIN command on the HeidiSQL database.
  • Also in this video we will learn what is the CASE command and how can we this command on the HeidiSQL database application.
  • We will learn also in this video what is the COALESCE command and how can we use COALESCE command on the HeidiSQL database application.
  • Also in this video we will learn what is the CONV command and how can we use this command on the HeidiSQL database application.
  • We will learn also what is the DATABASE() command and how can we use this command on the HeidiSQL database application in this video.

Requirements

  • For the create DataBase and Tables we need to HeidiSQL database. HeidiSQL is an open source database. We can download it free from here.
  • For the connect to MySql we need to WampServer program. 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. Also we can stores and manages our entries on the HeidiSQL database . We can download it on the Requirements Parts.

We can connect our MySQL database's datas on the HeidiSQL database application. We should have WampServer program for the connect to MySql . We can download it on the Requirements Parts.

Also we can write our queries on the HeidiSQL database application and we can display our queries results on the HeidiSQL.

Also with HeidiSQL database application we can convert decimal number to binary number.

We can lets us evaluate conditions and return a value when the first condition we have on the HeidiSQL database application.

Also we can take the first not null value in the a specified list on the HeidiSQL database application.

We can convert a number from one number base to another number base on the HeidiSQL database application.

Also we can find our default database name on the HeidiSQL database application.

Command I Used

BIN I used this command for the convert binary base our number

CASE I used this command for the take value when the first condition met

COALESCE I used this command for the take the first not null value

CONV I used this command for the conver a number from number base to another number base

DATABASE() I used this command for the find our database

Video Tutorial

Curriculum

GitHub Address Of Application



Posted on Utopian.io - Rewarding Open Source Contributors

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]

I speak english fluently, but I did not understand a word from this video. Did you?

quite understandable

Thank you so much

Hey @redart, 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!

güzel bir uygulama daha teşekkürler.

Beğenmenize sevindim teşekkür ederim

@sadikemrah, Upvote for supporting you.

thank you

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