MySQL Archives - Ubiq BI

How to Delete Duplicate Rows in MySQL

Often database developers need to remove duplicate records from MySQL table. Here are different ways to delete duplicates rows in MySQL.

Sometimes you may need to get multiple counts in single query in MySQL. Here are the different ways to do this.

It is important for developers and administrators to learn MySQL. Here are the best 5 online resources to learn MySQL.

Often database developers need to select top n rows per group in a table. Here are different ways to get top rows per group in MySQL.

Often database administrators need to allow remote users to access database. Here is how to enable remote access in MySQL.

Often database administrators need to create read only users for MySQL. Here are the steps to give read only user access in MySQL.

Sometimes database administrators need to increase max connections in MySQL. Here are the steps to do it.

Sometimes MySQL developers need to unpivot table in MySQL. Here are the steps to unpivot MySQL database table.

Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.

Sometimes database administrators need to import sql file in MySQL. Here are the different ways to do it.