Datatype and Drop Database/Table with IF EXISTS and Create Database/Table with IF NOT EXISTS
In this article, we will learn about MySQL Datatype, and How we drop database and table with checking existing, create database and table with checking not existing
There are four types of data in MySQL: Numeric, String, Date & Time, and Enum. Let's explore the data types of each category. But first, we need to understand memory sizes. The common units of measurement are Bit, Byte, KB, MB, GB, and TB. A bit is the basic unit of binary computing, representing two states: 0 or 1. Therefore, 1 bit can store 2 values.
You should understand this information to estimate the data size, allowing you to design the database for optimal storage capacity.
You can follow the video tutorial below for more details
Comments
Post a Comment