MySQL database and basic data types

Day01 MySQL database and data type

I. Overview of MySQL:

MySQL database is a relational database, a popular open source code database, and a completely networked cross-platform relational database system. MySQL database is also widely used and installed in the market at present, which can be called the fastest sql language database at present. The main advantages and characteristics are as follows:

1, cost-MySQL database is open source code, generally free to use.

2. Performance-MySQL database executes quickly

3. Reliable-some large companies and enterprises, as well as websites, use MySQL databases.

4. Simple-MySQL is easy to install and use.

Second, the auxiliary software of MySQL database

This software is a visual interface software to connect to the MySQL database, for beginners can also try to install and use, there are relevant teaching videos and installation manuals.

3. Data type of MySQL database

Data type is an attribute of data, which determines the storage format, valid range and corresponding restrictions of stored data.

MySQL data types are mainly divided into three categories: "number type", "string type", and "time and date type".

1. Digital data types: mainly divided into integer type and floating point type. See the following figure for details:

2. String type

String data types are mainly divided into three categories: "ordinary text string type", "variable type" and "special type", as shown in the following figure:

3. Date and time type

There are 5 date and time types, as shown in the following figure:

IV. Concluding remarks:

This article only briefly talks about MySQL databases and important data types, and here I emphasize that the data types I have annotated are commonly used data types that must be used. Be sure to master it.