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...

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