What is MySQL ?
Notes:
What is MySQL?
MySQL is the most popular, open source, multi platform, Relational Data Base Management System (RDBMS).
Most popular:
MySQL is the 2nd most used DBMS.
Oracle, MySQL, Microsoft SQL Server, PostgreSQL, Microsoft Access etc.
Many of the world’s largest and fastest growing organizations like Face book, Google, Adobe, Zappos rely on MySQL.
Open source (free):
The original source code is freely available to read, understand, use and extend.
Written in C and C++
Multiplatform(platform independent):
MySQL is available for almost all platforms like windows, Linux, Mac OS, and Android etc.
So we can port the created databases from one platform to another platform and execute MySQL source codes on variety of platforms without any modifications.
Relational Data Base Management System (RDBMS):
Database: organized collection of interrelated data
Database Management: means efficiently storing, accessing, manipulating, and processing data present within the database. I.e. managing the database
Data Base Management System (DBMS): is a system of programs or a software package; which is meant to efficiently store, access, manipulate, and process the data present within the database. i.e. manage the database.
Relational Database: where the data is organized in the form of relations (tables)
Relational Data Base Management System(RDBMS): is a system of programs or a software package; which is meant to efficiently store, access, manipulate, and process the data present within the relational database. I.e. manage the relational database.
“So MySQL is one of the most popular, open source, multi platform, software package; which is meant to efficiently manage the relational database(s).”
Interview Questions:
