Create an application using with Repeat, Locate , Reverse, and Replace 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 repeat, locate, reverse and replace commands on tables created in the MySQL Database. With these commands, you will learn to perform faster and easier operations in the database. With these commands, you will learn how to access and modify table information easily.

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.
You will see the information in the selected columns in the table to be written repeatedly. You will see the order in which the specified character is on the line. You will also see changes to the information in the table.
You will see how to type the information in the selected row in reverse.

Commands I Use
• Repeat: Repeats the selected information.
• Locate: Finds the order of the specified character.
• Reverse: The information in the selected row reverses it.
• Replace: Allows you to make changes to the information.

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)

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

Create an application using with Instr, Left , Right, Lpad and Rpad commands on the MySQL (ENG)

GitHub Address Of Application



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

#tr

Please be mindful of country-specific tags. These tags are for articles written in that countries language or about that country.

Using irrelevant tags, especially popular tags, makes it hard to find good and relevant content. Please use only relevant tags when posting!

TIP: You can edit any tag but the first!

Thank You! ⚜

I get it. I'il make the necessary corrections on the next shares.

Öğretici bir paylaşım daha emeğinize sağlık

teşekkür ederim. beğenmenize sevindim.

Your contribution cannot be approved because it does not follow the Utopian Rules.
Utopian rule

  • Video Tutorials must be technical instructions that teach non-trivial aspects of an Open Source project.

Explanation

  • The knowledge in the tutorial is ubiquitous.They can be found on the mysql document ,too.

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