Mysql is an Open Source Relational Database which supports SQL queries. How data will be stored is decided by Mysql Engine. Mysql provides full flexibility while choosing Mysql engines. In Mysql, there are two most popular engines called MyISAM and INNODB. If we do not want transactional properties and we do not want to use row-level locking, then we can use MyISAM. Data Insertion is faster in INNODB.
There are many reasons why we need to learn MySQL; some of the important ones are given below:
Web applications mostly use MySQL. Because it is open-source and many cloud-based servers like AWS charge much less to deploy MySQL on their server. Many small and medium startups are going with MySQL only. MySQL can also be used for ERP solutions as it provides a Relational database, so managing reports and analyzing data would also be very easy in MySQL.
In the example below, we are creating a Table user in the database. Please go through the example below along with the screen.
use users; //Switching to users database
CREATE TABLE user (UserID int,UserlastName varchar(255),UserFirstName varchar(255),Address varchar(255),City varchar(255),age int );//designing schema and attributes of Person table.
DESCRIBE user; //fetching previously created table structure
This image shows existing databases and selecting user's database;
In the below image, we are creating a table name user.
In the below image, we display details of the table we created above.
To start with MySQL, we do not require to learn any programming languages. UI tools provide various ways to create, insert and delete. If you have not heard about MySQL Workbench, you should try it. It is a complete UI tool for MySQL.To start with MySQL, We should learn JOINS, insert, select, basics of data stored in the table, and its attributes.
A Web Developer: A web developer is the one who gets the data from the end-user and stores data into MySQL in the required format. He can also fetch the data from MySQL and display it to end-users. Developers should learn more of the syntax of Like JOIN, AGGREGATE, SUM, ORDER BY, GROUP BY, etc commands because to show data to end-user, they need to use all these components.
A Database Admin: A database admin is the one who creates all the roles on a particular database. For example, if the database name is users, then for this database, he will create various users like user1,user2, and user2. And all these users will be granted different types of roles according to the work they are going to perform in the users' database.