MySQL engine type for a specific database SHOW GLOBAL VARIABLES LIKE ‘storage_engine’ [xyz-ihs snippet=”Discuss”]
Category: Databse
Views in MySQL : MySQL Views
Summary: in this tutorial, you are going to learn about MySQL View. We will explain how MySQL implements views. MySQL supports database views […]
Difference between INNER JOIN and OUTER JOIN
An inner join of A and B gives the result of A intersect B, i.e. the inner part of a […]
NoSQL: What is NoSQL-An introduction
A NoSQL (often interpreted as Not Only SQL) database provides a mechanism for storage and retrieval of data that is […]
Reset ( Re-Sync ) MySQL Master-Slave Replication
Some times MySQL replication creates problems and slave could not sync properly from master. It may cause with lots of […]
views changed into tables, while restoring mysql database
In the backup script the views are first created as tables which are then dropped at the end of […]
MySQL Index : Understanding MySQL indexing
What is Indexing? A database index is a data structure that improves the speed of operations in a table. Indexes […]
MySQL Database Administration – Part1
Running and Shutting down MySQL Server: First check if your MySQL server is running or not. You can use the […]
Creating Views in MySQL : How to create mysql views
Summary: in this tutorial, you will learn how to create views in MySQL by using the CREATE VIEW statement. Introduction to CREATE VIEW statement […]
Reset mysql root password
Steps to reset the mysql root password Step # 1 : Stop mysql service # /etc/init.d/mysql stop Step # 2: Start […]