- MySQL is owned by oracle corporation(ORACLE)
- SQL part in MySQL is STRUCTURED QUERY LANGUAGE
- It is written in C and C++ language
- MySQL is incorporated to provide solution to high and low level database system requirements.
- When it was launched, it was mainly for large database system. This is available in dual license format i.e. Open source(support from MySQL community only) and commercial product to get full support oracle.
- It works on wide range platforms
- It supports wide range of Data Types LONG,FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM,fixed and variable length strings
- Full support for nested queries, group functions,joins, CRUD operations
Support MySQL specific “show” statement which retrieves information database and its associated components and parameters - “EXPLAIN” query to check how optimizer resolves query
- Support for up to 64 indexes per table
- Clients can connect using TCP/IP protocol from any platform
- Error message can be provided in many languages, full support for different kind of character set and can be set at compile time and run time.
- MySQL involves several client and utility programs like cmd line, mysqldump, mysqladmin and graphical -MySQL workbench
- MySQL latest version comes with SQL and NoSQL (SQL+noSQL=MySQL)
- Benefits
Low license cost
Less downtime
Low hardware expenditure
Easily handles huge databases
Reduced maintenance cost
Less complicated solution
If you like, don't forget to share