Ottomatik Blog

Database Disaster Recovery Specialists

Guide To MySQL Workbench – Understand How It Works
Guide To MySQL Workbench – Understand How It Works

Our guide to MySQL Workbench outlines its main program features. It also includes MySQL Workbench Linux and MySQL Workbench MacOS, and their respective installation procedures. First, Let’s Define MySQL Workbench MySQL Workbench is a unified visual tool that enables Database administrators or data architects to design, generate and manage a wide range of databases. MySQL Workbench... » read more

MySQL Download Mac – Download And Installation
MySQL Download Mac – Download And Installation

To start the installation of MySQL on your Mac, you need to download it first. Here is a MySQL 5.6 download copy. There may be newer and better versions of MySQL, so depending on your preference, use your favorite browser to search for and download whichever version you prefer. There are three ways of downloading... » read more

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