How to install mysql in linux with practical

December 06, 2020 Add Comment Edit

SummaryIn the previous tutorial we have learned about the introductionof mysql and advantages of mysql . In this article we will learn how to install mysql in linux operating system like centos ,oracle,redhat and ubuntu.PrerequisiteTo install mysql in linux system first...

December 05, 2020 Add Comment Edit

SummaryIn this tutorial we will learn aboutintroduction of mysql. Also we will learn about what is database,type of database, what is mysql, advantages or we can sayfeatures of mysql.What is databaseDatabase is collection of datas which will stored in the organized manners in database...

Grant all privileges on database in mysql

October 26, 2020 Add Comment Edit

Summary In the previous article we have learned how to create a user in mysql and in this article we will learn how to grant all privileges on database in mysql.Start to grant mysql privileges first we need to login our mysql server using the below command.$mysql -u root -h localhost...

How to use alter table in sql with query

October 18, 2020 Add Comment Edit

SUMMARYIn this tutorial we will learn about alter table in sql. WHAT IS ALTER TABLEGenerally alter table is used to add column ,rename table ,drop column and modify data type of a column.Moreover any modification will be done after creating a table using alter table command.PREREQUISITE First...

How to use in operator in sql with example

October 17, 2020 Add Comment Edit

SUMMARY In this article we will learn about in operator and not in operator in sql. Generally to filter data from any table we use where clause along with condition.When we are using more than one value to filter data from the database table then in operator plays role to solve this issue and...

October 17, 2020 Add Comment Edit

SUMMARYIn this video tutorial we will learn how to use Like operator in sql with wildcard character .WHAT IS LIKE OPERATOR IN SQLWe use like operator for pattern search.There are two wildcard character " % " and " _ ".% is used to find from zero to any no of character._ is used to find for only...

October 17, 2020 Add Comment Edit

Table Of Contents Summary:Prerequisite: Display records if first character of name is same as last character in mysqlDisplay records if first character of the first name is same as first character of the last name.Conclusion Summary:In this tutorial...

How to select random values from a table and store it in another table in mysql

October 17, 2020 Add Comment Edit

Table Of Contents SummaryHow to select random values from a tableselect random values from a table and store it in another table in mysqlConclusion SummaryIn this tutorial we will learn how to select random values from a table and store it in another table in mysql.To retrieve random...

September 20, 2020 Add Comment Edit

In this tutorial we will learn what is views in mysql, what is the advantage of view, how to create view in mysql, how to update a view in mysql ,create view with check option and finally how to drop a view from mysql . Table Of Contents What is views in mysqlWhat is the advantage...

September 19, 2020 Add Comment Edit

In this tutorial we will learn what is join , Join types in MySql, Join syntax in MySql,Join query in mysql ,Join tables in MySql. Table Of Contents What is join Join types in MySqlJoin syntax in MySqlJoin tables in MySql What is join Join is a query which...

How to install mysql in linux with practical

Introduction of Mysql and its features

Grant all privileges on database in mysql

How to use alter table in sql with query

How to use in operator in sql with example

How to use Like operator in sql

Display records if first character of name is same as last character in mysql

How to select random values from a table and store it in another table in mysql

How to use views in MySql with example

How to use join query in MySql