{"id":3422,"date":"2017-08-14T23:48:58","date_gmt":"2017-08-14T20:48:58","guid":{"rendered":"http:\/\/kamil-abzalov.com\/tutorials\/intro-to-mysql\/"},"modified":"2020-04-08T23:47:35","modified_gmt":"2020-04-08T20:47:35","slug":"intro-to-mysql","status":"publish","type":"post","link":"https:\/\/kamil-abzalov.com\/en\/tutorials\/mysql\/intro-to-mysql\/","title":{"rendered":"Intro to MySQL"},"content":{"rendered":"

[et_pb_section fb_built=”1″ fullwidth=”on” _builder_version=”3.22″][et_pb_fullwidth_header title=”Intro to MySQL” content_max_width=”none” _builder_version=”3.16″ button_one_letter_spacing_hover=”0″ button_two_letter_spacing_hover=”0″ button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_one_letter_spacing__hover_enabled=”on” button_one_letter_spacing__hover=”0″ button_two_letter_spacing__hover_enabled=”on” button_two_letter_spacing__hover=”0″ button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off”][\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.22″][et_pb_row admin_label=”row” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0px|||”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_dcsbcm_divi_breadcrumbs_module homebreadcrumbtext=”Home” hide_currentbreadcrumb=”off” _builder_version=”4.4.2″ custom_padding=”0px|||” hover_enabled=”0″ fontsbreadcrumbs_font_size_tablet=”51″ fontsbreadcrumbs_line_height_tablet=”2″ fontsseperator_font_size_tablet=”51″ fontsseperator_line_height_tablet=”2″ fontsbreadcrumblinks_font_size_tablet=”51″ fontsbreadcrumblinks_line_height_tablet=”2″][\/et_pb_dcsbcm_divi_breadcrumbs_module][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” use_border_color=”off” border_color=”#ffffff” border_style=”solid”]Starting from this lesson we begin to learn mysql database management system and SQL (structure query language). Today we start from basics. Database is complex data which stores in a certain way for further search and management this data.
\n[\/et_pb_text][et_pb_video src=”https:\/\/www.youtube.com\/watch?v=JsdsdRkLd2c” _builder_version=”3.0.47″][\/et_pb_video][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” use_border_color=”off” border_color=”#ffffff” border_style=”solid”]Database management system is set of software for working with database.
\nThere are two databases types: relational database and non-relational (NoSQL) databases. In NoSQL databases developers management data without sql queries.<\/p>\n

Now we’ll talking about MySQL in details. You can download mysql installer from MySQL site<\/a>. If you use local environment server such as openserver<\/a> or wampserver<\/a> they already have necessary tools for work with databases.<\/p>\n

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:<\/p>\n

    \n
  1. INNOdb has got transactions mechanism. MyISAM has not. Transaction is mechanism which allows to rollback data if some error occured.<\/li>\n
  2. INNOdb has got foreign keys.
    \nNecessity of foreign keys we will discuss in next lesson.<\/li>\n<\/ol>\n

    Next we’ll create first database and first table.
    \n[\/et_pb_text][et_pb_dmb_code_snippet title=”Code lesson” code=”U0hPVyBEQVRBQkFTRVM7ICPQn9C+0LrQsNC30LDRgtGMINCy0YHQtSDQtNC+0YHRgtGD0L\/QvdGL0LUg0LHQsNC30Ysg0LTQsNC90L3Ri9GFLiDQmtCw0LbQtNGL0Lkg0LfQsNC\/0YDQvtGBINC00L7Qu9C20LXQvSDQt9Cw0LrQsNC90YfQuNCy0LDRgtGM0YHRjyDRgtC+0YfQutC+0Lkg0YEg0LfQsNC\/0Y\/RgtC+0LkKCkNSRUFURSBEQVRBQkFTRSBteWRiOyAjINCh0L7Qt9C00LDRgtGMINCx0LDQt9GDINC00LDQvdC90YvRhSDRgSDQuNC80LXQvdC10LwgbXlkYgoKRFJPUCBEQVRBQkFTRSBteWRiOyAjINCj0LTQsNC70LjRgtGMINCx0LDQt9GDINC00LDQvdC90YvRhQoKVVNFIG15ZGI7ICMg0JjRgdC\/0L7Qu9GM0LfQvtCy0LDRgtGMINC00LvRjyDRgNCw0LHQvtGC0Ysg0LHQsNC30YMg0LTQsNC90L3Ri9GFIG15ZGIKCkNSRUFURSBUQUJMRSBwbGF5ZXJzICgKCXBsYXllcl9pZCBpbnQgdW5zaWduZWQgcHJpbWFyeSBrZXkgYXV0b19pbmNyZW1lbnQgbm90IG51bGwsCglwbGF5ZXJfbmFtZSB2YXJjaGFyKDI1NSkgbm90IG51bGwKKTsKCi8q0KHQvtC30LTQsNC90LjQtSDRgtCw0LHQu9C40YbQuCBwbGF5ZXJzINGBINC\/0L7Qu9GP0LzQuCAiaWQg0LjQs9GA0L7QutCwIiAo0Y3RgtC+INC\/0L7Qu9C1INGP0LLQu9GP0LXRgtGB0Y8g0YPQvdC40LrQsNC70YzQvdGL0Lwg0LjQtNC10L3RgtC40YTQuNC60LDRgtC+0YDQvtC8INC30LDQv9C40YHQtdC5INCyINGC0LjQsdC70LjRhtC1IC0g0LrQu9GO0YfQvtC8KSDQuCAi0LjQvNGPINC40LPRgNC+0LrQsCIqLwoKU0hPVyBUQUJMRVM7ICMg0J\/QvtC60LDQt9Cw0YLRjCDRgdC\/0LjRgdC+0Log0YLQsNCx0LvQuNGGINCyINCx0LDQt9C1INC00LDQvdC90YvRhSBteWRiCgpERVNDIHBsYXllcnMgIyDQntC\/0LjRgdCw0L3QuNC1INGB0YLRgNGD0LrRgtGD0YDRiyDRgtCw0LHQu9C40YbRiyBwbGF5ZXJzCgpEUk9QIFRBQkxFIHBsYXllcnMgIyDQo9C00LDQu9C40YLRjCDRgtCw0LHQu9C40YbRgyBwbGF5ZXJz” admin_label=”\u041a\u043e\u0434 \u0443\u0440\u043e\u043a\u0430” style=”docco” linenums=”on” usetabwidth=”on” tabwidth=”4″ _builder_version=”4.4.2″ hover_enabled=”0″]U0hPVyBEQVRBQkFTRVM7ICPQn9C+0LrQsNC30LDRgtGMINCy0YHQtSDQtNC+0YHRgtGD0L\/QvdGL0LUg0LHQsNC30Ysg0LTQsNC90L3Ri9GFLiDQmtCw0LbQtNGL0Lkg0LfQsNC\/0YDQvtGBINC00L7Qu9C20LXQvSDQt9Cw0LrQsNC90YfQuNCy0LDRgtGM0YHRjyDRgtC+0YfQutC+0Lkg0YEg0LfQsNC\/0Y\/RgtC+0LkKCkNSRUFURSBEQVRBQkFTRSBteWRiOyAjINCh0L7Qt9C00LDRgtGMINCx0LDQt9GDINC00LDQvdC90YvRhSDRgSDQuNC80LXQvdC10LwgbXlkYgoKRFJPUCBEQVRBQkFTRSBteWRiOyAjINCj0LTQsNC70LjRgtGMINCx0LDQt9GDINC00LDQvdC90YvRhQoKVVNFIG15ZGI7ICMg0JjRgdC\/0L7Qu9GM0LfQvtCy0LDRgtGMINC00LvRjyDRgNCw0LHQvtGC0Ysg0LHQsNC30YMg0LTQsNC90L3Ri9GFIG15ZGIKCkNSRUFURSBUQUJMRSBwbGF5ZXJzICgKCXBsYXllcl9pZCBpbnQgdW5zaWduZWQgcHJpbWFyeSBrZXkgYXV0b19pbmNyZW1lbnQgbm90IG51bGwsCglwbGF5ZXJfbmFtZSB2YXJjaGFyKDI1NSkgbm90IG51bGwKKTsKCi8q0KHQvtC30LTQsNC90LjQtSDRgtCw0LHQu9C40YbQuCBwbGF5ZXJzINGBINC\/0L7Qu9GP0LzQuCAiaWQg0LjQs9GA0L7QutCwIiAo0Y3RgtC+INC\/0L7Qu9C1INGP0LLQu9GP0LXRgtGB0Y8g0YPQvdC40LrQsNC70YzQvdGL0Lwg0LjQtNC10L3RgtC40YTQuNC60LDRgtC+0YDQvtC8INC30LDQv9C40YHQtdC5INCyINGC0LjQsdC70LjRhtC1IC0g0LrQu9GO0YfQvtC8KSDQuCAi0LjQvNGPINC40LPRgNC+0LrQsCIqLwoKU0hPVyBUQUJMRVM7ICMg0J\/QvtC60LDQt9Cw0YLRjCDRgdC\/0LjRgdC+0Log0YLQsNCx0LvQuNGGINCyINCx0LDQt9C1INC00LDQvdC90YvRhSBteWRiCgpERVNDIHBsYXllcnMgIyDQntC\/0LjRgdCw0L3QuNC1INGB0YLRgNGD0LrRgtGD0YDRiyDRgtCw0LHQu9C40YbRiyBwbGF5ZXJzCgpEUk9QIFRBQkxFIHBsYXllcnMgIyDQo9C00LDQu9C40YLRjCDRgtCw0LHQu9C40YbRgyBwbGF5ZXJz[\/et_pb_dmb_code_snippet][et_pb_comments _builder_version=”4.4.2″ custom_margin=”30px||||false|false” hover_enabled=”0″][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

    Starting from this lesson we begin to learn mysql database management system and SQL (structure query language). Today we start from basics. Database is complex data which stores in a certain way for further search and management this data. Database management system is set of software for working with database. There are two databases types: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\u0412 \u044d\u0442\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u043c\u044b \u043d\u0430\u0447\u043d\u0435\u043c \u0438\u0437\u0443\u0447\u0430\u0442\u044c \u0421\u0423\u0411\u0414 MySQL \u0438 \u044f\u0437\u044b\u043a SQL (Structure Query Language). \u041d\u0430\u0447\u043d\u0435\u043c \u0441 \u0431\u0430\u0437\u043e\u0432\u044b\u0445 \u043f\u043e\u043d\u044f\u0442\u0438\u0439: \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 - \u0441\u043e\u0432\u043e\u043a\u0443\u043f\u043d\u043e\u0441\u0442\u044c \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438, \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u0430\u044f \u0438 \u0445\u0440\u0430\u043d\u044f\u0449\u0430\u044f\u0441\u044f \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u044b\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u0434\u043b\u044f \u0434\u0430\u043b\u044c\u043d\u0435\u0439\u0448\u0435\u0433\u043e \u043f\u043e\u0438\u0441\u043a\u0430 \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u044d\u0442\u043e\u0439 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0435\u0439.\r\n\r\nhttps:\/\/www.youtube.com\/watch?v=jKbl1sOrxcc\r\n\r\n\u0421\u0423\u0411\u0414 (\u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445) - \u043d\u0430\u0431\u043e\u0440 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u044b\u0445 \u0441\u0440\u0435\u0434\u0441\u0442\u0432 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445. \u042f\u0437\u044b\u043a SQL - \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 \u044f\u0437\u044b\u043a \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0438\u0439 \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445.\r\n\u0411\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0435 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u0434\u0435\u043b\u044f\u0442\u0441\u044f \u043d\u0430 \u0434\u0432\u0435 \u043a\u0430\u0442\u0435\u0433\u043e\u0440\u0438\u0438: \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0435 \u0438 \u043d\u0435\u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0435. \u0412 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0445 (\u0438\u0437 \u0441\u0430\u043c\u043e\u0433\u043e \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u044f \u0443\u0436\u0435 \u043f\u043e\u043d\u044f\u0442\u043d\u043e) \u0431\u0430\u0437\u0430\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f \u0445\u0440\u0430\u043d\u0438\u0442\u0441\u044f \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0445, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0441\u0432\u044f\u0437\u0430\u043d\u044b \u043c\u0435\u0436\u0434\u0443 \u0441\u043e\u0431\u043e\u0439. \u0412 \u043d\u0435\u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0431\u0430\u0437\u0430\u0445 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f \u0432 \u043e\u0431\u0449\u0435\u043c \u0441\u043c\u044b\u0441\u043b\u0435 \u0445\u0440\u0430\u043d\u0438\u0442\u0441\u044f \u0432 \u0432\u0438\u0434\u0435 \u043f\u0430\u0440\u044b \"\u043a\u043b\u044e\u0447-\u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\". \u0427\u0430\u0441\u0442\u043e \u0442\u0430\u043a\u0438\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430\u0437\u044b\u0432\u0430\u044e\u0442 NoSQL \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u0440\u0438\u0447\u0438\u043d\u0430 \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e \u0432 \u0442\u0430\u043a\u0438\u0445 \u0431\u0430\u0437\u0430\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u0432\u0435\u0434\u0435\u0442\u0441\u044f \u043d\u0435 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e SQL \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432.\r\n\r\n\u0422\u0435\u043f\u0435\u0440\u044c \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435 \u043f\u043e\u0433\u043e\u0432\u043e\u0440\u0438\u043c \u043e MySQL. \u0421\u043a\u0430\u0447\u0430\u0442\u044c \u0438\u043d\u0441\u0442\u0430\u043b\u043b\u0435\u0440 \u043c\u043e\u0436\u043d\u043e \u0441 \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0441\u0430\u0439\u0442\u0430 MySQL<\/a>, \u043b\u0438\u0431\u043e (\u0435\u0441\u043b\u0438 \u0432\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435 \u0433\u043e\u0442\u043e\u0432\u044b\u0435 \u0441\u0431\u043e\u0440\u043a\u0438 \u0442\u0438\u043f\u0430 openserver <\/a>\u0438 wamp<\/a>), \u0442\u043e \u0432 \u043d\u0438\u0445 \u0443\u0436\u0435 \u0435\u0441\u0442\u044c \u0432\u0441\u0435 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445.\r\n\r\n\u0412 MySQL \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044e\u0442 \u0434\u0432\u0430 \u0442\u0438\u043f\u0430 \u0434\u0432\u0438\u0436\u043a\u0430: MyISAM \u0438 INNOdb. \u0427\u0442\u043e \u0432\u044b\u0431\u0440\u0430\u0442\u044c? \u0415\u0441\u043b\u0438 \u0432\u044b \u043d\u0435 \u0441\u0430\u043c\u044b\u0439 \u043e\u043f\u044b\u0442\u043d\u044b\u0439 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a, \u0442\u043e \u0432\u044b\u0431\u0438\u0440\u0430\u0439\u0442\u0435 INNOdb. \u0412 \u044d\u0442\u0438\u0445 \u0434\u0432\u0438\u0436\u043a\u0430\u0445 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044e\u0442 \u043c\u043d\u043e\u0433\u043e \u0440\u0430\u0437\u043b\u0438\u0447\u0438\u0439, \u043d\u043e \u044f \u043e\u0442\u043c\u0435\u0447\u0443 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u043d\u0430\u0447\u0438\u043c\u044b\u0445:\r\n\r\n

      \r\n
    1. \u041d\u0430\u043b\u0438\u0447\u0438\u0435 \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c\u0430 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0439 \u0432 INNOdb \u0438 \u0435\u0433\u043e \u043e\u0442\u0441\u0443\u0442\u0441\u0442\u0432\u0438\u0435 \u0432 MyISAM. \u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f - \u044d\u0442\u043e \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0434\u0430\u0435\u0442 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0432 \u0441\u043b\u0443\u0447\u0430\u0435 \u0432\u043d\u0435\u0448\u0442\u0430\u0442\u043d\u043e\u0439 \u0441\u0438\u0442\u0443\u0430\u0446\u0438\u0438 \u0432\u043e \u0432\u0440\u0435\u043c\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f SQL \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043e\u0442\u043a\u0430\u0442\u0438\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u0434\u043e \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u044f, \u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u0431\u044b\u043b\u043e \u0434\u043e \u043d\u0430\u0447\u0430\u043b\u0430 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u0430.<\/li>\r\n
    2. \u041d\u0430\u043b\u0438\u0447\u0438\u0435 \u0432 INNOdb \u0432\u043d\u0435\u0448\u043d\u0438\u0445 \u043a\u043b\u044e\u0447\u0435\u0439 \u0438 \u0438\u0445 \u043e\u0442\u0441\u0443\u0442\u0441\u0442\u0432\u0438\u0435 \u0432 MyISAM. \u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u044c \u0432\u043d\u0435\u0448\u043d\u0438\u0445 \u043a\u043b\u044e\u0447\u0435\u0439 \u043c\u044b \u0440\u0430\u0437\u0431\u0435\u0440\u0435\u043c \u0432 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0445 \u0443\u0440\u043e\u043a\u0430\u0445.<\/li>\r\n<\/ol>\r\n\r\n\u0414\u0430\u043b\u0435\u0435 \u043c\u044b \u0441 \u0432\u0430\u043c\u0438 \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u043f\u0435\u0440\u0432\u0443\u044e \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u043f\u0435\u0440\u0432\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443.\r\n\r\n\u041a\u043e\u0434 \u0443\u0440\u043e\u043a\u0430:\r\n\r\n
      SHOW DATABASES; #\u041f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u0432\u0441\u0435 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445. \u041a\u0430\u0436\u0434\u044b\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 \u0434\u043e\u043b\u0436\u0435\u043d \u0437\u0430\u043a\u0430\u043d\u0447\u0438\u0432\u0430\u0442\u044c\u0441\u044f \u0442\u043e\u0447\u043a\u043e\u0439 \u0441 \u0437\u0430\u043f\u044f\u0442\u043e\u0439\r\n\r\nCREATE DATABASE mydb; # \u0421\u043e\u0437\u0434\u0430\u0442\u044c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0441 \u0438\u043c\u0435\u043d\u0435\u043c mydb\r\n\r\nDROP DATABASE mydb; # \u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445\r\n\r\nUSE mydb; # \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 mydb\r\n\r\nCREATE TABLE players (\r\n    player_id int unsigned primary key auto_increment not null,\r\n    player_name varchar(255) not null\r\n);\r\n\r\n\/*\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u0438 players \u0441 \u043f\u043e\u043b\u044f\u043c\u0438 \"id \u0438\u0433\u0440\u043e\u043a\u0430\" (\u044d\u0442\u043e \u043f\u043e\u043b\u0435 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u043c \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440\u043e\u043c \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u0432 \u0442\u0438\u0431\u043b\u0438\u0446\u0435 - \u043a\u043b\u044e\u0447\u043e\u043c) \u0438 \"\u0438\u043c\u044f \u0438\u0433\u0440\u043e\u043a\u0430\"*\/\r\n\r\nSHOW TABLES; # \u041f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u0442\u0430\u0431\u043b\u0438\u0446 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 mydb\r\n\r\nDESC players # \u041e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0442\u0430\u0431\u043b\u0438\u0446\u044b players\r\n\r\nDROP TABLE players # \u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 players\r\n\r\n<\/code><\/pre>","_et_gb_content_width":"","footnotes":""},"categories":[272,219],"tags":[248],"class_list":["post-3422","post","type-post","status-publish","format-standard","hentry","category-mysql","category-tutorials","tag-mysql-en"],"yoast_head":"\nIntro to MySQL - Kamil Abzalov's blog<\/title>\n<meta name=\"description\" content=\"The topic of this lesson is intro to mysql. Today we'll consider such terms as database, database management system, SQL and write our first queries.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Intro to MySQL - Kamil Abzalov's blog\" \/>\n<meta property=\"og:description\" content=\"The topic of this lesson is intro to mysql. Today we'll consider such terms as database, database management system, SQL and write our first queries.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0441\u0430\u0439\u0442 \u041a\u0430\u043c\u0438\u043b\u044f \u0410\u0431\u0437\u0430\u043b\u043e\u0432\u0430\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/kamabzalov\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-14T20:48:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-08T20:47:35+00:00\" \/>\n<meta name=\"author\" content=\"Kamil' Abzalov\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Intro to MySQL\" \/>\n<meta name=\"twitter:description\" content=\"The topic of this lesson is intro to mysql. Today we'll consider such terms as database, database management system, SQL and write our first queries.\" \/>\n<meta name=\"twitter:creator\" content=\"@kamabzalov\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kamil' Abzalov\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/mysql\\\/intro-to-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/mysql\\\/intro-to-mysql\\\/\"},\"author\":{\"name\":\"Kamil' Abzalov\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"headline\":\"Intro to MySQL\",\"datePublished\":\"2017-08-14T20:48:58+00:00\",\"dateModified\":\"2020-04-08T20:47:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/mysql\\\/intro-to-mysql\\\/\"},\"wordCount\":901,\"commentCount\":0,\"keywords\":[\"mysql\"],\"articleSection\":[\"MySQL tuts\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/mysql\\\/intro-to-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/mysql\\\/intro-to-mysql\\\/\",\"url\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/mysql\\\/intro-to-mysql\\\/\",\"name\":\"Intro to MySQL - Kamil Abzalov's blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#website\"},\"datePublished\":\"2017-08-14T20:48:58+00:00\",\"dateModified\":\"2020-04-08T20:47:35+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\"},\"description\":\"The topic of this lesson is intro to mysql. Today we'll consider such terms as database, database management system, SQL and write our first queries.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/mysql\\\/intro-to-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/mysql\\\/intro-to-mysql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/videouroki\\\/mysql\\\/intro-to-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/kamil-abzalov.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Intro to MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#website\",\"url\":\"https:\\\/\\\/kamil-abzalov.com\\\/\",\"name\":\"\u0441\u0430\u0439\u0442 \u041a\u0430\u043c\u0438\u043b\u044f \u0410\u0431\u0437\u0430\u043b\u043e\u0432\u0430\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kamil-abzalov.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kamil-abzalov.com\\\/#\\\/schema\\\/person\\\/9c53360f21b83306ba40c2231573c600\",\"name\":\"Kamil' Abzalov\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g\",\"caption\":\"Kamil' Abzalov\"},\"sameAs\":[\"https:\\\/\\\/kamil-abzalov.com\\\/\",\"https:\\\/\\\/www.facebook.com\\\/kamabzalov\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/kamabzalov\",\"https:\\\/\\\/x.com\\\/kamabzalov\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/kamabzalov\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Intro to MySQL - Kamil Abzalov's blog","description":"The topic of this lesson is intro to mysql. Today we'll consider such terms as database, database management system, SQL and write our first queries.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Intro to MySQL - Kamil Abzalov's blog","og_description":"The topic of this lesson is intro to mysql. Today we'll consider such terms as database, database management system, SQL and write our first queries.","og_url":"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/","og_site_name":"\u0441\u0430\u0439\u0442 \u041a\u0430\u043c\u0438\u043b\u044f \u0410\u0431\u0437\u0430\u043b\u043e\u0432\u0430","article_author":"https:\/\/www.facebook.com\/kamabzalov","article_published_time":"2017-08-14T20:48:58+00:00","article_modified_time":"2020-04-08T20:47:35+00:00","author":"Kamil' Abzalov","twitter_card":"summary_large_image","twitter_title":"Intro to MySQL","twitter_description":"The topic of this lesson is intro to mysql. Today we'll consider such terms as database, database management system, SQL and write our first queries.","twitter_creator":"@kamabzalov","twitter_misc":{"Written by":"Kamil' Abzalov","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/#article","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/"},"author":{"name":"Kamil' Abzalov","@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"headline":"Intro to MySQL","datePublished":"2017-08-14T20:48:58+00:00","dateModified":"2020-04-08T20:47:35+00:00","mainEntityOfPage":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/"},"wordCount":901,"commentCount":0,"keywords":["mysql"],"articleSection":["MySQL tuts","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/","url":"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/","name":"Intro to MySQL - Kamil Abzalov's blog","isPartOf":{"@id":"https:\/\/kamil-abzalov.com\/#website"},"datePublished":"2017-08-14T20:48:58+00:00","dateModified":"2020-04-08T20:47:35+00:00","author":{"@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600"},"description":"The topic of this lesson is intro to mysql. Today we'll consider such terms as database, database management system, SQL and write our first queries.","breadcrumb":{"@id":"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kamil-abzalov.com\/videouroki\/mysql\/intro-to-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/kamil-abzalov.com\/en\/"},{"@type":"ListItem","position":2,"name":"Intro to MySQL"}]},{"@type":"WebSite","@id":"https:\/\/kamil-abzalov.com\/#website","url":"https:\/\/kamil-abzalov.com\/","name":"\u0441\u0430\u0439\u0442 \u041a\u0430\u043c\u0438\u043b\u044f \u0410\u0431\u0437\u0430\u043b\u043e\u0432\u0430","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kamil-abzalov.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kamil-abzalov.com\/#\/schema\/person\/9c53360f21b83306ba40c2231573c600","name":"Kamil' Abzalov","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ad2daebcb3a4d03f8573b49054a003cd26a151ecc58ccfccc75b823131d1ead?s=96&d=mm&r=g","caption":"Kamil' Abzalov"},"sameAs":["https:\/\/kamil-abzalov.com\/","https:\/\/www.facebook.com\/kamabzalov","https:\/\/www.linkedin.com\/in\/kamabzalov","https:\/\/x.com\/kamabzalov","https:\/\/www.youtube.com\/user\/kamabzalov"]}]}},"_links":{"self":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/comments?post=3422"}],"version-history":[{"count":7,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3422\/revisions"}],"predecessor-version":[{"id":31850,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/posts\/3422\/revisions\/31850"}],"wp:attachment":[{"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/media?parent=3422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/categories?post=3422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kamil-abzalov.com\/en\/wp-json\/wp\/v2\/tags?post=3422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}