What is MySQL? What are its functions and features?
Answers
Explanation:
MySQL is a relational database system. If you can believe many diehard MySQL fans, MySQL is faster, more reliable, and cheaper -- or, simply put, better -- than any other database system (including commercial systems such as Oracle and DB2). Many MySQL opponents continue to challenge this viewpoint, going even so far as to assert that MySQL is not even a relational database system.
Features of MySQL
Relational Database System: Like almost all other database systems on the market, MySQL is a relational database system.
Client/Server Architecture: MySQL is a client/server system.
SQL compatibility: MySQL supports as its database language
Stored procedures: Here we are dealing with SQL code that is stored in the database system.
Triggers: Triggers are SQL commands that are automatically executed by the server in certain database operations (INSERT, UPDATE, and DELETE).
User interface: There are a number of convenient user interfaces for administering a MySQL server.
ODBC: MySQL supports the ODBC interface Connector/ODBC.
Platform independence: It is not only client applications that run under a variety of operating systems
Speed: MySQL is considered a very fast database program.
Programming languages: There are quite a number of APIs (application programming interfaces) and libraries for the development of MySQL applications.