This article Database field types, has the purpose of offering the reader which are the most common and used in the field of programming.
Types of fields in database
Before knowing what the types of field in the database are, we begin that it is a database (BBDD), it refers to a series of similar data and that they are registered in a systematic way that are then processed, the processing of these data, will depend on the objectives set to achieve a product.
A database is made up of different tables that have the purpose of registering according to the function of their characteristics for which they were designed.
We recommend the following article Data types in mysql.
The nature of the values that are recorded in each of the fields must be taken into account, a database works with different information, it is worth noting that it should be indicated what type of value is entered, which optimizes the future search and get the best results from memory.
The most popular database field types are shown below, namely:
Alphanumerics
They are all those that have numbers and letters, they can be represented with a space of 225 characters.
The Numerics
As far as numbers are concerned, they are of various types, especially integers that do not have decimals, and real numbers that are represented with decimals.
The Booleans
They are the fields where two ways are registered: Yes or No, it is true or false.
The dates
They are the fields destined to record dates, which facilitate their exploitation later; saving dates in this way offers the possibility of sorting the records by dates or counting the days between dates.
The Memos
It refers to alphanumeric fields that have unlimited spaces, however the obstacle they have is that they cannot be indexed.
The self-increasing ones
These are the integer numeric fields that increase their value by one unit for each record that is inserted, the benefit they offer is that they function as an identifier, because they are special to a particular record.