Create an application using with As, In , Like, Limit and Sum commands on the MySQL database
What Will I Learn?
In this video you will learn how to use The as, in, like, limit and sum commands on tables created in the MySQL Database. With these commands, you will learn to use the information in the database more efficiently.
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.
With this application, you will see how frequently used commands are used in the database created in the MySQL program and what they do.
With this application, you will see a change in the name of the column in the table.
With this application you will see all the information of the person whose name you have mentioned. You will see the collection of numeric values in the column that you want in the table. You will see as many rows of information as you want in the table. So you'il see limitations.
Commands I Use
• As: Make changes to column name.
• İn: Returns the information specified in the column.
• Like: Returns all information that begins with the specified letter.
• Limit: Returns up to the desired number of rows of information from the table.
• Sum: Allows you to sum the numbers in the specified range.
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)
Posted on Utopian.io - Rewarding Open Source Contributors