MySQL. Add and modify table and data
Data adding makes with INNER JOIN (see examples below).
It is important to notice about encoding. When you add data in Russian to table and then make selection, question marks can appear. This is because, table and database encoding didn’t set. You must rub this query ALTER TABLE table_name CONVERT TO CHARACTER SET utf8;
Data selection makes with SELECT (see examples below). You can add conditions to SELECT queries. To update data you must use UPDATE operator.
In the end we dropped our database with DROP DATABASE sport; query.