Features of MySQL

MySQL is an open-source database management system that is being used to manage database systems, retrieving data from database tables, etc.

The following are the key Features of MySQL:

  1. Data Types:

    MySQL supports different data types some of them are assigned and unsigned integers, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, TEXT, BLOB, DATE, TIME, DATETIME, YEAR, SET, ENUM, Geospatial types, fixed and variable strings.

  2. Portability and Internal Functionality:

    MySQL is developed in C and C++ programming languages with testing on a broad range of compilers. MySQL works and supports on different types of programming language platforms. It was designed to support multithreaded kernels with a multi-layered server design to use multiple CPUs. It able to perform joins very fast using optimization, and have separate storage for transactional and non-transactional. Internally uses hash tables which will be used as temporary tables.

  3. Functionality support:

    MySQL supports Function and Full operator in SELECT and where clause of the query. It supports left outer join and right outer join with basic syntax and ODBC syntax. It supports aliases for tables and columns as per standard SQL. It supports curd operations like Insert, Delete, Replace, and update statements which returns the number of rows updated, inserted, and deletes the rows which match the condition.

  4. Connectivity:

    Anyone can connect to MySQL database management system using different types of protocols such as TCP/IP sockets, using name pipes with enable-named-pipe, and using shared memory connection with enable-shared-memory and using UNIX domain sockets on Linux systems. MySQL clients can write programs in many languages as it has library support for different programming languages. Using connector / J interface Java client programs can connect to MySQL and perform operations.

  5. Security:

    MySQL handles security by password mechanism and privileges which is simple, fast, and secure for host-based verification. It handles security by password encryption for all passwords when we connect to the server.

  6. Scalability:

    MySQL supports very large databases, for example, we can have a server on which MySQL hosted and handles 50 million records, servers having 2lakh tables with 5 million records. It supports up to 64 indexes per table where the column can vary from 1 to 16 columns per table.


Copyright 1999- Ducat Creative, All rights reserved.

Anda bisa mendapatkan server slot online resmi dan terpercaya tentu saja di sini. Sebagai salah satu provider yang menyediakan banyak pilihan permainan.