Welcome to the MySQL Knowledge Base and Tutorial
Rename table in MYSQL
To rename a table in MySQL you just need to run a command named RENAME TABLE, the syntax isRead 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
MySQL interval values are used mainly for date and time calculations. INTERVAL {value of unit} {types of interval} INTERVAL isRead 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
Birth Of MySQL MySQL started out with the intention of using the mSQL database system to connect to tables using fastRead 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
NDBCLUSTER (also known as NDB) is an in-memory storage engine offering high-availability and data persistence features. The NDBCLUSTER storage engineRead More »
MySQL Cluster Overview
MySQL Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. The shared-nothing architecture enables theRead 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 »