Welcome to the MySQL Knowledge Base and Tutorial
Rename table in MYSQL

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 wayRead More »
MySQL Interval

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 toRead More »
myisamchk — MyISAM Table-Maintenance Utility
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tablesRead More »
MySQL Server gone away while inserting or deleting
Try to add this line in [mysql] in my.cnf max_allowed_packet = 16MRead More »
MySQL : Introduction to MySQL

Read More »
quickly copy MySQL InnoDB database without using MySQL dump
For this process We should noted that there must have the same architecture on both machines. I.e. if we have 32 bit onRead More »
mysqli_connect() - function php mysql db connect
The mysqli_connect() function opens a new connection to the MySQL server. Syntax: mysqli_connect(host,username,password,dbname,port,socket); Parameter Description host Specifies a host nameRead More »
show progress on MySQL DB Import
You can use Pipe Viewer to monitor mysql dump. If you don’t already have pv, you can install it with: yumRead More »
Remove duplicate rows in MySQL
Easiest way to do this is to add a UNIQUE index on the column. When you write the ALTER statement,Read More »
MySQL Cluster - Core Concept

Read More »
MySQL Cluster Overview

Read More »
Setting of Resource Limit of MySQL User-Account
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to aRead More »
MySQL User Names and Passwords - MySQL Security
MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of aRead More »