Blog

Understanding MySQL Datatypes

If you are planning on creating a MySQL database, then you need to understand everything there is to know about the most basic functions you can perform. You also need to understand the different MySQL datatypes and how the program stores data.

Read more

MySQL Substring Function

MySQL substring is a MySQL string function that gives you the ability to query and return from a string, a substring. For instance, if you want to grab a small piece of text from a larger piece, the substring function is the easiest way to do it. The syntax of this MySQL string function differs depending on how you want to use it.

Read more

A Guide To MySQL Date Data Type

In this guide, we will look at MySQL Date data type and other related MySQL date statements like MySQL curdate. But before we do that, we need to first understand why data types like MySQL date and MySQL curdate statements are important. 

Read more

MySQL 8.0 – All The Server Features And Improvements You Need To Know

The world’s most popular open-source database got an improvement with the announcement of the improved MySQL 8.0 back in late 2016. Any database-driven web applications rely on MySQL to function properly and perform. Some popular applications include WordPress, Joomla, Drupal and our very own, Ottomatik.

Read more

Step By Step Guide To MySQL Download And Setup For Windows

Our guide to MySQL download outlines the downloading and installation processes for both MySQL free download and MySQL 5.7 download for windows PC’s. In this post, our focus will be on the community edition which is the free version and not the paid enterprise edition.

Read more

Using MySQL On Mac – Install MySQL Mac

The install MySQL Mac process should be a straightforward one but it does not have to have a step-by-step guide. In this post, we will look at the install MySQL mac process and also look at the uninstall MySQL Mac process.

Read more

Learn MySQL And MySQL JSON – Step by Step

MySQL is an Oracle-sponsored open-source social database whose execution framework (RDBMS) is built upon Structured Query Language (SQL). MySQL will run on essentially all OS platforms, including Linux, UNIX, macOS, and Windows. Although it tends to be utilized in a wide scope of uses, MySQL is regularly connected with web applications and internet distribution.

Read more

How to list all database users using proper MySQL show users statements

There are some functions, statements, and queries that you are bound to run in MySQL as long as you are managing a MySQL database. Two of these are the MySQL show users and the MySQL show all users statements, which to be fair are often common assumptions.

Read more

MongoDB Backup: Everything You Need to Know

Working with non-relational databases like MongoDB feels, in many ways, different from working with traditional structured ones. Instead of a series of interrelated tables, your data is stored in documents. Because of this, instead of the limitations of relational databases, which require building a structure before entering data, with NoSQL databases like MongoDB you gain the ability to construct your data on the fly. While it might not provide as much mathematical structure and internal control as a traditional relational database like MySQL or PostgreSQL, MongoDB is more scalable and provides considerably superior performance for online applications.

Read more