Intro to MySQL
There are two databases types: relational database and non-relational (NoSQL) databases. In NoSQL databases developers management data without sql queries.
Now we’ll talking about MySQL in details. You can download mysql installer from MySQL site. If you use local environment server such as openserver or wampserver they already have necessary tools for work with databases.
MySQL has got two engines: MyISAM and INNOdb. What do you choose? If you are not experienced developer, you can choose INNOdb. There are a lot of differences in these engines. I notice the most important:
- INNOdb has got transactions mechanism. MyISAM has not. Transaction is mechanism which allows to rollback data if some error occured.
- INNOdb has got foreign keys.
Necessity of foreign keys we will discuss in next lesson.
Next we’ll create first database and first table.