Categories: MySQL

Data Types – MySQL

Share

MySQL supports different data types while creating columns i.e. what type of value is using for the column or fixed/variable length etc.

It has different types of data types i.e.

Numeric: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE, BIT

String: CHAR, VARCHAR, BINARY, VARBINARY, TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, ENUM, SET

Date and Time: DATE, TIME, DATETIME, TIMESTAMP, YEAR

There are many more data type are there which MySQL use.

Recent Posts

10 Reasons Why Technology is Good for Education

Educational technology has been very helpful in the era of ever-advancing technology. It opens millions…

7 hours ago

Chat GPT Login: Step-by-Step Guide for Beginners

Have you ever thought of a world where asking the Internet for information feels like…

11 hours ago

The Sharp-Looking Guy: 5 Essential Tips for Men to Become Sharp

We've gotten so used to seeing men streetwear joggers, ripped jeans, and sleeveless shirts. Hair…

2 days ago

How to Use Your Wedding Jewellery In Unique Ways At Festivals

When it comes to festivals, the options for wedding jewellery are endless. You can go…

2 days ago

5 Tips On Window Cleaning

Whether it concerns your home or an office building, the state of a property’s windows…

2 days ago

Sustainable Business Practices: A Win-Win Strategy

You know that running an environmentally sustainable business is the right thing to do. But…

2 days ago