{"id":3056,"date":"2019-03-22T04:49:11","date_gmt":"2019-03-22T04:49:11","guid":{"rendered":"http:\/\/it.isophal.com\/?p=3056"},"modified":"2019-03-22T04:49:11","modified_gmt":"2019-03-22T04:49:11","slug":"%e1%9e%9f%e1%9f%92%e1%9e%9c%e1%9f%82%e1%9e%84%e1%9e%99%e1%9e%9b%e1%9f%8b%e1%9e%96%e1%9e%b8%e1%9e%94%e1%9f%92%e1%9e%9a%e1%9e%97%e1%9f%81%e1%9e%91%e1%9e%91%e1%9e%b7%e1%9e%93%e1%9f%92%e1%9e%93%e1%9e%93","status":"publish","type":"post","link":"https:\/\/isophal.com\/news\/2019\/03\/22\/3056.html\/","title":{"rendered":"\u179f\u17d2\u179c\u17c2\u1784\u1799\u179b\u17cb\u1796\u17b8\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17b6 String, Numeric \u1793\u17b7\u1784 Data\/Time \u1780\u17d2\u1793\u17bb\u1784 MySQL"},"content":{"rendered":"<p><strong>MySQL<\/strong> \u1782\u17ba\u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1793\u17c3 <strong>RDBMS<\/strong> \u178a\u17c2\u179b\u179b\u17d2\u17a2\u1794\u17c6\u1795\u17bb\u178f\u179f\u17c6\u179a\u17b6\u1794\u17cb\u17a2\u1797\u17b7\u179c\u178c\u17d2\u178d\u1793\u17cd\u1782\u17c1\u17a0\u1791\u17c6\u1796\u17d0\u179a\u1795\u17d2\u178f\u17c4\u178f\u1791\u17c5\u179b\u17be Software Development \u17d4 \u1796\u17b6\u1780\u17d2\u1799\u1796\u17c1\u1789\u1793\u17c3 RDBMS \u1782\u17ba <b>Relational DataBase Management System <\/b>\u178a\u17c2\u179b\u1787\u17b6 Software \u1798\u17bd\u1799\u178a\u17c2\u179b\u17a2\u17b6\u1785\u1794\u1784\u17d2\u1780\u17be\u178f\u1793\u17bc\u179c Database, table, \u1793\u17b7\u1784 indexes \u17d4 \u1799\u17c9\u17b6\u1784\u178e\u17b6\u1798\u17b7\u1789 \u1780\u17d2\u1793\u17bb\u1784\u17a2\u178f\u17d2\u1790\u1794\u1791\u1793\u17c1\u17c7 \u1793\u17b9\u1784\u1794\u1784\u17d2\u17a0\u17b6\u1789\u1796\u17b8\u1794\u17d2\u179a\u1797\u17c1\u1791\u1793\u17c3\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u178a\u17c2\u179b\u179a\u1780\u17d2\u179f\u17b6\u1791\u17bb\u1780\u1780\u17d2\u1793\u17bb\u1784 MySQL \u1780\u17d2\u1793\u17bb\u1784\u1793\u17c4\u17c7 \u1785\u17c2\u1780\u1787\u17b6 \u17e3 \u1794\u17d2\u179a\u1797\u17c1\u1791 \u1782\u17ba <strong>numeric<\/strong>, <strong>date &amp; time<\/strong> \u1793\u17b7\u1784 <strong>string<\/strong> \u17d4<\/p>\n<h1 class=\"entry-title\">\u179f\u17d2\u179c\u17c2\u1784\u1799\u179b\u17cb\u1796\u17b8\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17b6 String \u1780\u17d2\u1793\u17bb\u1784 MySQL<\/h1>\n<p>\u1794\u17d2\u179a\u1797\u17c1\u1791 \u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17b6 <strong>STRING<\/strong> \u1798\u1780\u1794\u1784\u17d2\u17a0\u17b6\u1789\u17d4 \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 \u1797\u17b6\u1782\u1785\u17d2\u179a\u17be\u1793\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 string \u178a\u17c2\u179b\u1798\u17b6\u1793 \u178a\u17bc\u1785\u1787\u17b6 <strong>VAR<\/strong>, <strong>VARCHAR<\/strong>, <strong>BINARY \u1793\u17b7\u1784 VARBINARY<\/strong>, <strong>BLOB \u17ac TEXT<\/strong>, <strong>TINYBLOB \u17ac TINYTEXT<\/strong>, <strong>MEDIUMBLOB \u17ac MEDIUMTEXT<\/strong>, <strong>LONGBLOB \u17ac LONGTEXT, SET <\/strong>\u1793\u17b7\u1784 <strong>ENUM<\/strong> \u1787\u17b6\u178a\u17be\u1798\u17d4<span id=\"more-7280\"><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3057\" src=\"http:\/\/it.isophal.com\/wp-content\/uploads\/2019\/03\/mysql_string.jpg\" alt=\"\" width=\"678\" height=\"381\" srcset=\"https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_string.jpg 678w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_string-600x337.jpg 600w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_string-300x169.jpg 300w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_string-585x329.jpg 585w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/>\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17b6 String \u179a\u17bd\u1798\u1798\u17b6\u1793\u17d6<\/p>\n<ul>\n<li><strong>VAR(M) : <\/strong>\u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u178a\u17c2\u179b\u1791\u17c6\u17a0\u17c6 STRING \u178a\u17c2\u179b\u1780\u17c6\u178e\u178f\u17cb\u178f\u17bd\u17a2\u1780\u17d2\u179f\u179a\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>\u17e0<\/strong> \u1791\u17c5 <strong>\u17e2\u17e5\u17e5<\/strong> \u178f\u17bd\u17a2\u1780\u17d2\u179f\u179a \u178a\u17c2\u179b M \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793\u178f\u17bd\u17a2\u1780\u17d2\u179f\u179a \u17d4 \u1787\u17b6\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd CHAR (\u17e5) \u1798\u17b6\u1793\u1793\u17d0\u1799\u1790\u17b6 \u17e5 \u178f\u17bd\u17a2\u1780\u17d2\u179f\u179a \u1793\u17b9\u1784\u179a\u1780\u17d2\u179f\u17b6\u1791\u17bb\u1780 \u17d4 \u1794\u17be\u1798\u17b7\u1793\u1795\u17d2\u178f\u179b\u17cb\u178f\u17c6\u179b\u17c3 M \u1791\u17c1 \u1787\u17b6 Default \u1782\u17ba \u17e1\u178f\u17bd\u17a2\u1780\u17d2\u179f\u179a \u17d4<\/li>\n<li><strong>VARCHAR(M) : <\/strong>\u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u178a\u17c2\u179b\u1791\u17c6\u17a0\u17c6 String \u178a\u17c2\u179b\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6\u17a2\u1789\u17d2\u1789\u178f\u17d2\u178f\u17b7(Variable) \u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>\u17e0<\/strong> \u1791\u17c5 <strong>\u17e6\u17e5\u17e5\u17e3\u17e5<\/strong> \u178f\u17bd\u17a2\u1780\u17d2\u179f\u179a \u178a\u17c2\u179b M \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793\u178f\u17bd\u17a2\u1780\u17d2\u179f\u179a \u17d4<strong><br \/>\n<\/strong><\/li>\n<li><strong>BINARY :<\/strong> \u179a\u1780\u17d2\u179f\u17b6\u1791\u17bb\u1780\u1793\u17bc\u179c Binary String \u178a\u17c2\u179b\u1798\u17b6\u1793\u1791\u17c6\u17a0\u17c6\u1780\u17c6\u178e\u178f\u17cb\u1798\u17bd\u1799 \u17d4 \u178f\u17c6\u179b\u17c3\u179a\u1794\u179f\u17cb\u179c\u17b6 \u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6 \u17e0x\u17e0\u17e0<strong><br \/>\n<\/strong><\/li>\n<li><strong> VARBINARY :<\/strong> \u179a\u1780\u17d2\u179f\u17b6\u1791\u17bb\u1780\u1793\u17bc\u179c\u178f\u17c6\u179b\u17c3\u1787\u17b6 Binary String \u178a\u17c2\u179b\u1798\u17b6\u1793\u1791\u17c6\u17a0\u17c6\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6 Variable \u17d4<strong><br \/>\n<\/strong><\/li>\n<li><strong>BLOB or TEXT :<\/strong> <strong>BLOB<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 binary string \u178a\u17c2\u179b\u1798\u17b6\u1793\u1791\u17c6\u17a0\u17c6\u1792\u17c6 \u178a\u17bc\u1785\u1787\u17b6 \u179a\u17bc\u1794\u1797\u17b6\u1796(Images) \u17ac\u17af\u1780\u179f\u17b6\u179a (Document)\u17d4 BLOB \u1785\u17c2\u1780\u1787\u17b6 \u17e4 \u1782\u17ba <strong>TINYBLOB<\/strong>, <strong>BLOB<\/strong>, <strong>MEDIUMBLOB<\/strong> \u1793\u17b7\u1784 <strong>LONGBLOB<\/strong> \u17d4 <strong>TEXT<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 \u1794\u17d2\u179a\u17be\u179f\u17c6\u179a\u17b6\u1794\u17cb\u179a\u1780\u17d2\u179f\u17b6\u1791\u17bb\u1780 Text \u178a\u17c2\u179b\u1798\u17b6\u1793\u1791\u17c6\u17a0\u17c6\u1792\u17c6 \u178a\u17bc\u1785\u1787\u17b6 \u17a2\u178f\u17d2\u1790\u1794\u1791 Blog, Comment \u1787\u17b6\u178a\u17be\u1798 \u17d4 \u1785\u17c6\u1796\u17c4\u17c7 TEXT \u1785\u17c2\u1780\u1787\u17b6 \u17e4 \u178a\u17c2\u179a \u1782\u17ba <strong>TINYTEXT<\/strong>, <strong>TEXT<\/strong>, <strong>MEDIUMTEXT\u00a0<\/strong> \u1793\u17b7\u1784 <strong>LONGTEXT<\/strong> \u17d4<strong><br \/>\n<\/strong><\/li>\n<li><strong>TINYBLOB or TINYTEXT :<\/strong> \u1791\u17c6\u17a0\u17c6\u17a2\u1794\u17d2\u1794\u179a\u1798\u17b6 \u17e2\u17e5\u17e5 \u178f\u17bd\u17a2\u1780\u17d2\u179f\u179a \u17d416777215<strong><br \/>\n<\/strong><\/li>\n<li><strong>MEDIUMBLOG or MEDIUMTEXT : <\/strong>\u1791\u17c6\u17a0\u17c6\u17a2\u1794\u17d2\u1794\u179a\u1798\u17b6 \u17e1\u17e6\u17e7\u17e7\u17e7\u17e2\u17e1\u17e5 \u178f\u17bd\u17a2\u1780\u17d2\u179f\u179a<strong> \u17d4<br \/>\n<\/strong><\/li>\n<li><strong>LONGBLOB or LONGTEXT : <\/strong>\u1791\u17c6\u17a0\u17c6\u17a2\u1794\u17d2\u1794\u179a\u1798\u17b6 \u17e4\u17e2\u17e9\u17e4\u17e9\u17e6\u17e7\u17e2\u17e9\u17e5 \u178f\u17bd\u17a2\u1780\u17d2\u179f\u179a \u17d4<strong><br \/>\n<\/strong><\/li>\n<li><strong>ENUM :<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u179a\u1780\u17d2\u179f\u17b6\u1791\u17bb\u1780\u1793\u17bc\u179c string object \u178a\u17c2\u179b\u1794\u17b6\u1793\u1780\u17c6\u178e\u178f\u17cb\u178f\u17c6\u179b\u17c3\u1780\u17d2\u1793\u1784 \u1794\u1789\u17d2\u1787\u17b8(List) \u1798\u17bd\u1799\u17d4 \u1799\u17be\u1784\u17a2\u17b6\u1785\u1794\u1789\u17d2\u1785\u17bc\u179b\u178f\u17c6\u179b\u17c3\u17b2\u17d2\u1799\u1794\u17b6\u1793\u17d4 \u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u00a0 mysql&gt; CREATE TABLE SizeTable(Size ENUM(\u2018S\u2019, \u2018M\u2019, \u2018L\u2019, \u2018XL\u2019, \u2018XXL\u2019));<\/li>\n<li><strong>SET :<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u179a\u1780\u17d2\u179f\u17b6\u1791\u17bb\u1780\u1793\u17bc\u179c string object \u178a\u17c2\u179b\u1794\u17b6\u1793\u1780\u17c6\u178e\u178f\u17cb\u178f\u17c6\u179b\u17c3\u1780\u17d2\u1793\u1784 \u1794\u1789\u17d2\u1787\u17b8(List) \u1798\u17bd\u1799 \u178a\u17c2\u179b\u178f\u17c6\u179b\u17c3\u179a\u1794\u179f\u17cb\u179c\u17b6 \u17a2\u17b6\u1785\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3 \u179f\u17bc\u1793\u17d2\u1799 \u17ac \u1785\u17d2\u179a\u17be\u1793\u17d4 \u179c\u17b6\u178a\u17bc\u1785\u1791\u17c5\u1793\u17b9\u1784 ENUM \u178a\u17c2\u179a \u1781\u17bb\u179f\u1782\u17d2\u1793\u17b6\u178f\u17d2\u179a\u1784\u17cb \u179a\u1780\u17d2\u179f\u17b6\u178f\u17c6\u179b\u17c3\u179f\u17bc\u1793\u17d2\u1799 \u17ac\u1785\u17d2\u179a\u17be\u1793 \u1780\u17d2\u1793\u17bb\u1784\u1794\u1789\u17d2\u1787\u17b8(List) \u178a\u17c2\u179b\u1794\u17b6\u1793\u1780\u17c6\u178e\u178f\u17cb \u17d4<\/li>\n<\/ul>\n<h1 class=\"entry-title\">\u179f\u17d2\u179c\u17c2\u1784\u1799\u179b\u17cb\u1796\u17b8\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17b6 Numeric \u1780\u17d2\u1793\u17bb\u1784 MySQL<\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3058\" src=\"http:\/\/it.isophal.com\/wp-content\/uploads\/2019\/03\/mysql_numeric.jpg\" alt=\"\" width=\"678\" height=\"381\" srcset=\"https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_numeric.jpg 678w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_numeric-600x337.jpg 600w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_numeric-300x169.jpg 300w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_numeric-585x329.jpg 585w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/>\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 Numeric \u1785\u17c2\u1780\u1787\u17b6 \u17e2\u1795\u17d2\u1793\u17c2\u1780 \u1782\u17ba \u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1787\u17b6\u1780\u17cb\u1787\u17b6\u1780\u17cb (<strong>exact numeric data<\/strong>) \u1793\u17b7\u1784\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 \u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1794\u17d2\u179a\u17a0\u17b6\u1780\u17cb\u1794\u17d2\u179a\u17a0\u17c2\u179b (<strong>approximate numeric data<\/strong>) \u17d4<\/p>\n<p>\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1787\u17b6\u1780\u17cb\u1787\u17b6\u1780\u17cb (exact numeric data) \u179a\u17bd\u1798\u1798\u17b6\u1793\u17d6<\/p>\n<ul>\n<li><strong>TINYINT :<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1793\u17c3 Integer (\u1785\u17c6\u1793\u17bd\u1793\u1782\u178f\u17cb) \u1798\u17b6\u1793\u1785\u17c6\u1793\u17bd\u1793\u178f\u17b7\u1785\u1787\u17b6\u1784\u1782\u17c1\u1794\u17c6\u1795\u17bb\u178f \u178a\u17c2\u179b\u1791\u17c6\u17a0\u17c6\u1795\u17d2\u1791\u17bb\u1780\u178f\u17c2 <strong>\u17e1 Byte<\/strong> \u1794\u17c9\u17bb\u178e\u17d2\u178e\u17c4\u17c7 \u1793\u17b7\u1784 \u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3 \u1785\u1793\u17d2\u179b\u17c4\u17c7 \u2013<strong>\u17e1\u17e2\u17e8<\/strong> \u1791\u17c5 <strong>\u17e1\u17e2\u17e7<\/strong> \u17d4 \u1794\u17be\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6 Unsigned \u1782\u17ba\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8<strong> \u17e0<\/strong> \u1791\u17c5 <strong>\u17e2\u17e5\u17e5<\/strong> \u17d4<\/li>\n<li><strong>SMALLINT :<\/strong>\u00a0 \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1793\u17c3 Integer (\u1785\u17c6\u1793\u17bd\u1793\u1782\u178f\u17cb) \u178a\u17c2\u179b\u1795\u17d2\u1791\u17bb\u1780 <strong>\u17e2 Byte<\/strong> \u178a\u17c2\u179b\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>-\u17e3\u17e2\u17e7\u17e6\u17e8<\/strong> \u1791\u17c5 <strong>\u17e3\u17e2\u17e7\u17e6\u17e7<\/strong> \u17d4 \u1794\u17be\u1787\u17b6 Unsigned \u1782\u17ba\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8 <strong>\u17e0<\/strong> \u1791\u17c5 <strong>\u17e6\u17e5\u17e5\u17e3\u17e5<\/strong> \u17d4<\/li>\n<li><strong>MEDIUMINT :<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1793\u17c3 Integer (\u1785\u17c6\u1793\u17bd\u1793\u1782\u178f\u17cb) \u178a\u17c2\u179b\u1795\u17d2\u1791\u17bb\u1780 <strong>\u17e3 Byte<\/strong> \u178a\u17c2\u179b\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>-\u17e8\u17e3\u17e8\u17e8\u17e6\u17e0\u17e8<\/strong> \u1791\u17c5 <strong>\u17e8\u17e3\u17e8\u17e8\u17e6\u17e0\u17e7<\/strong> \u17d4 \u1794\u17be\u1787\u17b6 Unsigned \u1782\u17ba\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8 <strong>\u17e0<\/strong> \u1791\u17c5 <strong>\u17e1\u17e6\u17e7\u17e7\u17e7\u17e2\u17e1\u17e5<\/strong> \u17d4<\/li>\n<li><strong>INT :<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1793\u17c3 Integer (\u1785\u17c6\u1793\u17bd\u1793\u1782\u178f\u17cb) \u178a\u17c2\u179b\u1795\u17d2\u1791\u17bb\u1780<strong> \u17e4 Byte<\/strong> \u178a\u17c2\u179b\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>-\u17e2\u17e1\u17e4\u17e7\u17e4\u17e8\u17e3\u17e6\u17e4\u17e8<\/strong> \u1791\u17c5 <strong>\u17e2\u17e1\u17e4\u17e7\u17e4\u17e8\u17e3\u17e6\u17e4\u17e7<\/strong> \u17d4 \u1794\u17be\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6 Unsigned \u1782\u17ba\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8 <strong>\u17e0<\/strong> \u1791\u17c5 <strong>\u17e4\u17e2\u17e9\u17e4\u17e9\u17e6\u17e7\u17e2\u17e9\u17e5<\/strong>\u17d4<\/li>\n<li><strong>BIGINT :<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1793\u17c3 Integer (\u1785\u17c6\u1793\u17bd\u1793\u1782\u178f\u17cb) \u1798\u17b6\u1793\u1785\u17c6\u1793\u17bd\u1793\u1785\u17d2\u179a\u17be\u1793\u1787\u17b6\u1784\u1782\u17c1\u1794\u17c6\u1795\u17bb\u178f \u178a\u17c2\u179b\u1795\u17d2\u1791\u17bb\u1780 <strong>\u17e8 Byte<\/strong> \u178a\u17c2\u179b\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>-\u17e9\u17e2\u17e2\u17e3\u17e3\u17e7\u17e2\u17e0\u17e3\u17e6\u17e8\u17e5\u17e4\u17e7\u17e7\u17e5\u17e8\u17e0\u17e8<\/strong> \u1791\u17c5 <strong>\u17e9\u17e2\u17e2\u17e3\u17e3\u17e7\u17e2\u17e0\u17e3\u17e6\u17e8\u17e5\u17e4\u17e7\u17e7\u17e5\u17e8\u17e0\u17e7<\/strong> \u17d4 \u1794\u17be\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6 Unsigned \u1782\u17ba\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8 \u17e0 \u1791\u17c5<strong> \u17e1\u17e8\u17e4\u17e4\u17e6\u17e7\u17e4\u17e4\u17e0\u17e7\u17e3\u17e7\u17e0\u17e9\u17e5\u17e5\u17e1\u17e6\u17e1\u17e5<\/strong>\u17d4<\/li>\n<\/ul>\n<p>\u1794\u1793\u17d2\u1790\u17c2\u1798\u179b\u17be\u179f\u1796\u17b8\u1793\u17c1\u17c7 \u1780\u17cf\u1798\u17b6\u1793\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1787\u17b6\u1780\u17cb\u179b\u17b6\u1780\u17cb \u1795\u17d2\u179f\u17c1\u1784\u1791\u17c0\u178f\u178a\u17c2\u179a \u1782\u17ba <strong>Decimal<\/strong> \u1793\u17b7\u1784 <strong>Numeric<\/strong> \u17d4<\/p>\n<ul>\n<li><strong>DECIMAL(M, D) :<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1785\u17c6\u1793\u17bd\u1793\u1791\u179f\u1797\u17b6\u1782 \u1782\u17c4\u179b \u17e1\u17e0 \u178a\u17c2\u179b\u1798\u17b6\u1793\u1780\u17d2\u1794\u17c0\u179f\u1796\u17b8\u1780\u17d2\u179a\u17c4\u1799 \u17d4 \u178f\u17c6\u179b\u17c3 \u179a\u1794\u179f\u17cb Decimal \u1798\u17b7\u1793\u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793 Unsigned \u17a1\u17be\u1799 \u1796\u17c4\u179b\u1782\u17ba \u1785\u17c6\u1793\u17bd\u1793\u1791\u179f\u1797\u17b6\u1782\u179c\u17b7\u1787\u17d2\u1787\u1798\u17b6\u1793 \u17d4 M \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793\u1791\u17c6\u17a0\u17c6 digit \u1793\u17b7\u1784 D \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793 digit \u1780\u17d2\u179a\u17c4\u1799\u1780\u17d2\u1794\u17c0\u179f \u17d4<\/li>\n<li><strong>Numeric<\/strong> \u1787\u17b6<strong>\u179f\u1791\u17b7\u179f\u1793\u17d0\u1799 <\/strong>\u179a\u1794\u179f\u17cb DECIMAL \u1798\u17b6\u1793\u1793\u17d0\u1799\u1790\u17b6 \u178a\u17bc\u1785\u1782\u17d2\u1793\u17b6\u1793\u17b9\u1784 DECIMAL \u178a\u17c2\u179a\u17d4<\/li>\n<\/ul>\n<p>\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 \u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1794\u17d2\u179a\u17a0\u17b6\u1780\u17cb\u1794\u17d2\u179a\u17a0\u17c2\u179b (approximate numeric data) \u179a\u17bd\u1798\u1798\u17b6\u1793\u17d6<\/p>\n<ul>\n<li><strong>FLOAT(M, D) :<\/strong> \u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 \u1785\u17c6\u1793\u17bd\u1793\u1791\u179f\u1797\u17b6\u1782 \u178a\u17c2\u179b\u1798\u17b7\u1793\u17a2\u17b6\u1785 <strong>Unsigned<\/strong> \u1794\u17b6\u1793 \u1798\u17b6\u1793\u1793\u17cf\u1799\u1790\u17b6 \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793\u1791\u179f\u1797\u17b6\u1782\u179c\u17b7\u1787\u17d2\u1787\u1798\u17b6\u1793 \u17d4 M \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793\u1791\u17c6\u17a0\u17c6 digit \u1793\u17b7\u1784 D \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793 digit \u1780\u17d2\u179a\u17c4\u1799\u1780\u17d2\u1794\u17c0\u179f \u17d4 \u1794\u17be\u1798\u17b7\u1793\u1780\u17c6\u178e\u178f\u17cb\u17b2\u17d2\u1799\u1791\u17c1 \u179c\u17b6\u1799\u1780 Default \u1782\u17ba <strong>Float(\u17e1\u17e0,\u17e2) <\/strong>\u17d4<\/li>\n<li><strong>DOUBLE(M, D) :<\/strong> \u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 \u1785\u17c6\u1793\u17bd\u1793\u1791\u179f\u1797\u17b6\u1782 \u1792\u17c6\u1791\u17d2\u179c\u17c1\u178a\u1784 \u178a\u17c2\u179b\u1798\u17b7\u1793\u17a2\u17b6\u1785 <strong>Unsigned<\/strong> \u1794\u17b6\u1793 \u1798\u17b6\u1793\u1793\u17cf\u1799\u1790\u17b6 \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793\u1791\u179f\u1797\u17b6\u1782\u179c\u17b7\u1787\u17d2\u1787\u1798\u17b6\u1793 \u17d4 M \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793\u1791\u17c6\u17a0\u17c6 digit \u1793\u17b7\u1784 D \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793 digit \u1780\u17d2\u179a\u17c4\u1799\u1780\u17d2\u1794\u17c0\u179f \u17d4 \u1794\u17be\u1798\u17b7\u1793\u1780\u17c6\u178e\u178f\u17cb\u17b2\u17d2\u1799\u1791\u17c1 \u179c\u17b6\u1799\u1780 Default \u1782\u17ba <strong>Double(\u17e1\u17e6,\u17e4)<\/strong> \u17d4<\/li>\n<li><strong>REAL(<em>m<\/em>,<em>d<\/em>)<\/strong> \u1787\u17b6<strong>\u179f\u1791\u17b7\u179f\u1793\u17d0\u1799<\/strong> \u179a\u1794\u179f\u17cb DOUBLE \u1798\u17b6\u1793\u1793\u17d0\u1799\u1790\u17b6 \u178a\u17bc\u1785\u1782\u17d2\u1793\u17b6\u1793\u17b9\u1784 DOUBLE \u178a\u17c2\u179a \u17d4<\/li>\n<\/ul>\n<h1 class=\"entry-title\">\u179f\u17d2\u179c\u17c2\u1784\u1799\u179b\u17cb\u1796\u17b8\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17b6 Date\/Time \u1780\u17d2\u1793\u17bb\u1784 MySQL<\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3059\" src=\"http:\/\/it.isophal.com\/wp-content\/uploads\/2019\/03\/mysql_date_time.jpg\" alt=\"\" width=\"678\" height=\"381\" srcset=\"https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_date_time.jpg 678w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_date_time-600x337.jpg 600w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_date_time-300x169.jpg 300w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_date_time-585x329.jpg 585w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/>\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 Date\/Time \u178f\u17c6\u178e\u17b6\u1784\u17b2\u17d2\u1799\u178f\u17c6\u179b\u17c3\u1794\u178e\u17d2\u178f\u17c4\u17c7\u17a2\u17b6\u179f\u1793\u17d2\u1793\u1793\u17c3 <strong>DATE<\/strong>, <strong>TIME<\/strong>, <strong>DATETIME<\/strong>, <strong>TIMESTAMP<\/strong> \u1793\u17b7\u1784 <strong>YEAR<\/strong> \u178a\u17c2\u179b\u178f\u17c6\u179b\u17c3\u1791\u17b6\u17c6\u1784\u1793\u17c4\u17c7 \u178f\u17d2\u179a\u17bc\u179c\u178f\u17c2\u179f\u17d2\u1790\u17b7\u178f\u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1793\u17c3\u178f\u17c6\u179b\u17c3\u1798\u17b6\u1793\u179f\u17bb\u1796\u179b\u1797\u17b6\u1796 \u17d4 \u178f\u17c6\u179b\u17c3\u179f\u17bc\u1793\u17d2\u1799 (\u17e0) \u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u178f\u17c6\u178e\u17b6\u1784\u17b2\u17d2\u1799\u178f\u17c6\u179b\u17c3\u1798\u17b7\u1793\u1798\u17b6\u1793\u179f\u17bb\u1796\u179b\u1797\u17b6\u1796 (Invalid Value) \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 MySQL \u17d4<span id=\"more-7273\"><\/span><\/p>\n<p>\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 MySQL \u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17b6 Date\/Time \u1791\u1791\u17bd\u179b\u1799\u1780\u1791\u17c6\u179a\u1784\u17cb Format \u1787\u17b6\u179f\u17d2\u178f\u1784\u17cb\u178a\u17b6\u1793\u17c3\u1780\u17b6\u179a\u1794\u1784\u17d2\u17a0\u17b6\u1789\u1785\u17c1\u1789\u1798\u1780\u1780\u17d2\u179a\u17c5 \u178a\u17c4\u1799\u1795\u17d2\u178f\u17c4\u178f \u1791\u17c5\u179b\u17be\u1780\u17b6\u179a\u1794\u1789\u17d2\u1785\u17bc\u179b\u178f\u17c6\u179b\u17c3 \u17d4 \u1799\u17c9\u17b6\u1784\u178e\u17b6\u1798\u17b7\u1789 \u178f\u17c6\u179b\u17c3 Date\/Time \u1793\u17b9\u1784\u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1782\u17c1\u1794\u1780\u1794\u17d2\u179a\u17c2\u1787\u17b6 \u178f\u17c6\u179b\u17c3\u1798\u17bd\u1799\u179f\u1798\u179f\u17d2\u179a\u1794\u178f\u17b6\u1798\u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb (Format) \u1780\u17d2\u1793\u17bb\u1784 MySQL \u17d4<\/p>\n<p>MySQL \u1794\u17b6\u1793\u1780\u17c6\u178e\u178f\u17cb \u17e2 digits \u1793\u17c3\u178f\u17c6\u179b\u17c3\u179a\u1794\u179f\u17cb\u1786\u17d2\u1793\u17b6\u17c6 (year) \u179f\u17d2\u179a\u1794\u1791\u17c5\u178f\u17b6\u1798\u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb\u178a\u17bc\u1785\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798\u17d6<\/p>\n<ul>\n<li>\u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>\u17e7\u17e0<\/strong> \u1791\u17c5 <strong>\u17e9\u17e9<\/strong> \u1793\u17b9\u1784\u178f\u17d2\u179a\u17bc\u179c\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6\u1786\u17d2\u1793\u17b6\u17c6 \u1780\u17d2\u1793\u17bb\u1784\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>\u17e1\u17e9\u17e7\u17e0<\/strong> \u178a\u179b\u17cb <strong>\u17e1\u17e9\u17e9\u17e9<\/strong><\/li>\n<li>\u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>\u17e0\u17e0<\/strong> \u1791\u17c5 <strong>\u17e6\u17e9<\/strong> \u1793\u17b9\u1784\u178f\u17d2\u179a\u17bc\u179c\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6\u1786\u17d2\u1793\u17b6\u17c6 \u1780\u17d2\u1793\u17bb\u1784\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>\u17e2\u17e0\u17e0\u17e0<\/strong> \u178a\u179b\u17cb <strong>\u17e2\u17e0\u17e6\u17e9<\/strong><\/li>\n<\/ul>\n<p>\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799 Date\/Time\u00a0 \u1798\u17b6\u1793\u178a\u17bc\u1785\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798\u17d6<\/p>\n<ul>\n<li><strong>DATE<\/strong> : \u1791\u17c6\u179a\u1784\u17cb Format \u1787\u17b6 <strong>YYYY-MM-DD<\/strong> \u179f\u17d2\u1790\u17b7\u178f\u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>\u17e1\u17e0\u17e0\u17e0-\u17e0\u17e1-\u17e0\u17e1<\/strong> \u1791\u17c5 <strong>\u17e9\u17e9\u17e9\u17e9-\u17e1\u17e2-\u17e3\u17e1<\/strong> \u17d4 \u1787\u17b6\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd \u1790\u17d2\u1784\u17c3\u1791\u17b8 \u17e0\u17e1 \u1781\u17c2\u1798\u17c1\u179f\u17b6 \u1786\u17d2\u1793\u17b6\u17c6 \u17e1\u17e9\u17e8\u17e9 \u1793\u17b9\u1784\u178f\u17d2\u179a\u17bc\u179c\u1794\u17c6\u179b\u17c2\u1784\u1791\u17c5\u1787\u17b6 \u17e1\u17e9\u17e8\u17e9-\u17e0\u17e4-\u17e0\u17e1 \u17d4 \u178f\u17c6\u179b\u17c3\u179f\u17bc\u1793\u17d2\u1799 (\u17e0) \u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6 \u2018<strong>\u17e0\u17e0\u17e0\u17e0-\u17e0\u17e0-\u17e0\u17e0<\/strong>\u2018 \u17d4<\/li>\n<li><strong>TIME<\/strong> : \u1791\u17c6\u179a\u1784\u17cb Format \u1787\u17b6 <strong>HH:MM:SS<\/strong> \u17d4 \u1787\u17b6\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd \u1798\u17c9\u17c4\u1784 \u17e6 \u1793\u17b7\u1784 \u17e5\u17e0\u1793\u17b6\u1791\u17b8 \u178f\u17d2\u179a\u17bc\u179c\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6 \u17e0\u17e6:\u17e5\u17e0:\u17e0\u17e0 \u17d4 \u178f\u17c6\u179b\u17c3\u179f\u17bc\u1793\u17d2\u1799 (\u17e0) \u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6 \u2018<strong>\u17e0\u17e0:\u17e0\u17e0:\u17e0\u17e0<\/strong>\u2018 \u17d4<\/li>\n<li><strong>DATETIME<\/strong> : \u1791\u17c6\u179a\u1784\u17cb Format \u1787\u17b6 <strong>YYYY-MM-DD HH:SS:MM<\/strong> \u179f\u17d2\u1790\u17b7\u178f\u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7<strong> \u17e1\u17e0\u17e0\u17e0-\u17e0\u17e1-\u17e0\u17e1\u00a0 \u17e0\u17e0:\u17e0\u17e0:\u17e0\u17e0<\/strong> \u1791\u17c5 <strong>\u17e9\u17e9\u17e9\u17e9-\u17e1\u17e2-\u17e3\u17e1<\/strong> <strong>\u17e2\u17e3:\u17e5\u17e9:\u17e5\u17e9<\/strong> \u17d4 \u1787\u17b6\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd \u1790\u17d2\u1784\u17c3\u1791\u17b8 \u17e0\u17e1 \u1781\u17c2\u1798\u17c1\u179f\u17b6 \u1786\u17d2\u1793\u17b6\u17c6 \u17e1\u17e9\u17e8\u17e9 \u1798\u17c9\u17c4\u1784 \u17e6 \u1793\u17b7\u1784 \u17e5\u17e0\u1793\u17b6\u1791\u17b8 \u178f\u17d2\u179a\u17bc\u179c\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6 \u17e1\u17e9\u17e8\u17e9-\u17e0\u17e4-\u17e0\u17e1 \u17e0\u17e6:\u17e5\u17e0:\u17e0\u17e0 \u17d4 \u178f\u17c6\u179b\u17c3\u179f\u17bc\u1793\u17d2\u1799 (\u17e0) \u178f\u17d2\u179a\u17bc\u179c\u1780\u17c6\u178e\u178f\u17cb\u1787\u17b6 \u2018<strong>\u17e0\u17e0\u17e0\u17e0-\u17e0\u17e0-\u17e0\u17e0 \u17e0\u17e0:\u17e0\u17e0:\u17e0<\/strong>\u17e0\u2019 \u17d4<\/li>\n<li><strong>TIMESTAMP<\/strong> : \u1791\u17c6\u179a\u1784\u17cb Format \u178a\u17bc\u1785\u1791\u17c5\u1793\u17b9\u1784 DATETIME \u178a\u17c2\u179a \u1782\u17d2\u179a\u17b6\u1793\u17cb\u178f\u17c2\u179c\u17b6\u179f\u17d2\u1790\u17b7\u178f\u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>\u17e1\u17e9\u17e7\u17e0-\u17e0\u17e1-\u17e0\u17e1 \u17e0\u17e0:\u17e0\u17e0:\u17e0\u17e1 UTC\u00a0<\/strong> \u1791\u17c5 <strong>\u17e2\u17e0\u17e3\u17e8-\u17e0\u17e1-\u17e1\u17e9 \u17e0\u17e3:\u17e1\u17e4:\u17e0\u17e7 UTC<\/strong> \u1798\u17b6\u1793\u1793\u17d0\u1799\u1790\u17b6 MySQL \u1793\u17b9\u1784\u1794\u17c6\u179b\u17c2\u1784\u178f\u17c6\u179b\u17c3 TIMESTAMP \u1796\u17b8 Time Zone\u00a0 \u1791\u17c5 UTC \u1793\u17b7\u1784\u1796\u17b8 UTC \u1798\u1780 Time Zone \u179c\u17b7\u1789 \u17d4<\/li>\n<li><strong>YEAR (M)<\/strong>: \u1780\u17c6\u178e\u178f\u17cb\u1799\u1780 \u17e2 \u17ac \u17e4 digits \u1793\u17c3\u1786\u17d2\u1793\u17b6\u17c6 \u17d4 \u1794\u17be \u17e2 digits \u1786\u17d2\u1793\u17b6\u17c6\u17a2\u17b6\u1785\u179f\u17d2\u1790\u17b7\u178f\u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>\u17e1\u17e9\u17e7\u17e0<\/strong> \u178a\u179b\u17cb \u17e2\u17e0\u17e6\u17e9 \u17a0\u17be\u1799\u1794\u17be \u17e4 digits \u1786\u17d2\u1793\u17b6\u17c6\u17a2\u17b6\u1785\u179f\u17d2\u1790\u17b7\u178f\u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7 <strong>\u17e1\u17e9\u17e0\u17e1<\/strong> \u178a\u179b\u17cb <strong>\u17e2\u17e1\u17e5\u17e5<\/strong> \u17d4<\/li>\n<\/ul>\n<h1 class=\"entry-title\">\u179f\u17d2\u179c\u17c2\u1784\u1799\u179b\u17cb\u1796\u17b8\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17b6 Spatial \u1780\u17d2\u1793\u17bb\u1784 MySQL<\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3061\" src=\"http:\/\/it.isophal.com\/wp-content\/uploads\/2019\/03\/mysql_data_spatial-2.jpg\" alt=\"\" width=\"678\" height=\"381\" srcset=\"https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_data_spatial-2.jpg 678w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_data_spatial-2-600x337.jpg 600w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_data_spatial-2-300x169.jpg 300w, https:\/\/isophal.com\/news\/wp-content\/uploads\/2019\/03\/mysql_data_spatial-2-585x329.jpg 585w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/p>\n<p>\u1793\u17c5\u1798\u17b6\u1793\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1796\u17b7\u179f\u17c1\u179f\u1798\u17bd\u1799\u1791\u17c0\u178f \u1780\u17d2\u1793\u17bb\u1784 MySQL \u1782\u17ba<strong> SPATIAL DATA TYPE<\/strong> \u17d4 \u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1793\u17c1\u17c7 \u1791\u17b6\u1780\u17cb\u1791\u1784\u1791\u17c5\u1793\u17b9\u1784 <a href=\"http:\/\/www.opengis.ch\/\"><strong>OpenGIS<\/strong><\/a> \u178a\u17c2\u179b\u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1798\u17b6\u1793\u178f\u17c6\u179b\u17c3\u1787\u17b6\u1792\u179a\u178e\u17b8\u1798\u17b6\u178f\u17d2\u179a \u178a\u17bc\u1785\u1787\u17b6 <strong>GEOMETRY<\/strong>, <strong>POINT<\/strong>, <strong>LINESTRING<\/strong>, \u1793\u17b7\u1784 <strong>POLYGON<\/strong> \u17d4<span id=\"more-7276\"><\/span><\/p>\n<p><strong>GEOMETRY<\/strong> \u17a2\u17b6\u1785\u179a\u1780\u17d2\u179f\u17b6\u1791\u17bb\u1780\u1793\u17bc\u179c\u1794\u17d2\u179a\u1797\u17c1\u1791\u1787\u17b6\u1785\u17d2\u179a\u17be\u1793\u1793\u17c3\u178f\u17c6\u179b\u17c3\u1787\u17b6\u1792\u179a\u178e\u17b8\u1798\u17b6\u178f\u17d2\u179a \u178a\u17c2\u179b\u1794\u17d2\u179a\u17be\u1780\u17d2\u1793\u17bb\u1784\u1795\u17c2\u1793\u1791\u17b8 \u1780\u17d2\u1793\u17bb\u1784\u1796\u17b7\u1797\u1796\u179b\u17c4\u1780 \u17d5 \u1785\u17c6\u178e\u17c2\u1780\u1780\u17d2\u1793\u17bb\u1784 MySQL \u1782\u17c1\u17a2\u17b6\u1785\u1794\u1784\u17d2\u1780\u17be\u178f \u178f\u17b6\u179a\u17b6\u1784 (table) \u178a\u17c2\u179b\u179a\u1780\u17d2\u179f\u17b6\u1791\u17bb\u1780\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791 GEOMETRY \u1794\u17b6\u1793 \u17d4<\/p>\n<p>\u1787\u17b6\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u17d6 <strong>CREATE TABLE tbl_geometry (code (5),\u00a0 description varchar(255), geomtry GEOMETRY)<\/strong><\/p>\n<p><strong>POINT<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1780\u17c6\u178e\u178f\u17cb\u1793\u17bc\u179c\u1797\u17bc\u1798\u17b7\u179f\u17b6\u179f\u17d2\u178f\u17d2\u179a \u178a\u17c2\u179b\u178f\u17c6\u178e\u17b6\u1784\u17b2\u17d2\u1799\u1791\u17b8\u178f\u17b6\u17c6\u1784\u178f\u17c2\u1798\u17bd\u1799\u1782\u178f\u17cb \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u179b\u17c6\u17a0 \u17d4 \u1797\u17b6\u1782\u1785\u17d2\u179a\u17be\u1793 \u1782\u17c1\u1794\u17d2\u179a\u17be <strong>POINT<\/strong> \u178a\u17be\u1798\u17d2\u1794\u17b8\u1780\u17c6\u178e\u178f\u17cb\u1791\u17b8\u178f\u17b6\u17c6\u1784 \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1795\u17c2\u1793\u1791\u17b8\u1791\u17b8\u1780\u17d2\u179a\u17bb\u1784\u1798\u17bd\u1799 \u17ac\u178f\u17c6\u1794\u1793\u17cb\u1798\u17bd\u1799 \u17ac\u1791\u17b8\u1780\u1793\u17d2\u179b\u17c2\u1784\u1798\u17bd\u1799\u178a\u17bc\u1785\u1787\u17b6 \u179f\u17d2\u1790\u17b6\u1793\u17b8\u1799\u17cd\u179a\u1790\u1797\u17d2\u179b\u17be\u1784 \u17ac\u17a2\u17b6\u1780\u17b6\u179f\u1799\u17b6\u1793\u178a\u17d2\u178b\u17b6\u1793 \u1787\u17b6\u178a\u17be\u1798 \u17d4<\/p>\n<p>\u1787\u17b6\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd\u1780\u17d2\u1793\u17bb\u1784 MySQL : <strong>SELECT Y(POINT(25, 56));<\/strong><\/p>\n<p><strong>LINESTRING<\/strong> \u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1791\u17b7\u1793\u17d2\u1793\u1793\u17d0\u1799\u1798\u17bd\u1799\u178a\u17c2\u179b\u1780\u17be\u178f\u1785\u17c1\u1789\u1796\u17b8\u1785\u17c6\u1793\u17bb\u1785\u178f\u17bc\u1785 (POINT) \u1794\u1784\u17d2\u1780\u17be\u178f\u1787\u17b6\u1781\u17d2\u179f\u17c2\u1780\u17c4\u1784\u1798\u17bd\u1799\u17d4\u00a0 \u1782\u17c1\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb <strong>LINESTRING Object<\/strong> \u1792\u17d2\u179c\u17be\u1787\u17b6\u1781\u17d2\u179f\u17c2\u1794\u1793\u17d2\u1791\u17b6\u178f\u17cb \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1795\u17c2\u1793\u1791\u17b8\u1796\u17b7\u1797\u1796\u179b\u17c4\u1780 \u178f\u17c6\u178e\u17b6\u1784\u17b2\u17d2\u1799\u1791\u1793\u17d2\u179b\u17c1 \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1795\u17c2\u1793\u1791\u17b8\u1791\u17b8\u1780\u17d2\u179a\u17bb\u1784 \u178f\u17c6\u178e\u17b6\u1784\u17b2\u17d2\u1799 \u1795\u17d2\u179b\u17bc\u179c \u17d4<\/p>\n<p><strong>POLYGON<\/strong> \u1787\u17b6\u1795\u17d2\u1791\u17c3\u1794\u17d2\u179b\u1784\u17cb \u178f\u17c6\u178e\u17b6\u1784\u17b2\u17d2\u1799\u1791\u17b8\u178f\u17b6\u17c6\u1784\u1797\u17bc\u1798\u17b7\u179f\u17b6\u179f\u17d2\u178f\u17d2\u179a\u179a\u17bd\u1798 \u178a\u17c2\u179b\u1780\u17c6\u178e\u178f\u17cb\u178a\u17c4\u1799\u1796\u17d2\u179a\u17c6\u178a\u17c2\u1793\u1795\u17d2\u1793\u17c2\u1780\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c5\u178f\u17c2\u1798\u17bd\u1799 \u17ac\u1785\u17d2\u179a\u17be\u1793 \u178a\u17c2\u179b\u1782\u17d2\u179a\u1794\u17cb\u1795\u17d2\u1793\u17c2\u1780\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c5\u1793\u17b7\u1798\u17bd\u1799\u17d7 \u1797\u17d2\u1787\u17b6\u1794\u17cb\u1782\u17d2\u1793\u17b6\u178a\u17c4\u1799\u1794\u17d2\u179a\u17a0\u17c4\u1784\u1798\u17bd\u1799\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 <strong>POLYGON<\/strong> \u17d4 \u1782\u17c1\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb <strong>POLYGON<\/strong> \u178f\u17c6\u178e\u17b6\u1784\u17b2\u17d2\u1799\u1791\u1793\u17d2\u179b\u17c1\u1798\u17bd\u17bd\u1799 \u1780\u17d2\u1793\u17bb\u1784\u1795\u17c2\u1793\u1791\u17b8\u1794\u17d2\u179a\u1791\u17c1\u179f \u17d4<\/p>\n<p><strong>MULTIPOINT<\/strong> \u1787\u17b6\u1794\u178e\u17d2\u178f\u17bb\u17c6\u1793\u17c3 <strong>Geometry<\/strong> \u1794\u1784\u17d2\u1780\u17be\u178f\u178a\u17c4\u1799\u1785\u17c6\u1793\u17bb\u1785\u1787\u17b6\u1785\u17d2\u179a\u17be\u1793 \u178a\u17c2\u179b\u1798\u17b7\u1793\u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1797\u17d2\u1787\u17b6\u1794\u17cb\u1782\u17d2\u1793\u17b6 \u17d4 \u1782\u17c1\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u179c\u17b6 \u178f\u17c6\u178e\u17b6\u1784\u17b2\u17d2\u1799\u1781\u17d2\u179f\u17c2\u1785\u1784\u17d2\u179c\u17b6\u1780\u17cb\u1793\u17c3\u1780\u17c4\u17c7\u178f\u17bc\u1785\u17d7 \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1795\u17c2\u1793\u1791\u17b8\u1796\u17b7\u1797\u1796\u179b\u17c4\u1780 \u17d4<\/p>\n<p><strong>MULTILINESTRING<\/strong> \u1787\u17b6\u1794\u178e\u17d2\u178f\u17bb\u17c6\u1793\u17c3 \u1781\u17d2\u179f\u17c2\u1780\u17c4\u1784 \u1797\u17bc\u1798\u17b7\u179f\u17b6\u179f\u17d2\u178f\u17d2\u179a \u178a\u17c2\u179b\u1794\u1784\u17d2\u1780\u17be\u178f\u178a\u17c4\u1799 <strong>LINESTRING<\/strong> \u1787\u17b6\u1785\u17d2\u179a\u17be\u1793 \u17d4 \u1782\u17c1\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u179c\u17b6 \u178f\u17c6\u178e\u17b6\u1784\u17b2\u17d2\u1799 \u1794\u17d2\u179a\u1796\u17d0\u1793\u17d2\u1792\u1793\u17c3\u1791\u1793\u17d2\u179b\u17c1 \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1795\u17c2\u1793\u1791\u17b8\u178f\u17c6\u1794\u1793\u17cb\u1798\u17bd\u1799 \u17d4<\/p>\n<p><strong>MULTIPOLYGON<\/strong> \u1787\u17b6\u1794\u178e\u17d2\u178f\u17bb\u17c6\u1793\u17c3\u1795\u17d2\u1791\u17c3\u1794\u17d2\u179b\u1784\u17cb \u178a\u17c2\u179b\u1794\u1784\u17d2\u1780\u17be\u178f\u178a\u17c4\u1799 <strong>POLYGON<\/strong> \u17d4 \u1782\u17c1\u1794\u17d2\u179a\u17be\u1794\u17d2\u179a\u17b6\u179f\u17cb\u179c\u17b6 \u178f\u17c6\u178e\u17b6\u1784\u17b2\u17d2\u1799\u1794\u17d2\u179a\u1796\u17d0\u1793\u17d2\u1792\u1793\u17c3\u1794\u17b9\u1784\u1794\u17bd\u179a \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1795\u17c2\u1793\u1791\u17b8\u178f\u17c6\u1794\u1793\u17cb\u1798\u17bd\u1799 \u17d4<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \u1782\u17ba\u1787\u17b6\u1794\u17d2\u179a\u1797\u17c1\u1791\u1793\u17c3 RDBMS \u178a\u17c2\u179b\u179b\u17d2\u17a2\u1794\u17c6\u1795\u17bb\u178f\u179f\u17c6\u179a\u17b6\u1794\u17cb\u17a2\u1797\u17b7\u179c\u178c\u17d2\u178d\u1793\u17cd\u1782\u17c1\u17a0\u1791\u17c6\u1796\u17d0\u179a\u1795\u17d2\u178f\u17c4\u178f\u1791\u17c5\u179b\u17be Software Development \u17d4&hellip;<\/p>\n","protected":false},"author":1,"featured_media":3060,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[344,450],"tags":[],"class_list":["post-3056","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dbms","category-mysql"],"_links":{"self":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/3056","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/comments?post=3056"}],"version-history":[{"count":1,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/3056\/revisions"}],"predecessor-version":[{"id":3062,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/3056\/revisions\/3062"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media\/3060"}],"wp:attachment":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media?parent=3056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/categories?post=3056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/tags?post=3056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}