Question

my sql

Answer 1

MySQL is a free and open source relational database technology that has relations in between the tables to make the applications that are compliance with it.

MySQL supports different kind of relationship in between the table and also supports the transaction management so it's no doubt in saying that it's best database for your application.

It was written in C & C++ and was developed by Oracle Corporation.

There are many persons by now from the MySQL and you can interact with the MySQL either with the command line or some graphical tools as well.

What's the need of MySQL?

Well, all the application have certain entities in it such as if I take an example of a Bank website then there are many entities in it such as customer, clerk, loan_taker, insurance etc and all having some relationships in between them because when you get the data then it will not come from a single table instead it will come from a multiple tables.

I assume that you want only a high level knowledge of it.

So that was about MySQL.

It uses the SQL language to interact with the MySQL shell.

There are many statements as well to fetch records from the table.

For example, if I want to fetch the students whose name is "John" then I write this query to get them.

SELECT * FROM STUDENTS WHERE FIRSTNAME="John";

This will give me the result of all the students whose first name is John