Category: MySql

mysql 0

How to count of duplicate values in MySQL table

To check duplicate records in MySql table, use this simple query $ Select DISTINCT(name) as username, count(name) as usercount from usertable group by name having usercount > 1 This will return a result like...

mysql 0

How to install MySQL in CentOs7

MySQL is a well known database management system for web based and server based applications. MySql is RDBMS ( Relational Database Management System. It provides multi user access to the number of databases. MySQL...

mysql 0

Backup and restore large mysql database

It is very hard to backup and restore of a very large mysql database using the conventional phpmyadmin. Through command line you can take a backup of large database. First you need to have...