MySQL charset and collation recommendations

Let’s go through a humourous journey when setting up a MySQL database for our application. The story becomes much lesser funnier when you get to know that we had to go through this in production because we started with the wrong MySQL charset and collation. TLDR: Always use utf8mb4 charset and utf8mb4_unicode_ci collation for your …

MySQL charset and collation recommendations Read More »

20 MySQL Interview Questions & Answers

1. What is MySQL? Answer: MySQL is an open source DBMS which is developed and distributed by Oracle Corporation. It is supported by most of the popular operating systems, such as Windows, Linux etc. It can be used to develop a different type of applications but it is mainly used for developing web applications. MySQL uses …

20 MySQL Interview Questions & Answers Read More »

Database Management – WebDevStudios

What Is Database Management? Very simply put, database management is knowing how to access, configure, debug, and manage your database. For some website owners, this isn’t really a concern. Even developers rarely need to poke around with the database, and for many of us, it’s just a piece of software that someone configured once and, as …

Database Management – WebDevStudios Read More »