Quick Contact
SQL & My SQL Tutorial
- INTRODUCATION
- What is SQL?
- SQL Microsoft
- SQL Management Tools
- SQL Developer
- Docker Commands
- Composite Key in SQL
- SQL Constraints
- Transactions in SQL Server
- SQL Server Data Types
- SQL Update Join
- SQL Operators
- SQL Clauses
- SQL Commands
- SQL Alter Command
- Distinct Keyword in SQL
- SQL Statements
- SQL Index
- SQL Injections
- Wildcards in SQL
- Alter and Truncate Command in SQL
- SQL Null Functions – ISNULL, IFNULL, Combine, & NULLIF
- SQL Sequence
- How to Find Duplicate Records in SQL
- Primary and Foreign Key in SQL with Examples
- COUNT Function
- SUM Function in SQL
- Dynamic SQL
- Database Tuning
- Pseudocolumn in Oracle SQL
- Triggers in SQL
- Embedded SQL in DBMS
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:
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.