MySQL database have latin1 character set by default. Here’s how to change character set from latin1 to UTF8 in MySQL.
How to Increase Max Connections in MySQL
How to store UTF8 characters in MySQL
MySQL allows you to store UTF8 characters and convert all tables to UTF8. Here’s how to store UTF8 data in MySQL databases.
PostgreSQL Materialized View
Materialized view allows you to store data physically and auto refresh view periodically. Here’s how to create materialized view in PostgreSQL.
How to Get Last Row Per Group in PostgreSQL
Sometimes you may need to get last row of table or last row per group in PostgreSQL. Here’s how to get last record of each group in PostgreSQL.
How To Rank Over Partition in MySQL
Sometimes you may need to rank over partition in MySQL or do grouped ranking in MySQL. Here’s how to do it with MySQL Rank partition function.
CONVERT_TZ – How To Change MySQL Timezone in Query
Sometimes you may need to convert time from one timezone to another. Here’s how to change MySQL timezone in query.
How To Change MySQL Server Time Zone
Sometimes you may need to change MySQL server time zone to UTC or change timezone in cPanel. Here’s how to change MySQL server time zone.
PostgreSQL Create Function
PostgreSQL create function allows you to create stored procedure and functions in PostgreSQL. Here’s how to use PostgreSQL create function.
PostgreSQL Create Schema
PostgreSQL Create Schema allows you to create database schema in PostgreSQL. Here’s how to create schema in PostgreSQL.