MySQL Tutorial

Welcome to the MySQL Knowledge Base and Tutorial

 

mysql - sql query to fetch count of employee

mysql – sql query to fetch count of employee  
Read More »

MySQL 5.7 features

MySQL 5.7 features MySQL 5.7 is the best release ever of the world’s most popular open source database and provides
Read More »

MySQL service uptime

MySQL service uptime   Sometimes, we need to check the uptime for MySQL in our server. There are multiple method
Read More »

Replication with Different Master and Slave Storage Engines

Replication with Different Master and Slave Storage Engines It does not matter for the replication process whether the source table
Read More »

Executing SQL Statements from a Text File

Executing SQL Statements from a Text File The mysql client typically is used interactively, like this: shell> mysql db_name However,
Read More »

MySQL : Dumping Data in SQL Format with mysqldump

MySQL : Dumping Data in SQL Format with mysqldump   By default, mysqldump writes information as SQL statements to the standard output.
Read More »

RANGE Partitioning in MySQL

RANGE Partitioning in MySQL What is Partitioning? Partitioning is a way in which a database (MySQL in this case) splits
Read More »

Download HeidiSQL

Download HeidiSQL   Installer, 32/64 bit combined Portable version (zipped): 32 bit , 64 bit Microsoft Store App, 32 bit Sourcecode   HeidiSQL
Read More »

How can I check MySQL engine type for a specific database?

MySQL engine type for a specific database SHOW GLOBAL VARIABLES LIKE 'storage_engine' [xyz-ihs snippet="Discuss"]
Read More »

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
Read More »

mysqld — The MySQL Server

mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation.
Read More »

Rename table in MYSQL

mysqldump - mysql backup  To rename a table in MySQL you just need to run a command named RENAME TABLE, the syntax is
Read More »

mysql get date interval of 30 days

Very often we need to extract last 30 days, 7 days data from mysql DB. Here we will show easy way
Read More »

MySQL Interval

MySQL interval values are used mainly for date and time calculations. INTERVAL {value of unit} {types of interval} INTERVAL is
Read More »

mysql query get date of 1 month interval

Very often we need to extract last 1 month, 2 months data from mysql DB. Here we will show easy way to
Read More »

Older Entries » For any query or issue, feel free to discuss on http://discuss.eduguru.in