{"id":1310,"date":"2009-12-01T11:17:31","date_gmt":"2009-12-01T09:17:31","guid":{"rendered":"http:\/\/www.blog.atbliss.ru\/?p=1310"},"modified":"2010-08-12T20:10:34","modified_gmt":"2010-08-12T20:10:34","slug":"example-mysql-tables","status":"publish","type":"post","link":"https:\/\/atbliss.ru\/example-mysql-tables\/","title":{"rendered":"\u041a\u0430\u043a\u0438\u0435 \u0442\u0438\u043f\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0445 MySQL"},"content":{"rendered":"<p>\u041a\u0430\u043a\u0438\u0435 <a href=\"\/\/atbliss.ru\/web-programming\/mysql-column-types\/\">\u0442\u0438\u043f\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432<\/a> \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0442\u0430\u0431\u043b\u0438\u0446 MySQL \u0438 \u043a\u0430\u043a\u043e\u0439 \u043e\u0431\u044a\u0435\u043c \u043f\u0430\u043c\u044f\u0442\u0438 \u0432\u044b\u0434\u0435\u043b\u0438\u0442\u044c? \u0412\u0441\u0435 \u0437\u0430\u0432\u0438\u0441\u0438\u0442 \u043e\u0442 \u0442\u043e\u0433\u043e, \u043a\u0430\u043a\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0434\u043e\u043b\u0436\u043d\u044b \u0445\u0440\u0430\u043d\u0438\u0442\u044c\u0441\u044f \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n<p>\u0420\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043d\u043e\u0432\u043e\u0441\u0442\u0435\u0439. \u0417\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a \u043d\u043e\u0432\u043e\u0441\u0442\u0438 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043b\u044e\u0431\u044b\u043c, \u043f\u043e\u044d\u0442\u043e\u043c\u0443, \u0432\u043c\u0435\u0441\u0442\u043e CHAR, \u0441\u043b\u0435\u0434\u0443\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0442\u0438\u043f \u0434\u0430\u043d\u043d\u044b\u0445 VARCHAR.<\/p>\n<p>\u041e\u0442\u043b\u0438\u0447\u0438\u0435 \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e CHAR \u2014 \u0441\u0442\u0440\u043e\u043a\u0430 \u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0439 \u0434\u043b\u0438\u043d\u044b, \u043f\u0440\u0438 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0438 \u0432\u0441\u0435\u0433\u0434\u0430 \u0434\u043e\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0431\u0435\u043b\u0430\u043c\u0438 \u0432 \u043a\u043e\u043d\u0446\u0435 \u0441\u0442\u0440\u043e\u043a\u0438 \u0434\u043e \u0437\u0430\u0434\u0430\u043d\u043d\u043e\u0433\u043e \u0440\u0430\u0437\u043c\u0435\u0440\u0430, VARCHAR \u2014 \u0441\u0442\u0440\u043e\u043a\u0430 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0434\u043b\u0438\u043d\u044b, \u043a\u043e\u043d\u0446\u0435\u0432\u044b\u0435 \u043f\u0440\u043e\u0431\u0435\u043b\u044b \u0443\u0434\u0430\u043b\u044f\u044e\u0442\u0441\u044f \u043f\u0440\u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0438 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f. \u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u044d\u043a\u043e\u043d\u043e\u043c\u0438\u0442\u0441\u044f \u043e\u0431\u044a\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0445, \u0445\u0440\u0430\u043d\u044f\u0449\u0438\u0445\u0441\u044f \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n<figure id=\"attachment_1309\" aria-describedby=\"caption-attachment-1309\" style=\"width: 762px\" class=\"wp-caption alignnone\"><span itemprop=\"image\" itemscope itemtype=\"https:\/\/schema.org\/ImageObject\"><img itemprop=\"url image\" loading=\"lazy\" class=\"size-full wp-image-1309     \" title=\"news_tbl\" src=\"\/\/www.blog.atbliss.ru\/wp-content\/uploads\/2009\/12\/news_tbl.png\" alt=\"news_tbl\" width=\"762\" height=\"221\" \/><meta itemprop=\"width\" content=\"762\"><meta itemprop=\"height\" content=\"221\"><\/span><figcaption id=\"caption-attachment-1309\" class=\"wp-caption-text\">\u0422\u0430\u0431\u043b\u0438\u0446\u0430 news<\/figcaption><\/figure>\n<p>\u041f\u0443\u0441\u0442\u044c \u0432\u0430\u0441 \u043d\u0435 \u0441\u043c\u0443\u0449\u0430\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e <em>NULL<\/em> \u043f\u043e\u043b\u044f id, \u0442. \u043a. \u0443 \u043d\u0435\u0433\u043e \u0435\u0441\u0442\u044c \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 auto_increment. \u041f\u0440\u0438 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0438 \u043d\u043e\u0432\u043e\u0439 \u0437\u0430\u043f\u0438\u0441\u0438, MySQL \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0437\u0430\u043f\u043e\u043b\u043d\u0438\u0442 \u043f\u043e\u043b\u0435 id.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041a\u0430\u043a\u0438\u0435 \u0442\u0438\u043f\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0442\u0430\u0431\u043b\u0438\u0446 MySQL \u0438 \u043a\u0430\u043a\u043e\u0439 \u043e\u0431\u044a\u0435\u043c \u043f\u0430\u043c\u044f\u0442\u0438 \u0432\u044b\u0434\u0435\u043b\u0438\u0442\u044c? \u0412\u0441\u0435 \u0437\u0430\u0432\u0438\u0441\u0438\u0442 \u043e\u0442 \u0442\u043e\u0433\u043e, \u043a\u0430\u043a\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0434\u043e\u043b\u0436\u043d\u044b \u0445\u0440\u0430\u043d\u0438\u0442\u044c\u0441\u044f \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u0420\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043d\u043e\u0432\u043e\u0441\u0442\u0435\u0439. \u0417\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a \u043d\u043e\u0432\u043e\u0441\u0442\u0438 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043b\u044e\u0431\u044b\u043c, \u043f\u043e\u044d\u0442\u043e\u043c\u0443, \u0432\u043c\u0435\u0441\u0442\u043e CHAR, \u0441\u043b\u0435\u0434\u0443\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0442\u0438\u043f \u0434\u0430\u043d\u043d\u044b\u0445 VARCHAR. \u041e\u0442\u043b\u0438\u0447\u0438\u0435 \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e CHAR \u2014 \u0441\u0442\u0440\u043e\u043a\u0430 \u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0439 \u0434\u043b\u0438\u043d\u044b, \u043f\u0440\u0438 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0438 \u0432\u0441\u0435\u0433\u0434\u0430 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v16.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u041a\u0430\u043a\u0438\u0435 \u0442\u0438\u043f\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0445 MySQL<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/atbliss.ru\/example-mysql-tables\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u041a\u0430\u043a\u0438\u0435 \u0442\u0438\u043f\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0445 MySQL\" \/>\n<meta property=\"og:description\" content=\"\u041a\u0430\u043a\u0438\u0435 \u0442\u0438\u043f\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0442\u0430\u0431\u043b\u0438\u0446 MySQL \u0438 \u043a\u0430\u043a\u043e\u0439 \u043e\u0431\u044a\u0435\u043c \u043f\u0430\u043c\u044f\u0442\u0438 \u0432\u044b\u0434\u0435\u043b\u0438\u0442\u044c? \u0412\u0441\u0435 \u0437\u0430\u0432\u0438\u0441\u0438\u0442 \u043e\u0442 \u0442\u043e\u0433\u043e, \u043a\u0430\u043a\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0434\u043e\u043b\u0436\u043d\u044b \u0445\u0440\u0430\u043d\u0438\u0442\u044c\u0441\u044f \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u0420\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043d\u043e\u0432\u043e\u0441\u0442\u0435\u0439. \u0417\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a \u043d\u043e\u0432\u043e\u0441\u0442\u0438 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043b\u044e\u0431\u044b\u043c, \u043f\u043e\u044d\u0442\u043e\u043c\u0443, \u0432\u043c\u0435\u0441\u0442\u043e CHAR, \u0441\u043b\u0435\u0434\u0443\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0442\u0438\u043f \u0434\u0430\u043d\u043d\u044b\u0445 VARCHAR. \u041e\u0442\u043b\u0438\u0447\u0438\u0435 \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e CHAR \u2014 \u0441\u0442\u0440\u043e\u043a\u0430 \u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0439 \u0434\u043b\u0438\u043d\u044b, \u043f\u0440\u0438 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0438 \u0432\u0441\u0435\u0433\u0434\u0430 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/atbliss.ru\/example-mysql-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"\u265b atbliss.ru\" \/>\n<meta property=\"article:published_time\" content=\"2009-12-01T09:17:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2010-08-12T20:10:34+00:00\" \/>\n<meta property=\"og:image\" content=\"\/\/www.blog.atbliss.ru\/wp-content\/uploads\/2009\/12\/news_tbl.png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@fortresseo\" \/>\n<meta name=\"twitter:site\" content=\"@fortresseo\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/atbliss.ru\/#website\",\"url\":\"https:\/\/atbliss.ru\/\",\"name\":\"\\u265b atbliss.ru\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/atbliss.ru\/#\/schema\/person\/f2a825e30885a03a307bafc0fe7f546a\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/atbliss.ru\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ru-RU\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/atbliss.ru\/example-mysql-tables\/#primaryimage\",\"inLanguage\":\"ru-RU\",\"url\":\"\/\/www.blog.atbliss.ru\/wp-content\/uploads\/2009\/12\/news_tbl.png\",\"contentUrl\":\"\/\/www.blog.atbliss.ru\/wp-content\/uploads\/2009\/12\/news_tbl.png\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atbliss.ru\/example-mysql-tables\/#webpage\",\"url\":\"https:\/\/atbliss.ru\/example-mysql-tables\/\",\"name\":\"\\u041a\\u0430\\u043a\\u0438\\u0435 \\u0442\\u0438\\u043f\\u044b \\u0434\\u0430\\u043d\\u043d\\u044b\\u0445 \\u0438\\u0441\\u043f\\u043e\\u043b\\u044c\\u0437\\u043e\\u0432\\u0430\\u0442\\u044c \\u0432 \\u0442\\u0430\\u0431\\u043b\\u0438\\u0446\\u0430\\u0445 MySQL\",\"isPartOf\":{\"@id\":\"https:\/\/atbliss.ru\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/atbliss.ru\/example-mysql-tables\/#primaryimage\"},\"datePublished\":\"2009-12-01T09:17:31+00:00\",\"dateModified\":\"2010-08-12T20:10:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/atbliss.ru\/example-mysql-tables\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/atbliss.ru\/example-mysql-tables\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/atbliss.ru\/example-mysql-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atbliss.ru\/\",\"url\":\"https:\/\/atbliss.ru\/\",\"name\":\"atbliss.ru\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atbliss.ru\/marketing\/\",\"url\":\"https:\/\/atbliss.ru\/marketing\/\",\"name\":\"\\u0418\\u043d\\u0442\\u0435\\u0440\\u043d\\u0435\\u0442-\\u043c\\u0430\\u0440\\u043a\\u0435\\u0442\\u0438\\u043d\\u0433\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atbliss.ru\/marketing\/seo\/\",\"url\":\"https:\/\/atbliss.ru\/marketing\/seo\/\",\"name\":\"SEO\"}},{\"@type\":\"ListItem\",\"position\":4,\"item\":{\"@id\":\"https:\/\/atbliss.ru\/example-mysql-tables\/#webpage\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/atbliss.ru\/example-mysql-tables\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/atbliss.ru\/example-mysql-tables\/#webpage\"},\"author\":{\"@id\":\"https:\/\/atbliss.ru\/#\/schema\/person\/f2a825e30885a03a307bafc0fe7f546a\"},\"headline\":\"\\u041a\\u0430\\u043a\\u0438\\u0435 \\u0442\\u0438\\u043f\\u044b \\u0434\\u0430\\u043d\\u043d\\u044b\\u0445 \\u0438\\u0441\\u043f\\u043e\\u043b\\u044c\\u0437\\u043e\\u0432\\u0430\\u0442\\u044c \\u0432 \\u0442\\u0430\\u0431\\u043b\\u0438\\u0446\\u0430\\u0445 MySQL\",\"datePublished\":\"2009-12-01T09:17:31+00:00\",\"dateModified\":\"2010-08-12T20:10:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/atbliss.ru\/example-mysql-tables\/#webpage\"},\"wordCount\":21,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/atbliss.ru\/#\/schema\/person\/f2a825e30885a03a307bafc0fe7f546a\"},\"image\":{\"@id\":\"https:\/\/atbliss.ru\/example-mysql-tables\/#primaryimage\"},\"thumbnailUrl\":\"\/\/www.blog.atbliss.ru\/wp-content\/uploads\/2009\/12\/news_tbl.png\",\"articleSection\":[\"SEO\"],\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/atbliss.ru\/example-mysql-tables\/#respond\"]}]},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/atbliss.ru\/#\/schema\/person\/f2a825e30885a03a307bafc0fe7f546a\",\"name\":\"atbliss.ru\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/atbliss.ru\/#personlogo\",\"inLanguage\":\"ru-RU\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/61034ac273e6e5c82bf4c34dfe7a3318?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/61034ac273e6e5c82bf4c34dfe7a3318?s=96&r=g\",\"caption\":\"atbliss.ru\"},\"logo\":{\"@id\":\"https:\/\/atbliss.ru\/#personlogo\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/posts\/1310"}],"collection":[{"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/comments?post=1310"}],"version-history":[{"count":0,"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/posts\/1310\/revisions"}],"wp:attachment":[{"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/media?parent=1310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/categories?post=1310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/atbliss.ru\/wp-json\/wp\/v2\/tags?post=1310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}