Create an application using with Mid, Length , Round, Replace, Upper and Lower commands on the MySQL database
What Will I Learn?
In this video you will learn how to use The mid, length, round, replace, upper and lower 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 find out how many characters of the information in the column you selected.
With this application, you will see the numbers in the column As Integer. You will see the captions in the column you selected in uppercase or lowercase letters.
Commands I Use
• Mid: Indicates the range specified in the column.
• Lenhth: Indicates the number of characters in the column.
• Round: Round the fractional numbers in the selected column to the whole number.
• Replace: Allows you to change the information in the selected column.
• Upper: Writes the information in the selected column with capital letters.
• Lower: The information in the selected column writes with small letters.
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)
Posted on Utopian.io - Rewarding Open Source Contributors
@omur61, I like your contribution to open source project, so I upvote to support you.
Güzel çalışma teşekkürler
beğenmenize sevindim
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
thank you so much..
Congratulations @omur61! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Award for the number of upvotes
Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOP
Hey @omur61 I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
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