Ottomatik Blog

Database Disaster Recovery Specialists

Altering MySQL Tables Using MySQL Add Column Statements
Altering MySQL Tables Using MySQL Add Column Statements

In this post, we will look at the different statements DBA’s used to alter MySQL database tables. Among the statements we will focus on is MySQL add column and MySQL drop column statements. Introducing The Add Column Statement In MySQL The MySQL add column statement is not solitary – before using it; you have to... » read more

MySQL Create User – Learn How to
MySQL Create User – Learn How to

If you do not already know how to use MySQL create user statements to create database users, this tutorial will take you through the process. But, before running a MySQL create new user command you need to have all the relevant root privileges. MySQL allows you to specify who can connect to the database server... » read more

Understanding MySQL Datatypes
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. In this post, we are going to introduce MySQL datatypes. MySQL database management... » read more

MySQL Substring Function
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... » read more

MySQL Workbench Download For Mac
MySQL Workbench Download For Mac

Most DBA’s do not mind working on the command line or shell. But there are database architects, developers and DBA’s who prefer a visual tool. If you are one of them, you will want to use a MySQL workbench download. This unified visual tool allows you to model data, develop SQL and features comprehensive administration... » read more

A Guide To MySQL Date Data Type
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.  Without a proper database management system, handling all the data available in the... » read more

MySQL 8.0 – All The Server Features And Improvements You Need To Know
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. Also, popular websites including YouTube, Twitter, Facebook, and Flickr are... » read more