mysql

MYSQL Type Name in Database and its Definition

Numeric knowledge variety

Numeric data sort in MySQL database is divided into a few types of knowledge, particularly:

1. INT
Used to retailer knowledge in the type of confident and bad integers with range between -2.147.483.648 s / d 2.147.483.647. This knowledge sort has a four byte (32 bit).

2. TINYINT
Used to store knowledge in the form of positive and poor integers with variety between -128 s / d 127. This data sort has a dimension of 1 byte (eight bits)

3. SMALLINT
Used to store knowledge within the type of constructive and bad integers with range between -32.768 s / d 32.767. This knowledge form has a size of two bytes (16 bits)

4.MEDIUMINT
Used to store knowledge in the form of constructive and bad integers with range between -8.388.608 s / d 8.388.607. This information kind has a dimension of 3 bytes (24 bits)

5.BIGINT
Used to retailer data in the form of constructive and negative integers with range between -eight.388.608 s / d 8.388.607. This information form has a size of 8 bytes (sixty four bits)

6.Drift
Used to retailer data in the type of optimistic and poor precision fractions. This information kind has a dimension of 4 bytes (32 bits).

7.DOUBLE
Used to store information within the type of constructive and negative precision fractions. This knowledge type has a measurement of eight bytes (sixty four bits).

8. DECIMAL
Used to retailer information in the form of confident and poor precision fractions. This data sort has a dimension of 8 bytes (sixty four bits).

9. Real
Used to store data within the type of optimistic and negative fractions. This knowledge variety has a measurement of 8 bytes (64 bits).

10. NUMERIC
Used to store knowledge in the form of positive and terrible fractions. This knowledge type has a measurement of eight bytes (64 bits).

Information variety Date & Time
information sort Date & Time on MySQL database is divided into a couple of varieties of data, particularly:

11. DATE
Used to save lots of date knowledge in YY: MM: DD structure

12. DATETIME
Used to retailer date and time data in YY: MM: DD HH: MM: SS structure

13.TIME
Used to store time data in HH: MM: SS format

14. 12 months
Used to retailer 12 months information.

String knowledge style
data style String in the MySQL database is divided into a few varieties of information, particularly:

15. CHAR
Used to store persona knowledge / strings with fixed measurement. This data form has a range of zero to 255 characters.

16. VARCHAR
Used for storing persona / string information with dynamic measurement. This data sort has a variety between 0 to 255 for MySQL version 4.1. And has a variety between zero s / d sixty five,535 for MySQL variation 5.0.3

17.BLOB
BLOB (Binary enormous Object) is a data sort used to retailer binary information corresponding to documents, pix, sounds, and many others. This knowledge type has a range of 216-1 bytes.

18. TINYBLOB
Used to retailer binary data equivalent to documents, pictures, and sound. This information kind has a range of 255 bytes.

19. MEDIUMBLOB
Used to store binary information corresponding to records, snap shots, and sound. This knowledge sort has a 244-1 byte variety.

20. LONGBLOB
Used to retailer binary knowledge equivalent to records, pix, and sound. This data type has a variety of 232-1 bytes

21. Textual content
Used to save text information. This knowledge variety has a variety of 0 to sixty five,535 (216-1) characters.

22. TINYTEXT
Used to avoid wasting textual content knowledge. This information type has a range between 0 s / d 255 for MySQL variant 4.Zero, and has a variety between zero s / d 65,535 for MySQL variation 5.Zero.Three

23. MEDIUMTEXT
Used to avoid wasting text data. This knowledge sort has a variety between 0 to 224-1 characters

24. LONGTEXT
Used to save lots of text information. This data style has a variety of zero to 232-1 characters

25. ENUM
Used for storing enumerated knowledge (knowledge set)

26. SET
Used to store data dataset

#good luck, hopefully useful, tks

Views All Time
Views All Time
174
Views Today
Views Today
3

2 thoughts on “MYSQL Type Name in Database and its Definition”

Leave a Reply

Your email address will not be published. Required fields are marked *