In this article we will discuss types - data types supported by MySQL . Selection of data types is a matter that is important in managing the server. One reason is related to the space on my hard drive and memory to be " used " by these data .
The following will be given the data types supported by MySQL are fetched from the MySQL documentation . Type - type of data is provided in a form ready to be written in the syntax - syntax MySQL , for example Create Table. In these data types , there are several attributes that have the following meanings :
- M , shows a broad maximum characters . The maximum F value is 255 .
- D , shows the number of decimal places . The maximum value of D is 30 but is limited by the value of M , which must not be larger than the M - 2 .
- Attributes that are marked [ and ] means that its use is optional .
- If the attribute ZEROFILL included, MySQL will automatically add the attribute unsigned .
- are unsigned numbers without a sign in front of it ( eg a negative sign ) .
These are the types of data: