MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type.

The data type of a column defines what value the column can hold: integer, character, money, date and time, binary, and so on.

This tutorial shows you various MySQL data types so that you can apply them effectively in designing your database tables.

MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type.

Sep 17, 2021 · In this article, we are going to discuss the MySQL data types list, including string, numeric, date and time, spatial, and JSON supported by MySQL. We’ll also provide examples of …

Feb 5, 2024 · Knowing which different data types exist ensures each column gets an appropriate type assigned, leading to an optimized and error-free database. In this tutorial, you will learn about the …

Jun 6, 2025 · Explore all MySQL data types including numeric, string, date, and spatial types. Learn how to use each one with examples and best practices for efficient database design.

MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT as an extension to the SQL standard.

Aug 20, 2025 · Today, we dive into the world of MySQL data types. You will learn what they are, how they work, and when should they be used. Start learning now!

Discover storage size, description, permissible values and examples for all numeric, string, date and time MySQL data types with advanced calculators.