{"id":695,"date":"2021-07-06T13:01:26","date_gmt":"2021-07-06T13:01:26","guid":{"rendered":"https:\/\/www.bearloga.space\/?page_id=695"},"modified":"2021-07-08T09:41:08","modified_gmt":"2021-07-08T09:41:08","slug":"rukovodstvo-po-mysql","status":"publish","type":"page","link":"https:\/\/www.bearloga.space\/en\/rukovodstvo-po-mysql\/","title":{"rendered":"\u0420\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e MySQL"},"content":{"rendered":"\n
  1. \u0413\u043b\u0430\u0432\u0430 1. \u0412\u0432\u0435\u0434\u0435\u043d\u0438\u0435 \u0432 MySQL<\/a>
    1. \u0427\u0442\u043e \u0442\u0430\u043a\u043e\u0435 MySQL. \u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0430<\/a><\/li>
    2. \u041a\u043e\u043d\u0441\u043e\u043b\u044c\u043d\u044b\u0439 \u043a\u043b\u0438\u0435\u043d\u0442 MySQL Command Line Client<\/a><\/li>
    3. \u041a\u043e\u043d\u0441\u043e\u043b\u044c\u043d\u044b\u0439 \u043a\u043b\u0438\u0435\u043d\u0442 MySQL Shell<\/a><\/li>
    4. \u0413\u0440\u0430\u0444\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043a\u043b\u0438\u0435\u043d\u0442 MySQL Workbench<\/a><\/li><\/ol><\/li>
    5. \u0413\u043b\u0430\u0432\u0430 2. \u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0434\u0430\u043d\u043d\u044b\u0445<\/a>
      1. \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445<\/a><\/li>
      2. \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446<\/a><\/li>
      3. \u0422\u0438\u043f\u044b \u0434\u0430\u043d\u043d\u044b\u0445 MySQL<\/a><\/li>
      4. \u0410\u0442\u0440\u0438\u0431\u0443\u0442\u044b \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0438 \u0442\u0430\u0431\u043b\u0438\u0446<\/a><\/li>
      5. \u0412\u043d\u0435\u0448\u043d\u0438\u0435 \u043a\u043b\u044e\u0447\u0438 FOREIGN KEY<\/a><\/li>
      6. \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446 \u0438 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432<\/a><\/li><\/ol><\/li>
      7. \u0413\u043b\u0430\u0432\u0430 3. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438<\/a>
        1. \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u041a\u043e\u043c\u0430\u043d\u0434\u0430 INSERT<\/a><\/li>
        2. \u0412\u044b\u0431\u043e\u0440\u043a\u0430 \u0434\u0430\u043d\u043d\u044b\u0445. \u041a\u043e\u043c\u0430\u043d\u0434\u0430 SELECT<\/a><\/li>
        3. \u0424\u0438\u043b\u044c\u0442\u0440\u0430\u0446\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445. \u041e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 WHERE<\/a><\/li>
        4. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u041a\u043e\u043c\u0430\u043d\u0434\u0430 UPDATE<\/a><\/li>
        5. \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u041a\u043e\u043c\u0430\u043d\u0434\u0430 DELETE<\/a><\/li><\/ol><\/li>
        6. \u0413\u043b\u0430\u0432\u0430 4. \u0417\u0430\u043f\u0440\u043e\u0441\u044b<\/a>
          1. \u0412\u044b\u0431\u043e\u0440\u043a\u0430 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0445 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439. \u041e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 DISTINCT<\/a><\/li>
          2. \u041e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u044b \u0444\u0438\u043b\u044c\u0442\u0440\u0430\u0446\u0438\u0438<\/a><\/li>
          3. \u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430. ORDER BY<\/a><\/li>
          4. \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0434\u0438\u0430\u043f\u0430\u0437\u043e\u043d\u0430 \u0441\u0442\u0440\u043e\u043a. \u041e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 LIMIT<\/a><\/li>
          5. \u0410\u0433\u0440\u0435\u0433\u0430\u0442\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438<\/a><\/li>
          6. \u0413\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0430<\/a><\/li>
          7. \u041f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441\u044b<\/a><\/li>
          8. \u041f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0432 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u043a\u043e\u043c\u0430\u043d\u0434\u0430\u0445 SQL<\/a><\/li>
          9. \u041e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 EXISTS<\/a><\/li><\/ol><\/li>
          10. \u0413\u043b\u0430\u0432\u0430 5. \u0421\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435 <\/a>\u0442\u0430\u0431\u043b\u0438\u0446<\/a>
            1. \u041d\u0435\u044f\u0432\u043d\u043e\u0435 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446<\/a><\/li>
            2. Inner Join<\/a><\/li>
            3. Outer Join<\/a><\/li>
            4. UNION<\/a><\/li><\/ol><\/li>
            5. \u0413\u043b\u0430\u0432\u0430 6. \u0412\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438<\/a>
              1. \u0424\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f <\/a>\u0440\u0430\u0431\u043e\u0442\u044b <\/a>\u0441\u043e \u0441\u0442\u0440\u043e\u043a\u0430\u043c\u0438<\/a><\/li>
              2. \u0424\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0447\u0438\u0441\u043b\u0430\u043c\u0438<\/a><\/li>
              3. \u0424\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0434\u0430\u0442\u0430\u043c\u0438 \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c<\/a><\/li>
              4. \u0424\u0443\u043d\u043a\u0446\u0438\u0438 CASE, IF, IFNULL, COALESCE<\/a><\/li><\/ol><\/li><\/ol>\n\n\n\n

                <\/ins><\/p>\n","protected":false},"excerpt":{"rendered":"

                \u0413\u043b\u0430\u0432\u0430 1. \u0412\u0432\u0435\u0434\u0435\u043d\u0438\u0435 \u0432 MySQL \u0427\u0442\u043e \u0442\u0430\u043a\u043e\u0435 MySQL. \u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u041a\u043e\u043d\u0441\u043e\u043b\u044c\u043d\u044b\u0439 \u043a\u043b\u0438\u0435\u043d\u0442 MySQL Command Line Client \u041a\u043e\u043d\u0441\u043e\u043b\u044c\u043d\u044b\u0439 \u043a\u043b\u0438\u0435\u043d\u0442 MySQL Shell […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[75],"tags":[],"class_list":["post-695","page","type-page","status-publish","hentry","category-rukovodstvo-po-mysql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/pages\/695","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/comments?post=695"}],"version-history":[{"count":0,"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/pages\/695\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/media?parent=695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/categories?post=695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/tags?post=695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}