Create an application using with Concat, Concat_ws , Field, Find_In_Set and Ascii commands on the MySQL database

in #utopian-io3 years ago (edited)

What Will I Learn?
In this video you will learn how to use The concat, concat_ws, field, find_in_set and ascii commands on tables created in the MySQL Database. With these commands, you will learn to perform faster and easier operations in the database.

Requirements
Your computer should be one of the following operating systems.
• Windows 32 - 64
• Linux
• MacOS
• The MySQL program is required to run this application.
MySQL download link: https://dev.mysql.com/downloads/mysql/

Difficulty
• Intermediate

Description
The content of this video includes the detailed use of MySQL, a database management system.
You will see a very fast and comfortable operation in the table created in the MySQL program with the commands I will show in this application.

With this application, you will see how to add description information to the information in the selected column.

With this application, you will see whether the specified character or words exists in the selected column.

With this application, you will see that the information in the column you select corresponds to ascii code.

Commands I Use
• Concat: Adds information to the row.
• Concat_ws: Adds characters to the entire line of the inserted sentence at once.
• Field: Finds characters or words in the column.
• Find_in_set: It finds information in the column.
• Ascii: Converts the information in the column to ASCII code.

Video Tutorial - English Language - 720p

Curriculum

Creating a database with MySQL, connecting to a database, creating a table (TR)

The “update” and “delete” functions in the database with MySQL (TR)

“Alter” and “drop” functions that provide structural changes to the database with MySQL (TR)

Primary key assignment to tables in the database with MySQL, primary key properties (TR)

Relationship of three tables with foreign key function in MySQL database (TR)

Create an application using with As, In , Like, Limit and Sum commands on the MySQL database (ENG)

Create an application using with Max, Min , Group by, Is null and Is not null commands on the MySQL database (ENG)

Create an application using with Mid, Length , Round, Replace, Upper and Lower commands on the MySQL database (ENG)

GitHub Address Of Application



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Thank you for the contribution. It has been approved.

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

thank you...

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

Achievements

  • 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