Tinyint in mysql is represented by NUMBER data type in Oracle. It can also be expressed as an integer data type. Integer Integer type is a small integer. It is not a variable. It is a subset of numbers. Generally speaking, INTERGER is not used with NUMBER.

MySQL is a relational database management system. Relational databases store data in different tables instead of storing all data in a large repository, which can improve speed and flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts dual authorization strategy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, MySQL is generally chosen as the website database for the development of small and medium-sized websites.

Extended data:

Mysql system functions:

Written in C and C ++, tested with various compilers to ensure the portability of the source code.

Support AIX, FreeBSD, HP -UX, Linux, Mac OS, NovellNetware, OpenBSD, OS/2 Wrap, Solaris, Windows and other operating systems.

Apis of multiple programming languages. These programming languages include C, C ++, Python, Java, Perl, PHP, Eiffel, Ruby,. NET and Tcl. Support multithreading and make full use of CPU resources.

The optimized SQL query algorithm can effectively improve the query speed. It can be used as a separate application in the client-server network environment, or it can be embedded into other software as a library.

Multilingual support is provided. Common codes such as Chinese GB 23 12, BIG5 and Japanese Shift_JIS can be used as data table names and data column names. Provide a variety of database connection methods, such as TCP/IP, ODBC and JDBC.

Provides management tools for managing, checking and optimizing database operations. Support large databases. It can handle large databases with tens of millions of records.

References:

Baidu encyclopedia -mySQL