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
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 engine
Read 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 the
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 a
Read 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 a
Read more Client Programming Security Guidelines – MySQL
Applications that access MySQL should not trust any data entered by users, who can try to trick your code by
Read more General Security Guidelines – MySQL Security
This article describes general security issues to be aware of and what you can do to make your MySQL installation more
Read more Security Issues With LOAD DATA LOCAL – MySQL Security
The LOAD DATA statement can load a file that is located on the server host, or it can load a
Read more
Asterisk : Select Multiple column from MySQL
Here is an example to select multiple column of a table from select statement in asterisk. exten => h,1,MYSQL(Connect conn
Read more
MySQL : Cheking MySQL replication status
Once replication has been started it should execute without requiring much regular administration. Depending on your replication environment, you will
Read more