{"id":3070,"date":"2019-03-22T05:02:14","date_gmt":"2019-03-22T05:02:14","guid":{"rendered":"http:\/\/it.isophal.com\/?p=3070"},"modified":"2019-03-22T05:02:14","modified_gmt":"2019-03-22T05:02:14","slug":"%e1%9e%80%e1%9e%b6%e1%9e%9a%e1%9e%8e%e1%9f%82%e1%9e%93%e1%9e%b6%e1%9f%86%e1%9e%96%e1%9e%b8-mysql-%e1%9e%93%e1%9e%b7%e1%9e%84%e2%80%8b-sql","status":"publish","type":"post","link":"https:\/\/isophal.com\/news\/2019\/03\/22\/3070.html\/","title":{"rendered":"\u1780\u17b6\u179a\u178e\u17c2\u1793\u17b6\u17c6\u1796\u17b8 MySQL \u1793\u17b7\u1784\u200b SQL"},"content":{"rendered":"

\u1795\u17d2\u1793\u17c2\u1780\u1793\u17c1\u17c7\u1795\u17d2\u178f\u179b\u17cb\u1780\u17b6\u179a\u178e\u17c2\u1793\u17b6\u17c6 My SQL \u178a\u17c4\u1799\u1794\u1784\u17d2\u17a0\u17b6\u1789\u1796\u17b8\u179a\u1794\u17c0\u1794\u1794\u17d2\u179a\u17be mySQL client program \u178a\u17be\u1798\u17d2\u1794\u17b8\u1794\u1784\u17d2\u1780\u17be\u178f\u1793\u17b7\u1784\u1794\u17d2\u179a\u17be\u00a0 database\u00a0 \u1792\u1798\u17d2\u1798\u178f\u17b6\u17d4
\nMySQL \u1782\u17ba\u1787\u17b6program \u17a2\u1793\u17d2\u178f\u179a\u1798\u17bd\u1799\u178a\u17c2\u179b\u17a2\u1793\u17bb\u1789\u17d2\u1789\u17b6\u178f\u17b2\u17d2\u1799\u17a2\u17d2\u1793\u1780\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u1797\u17d2\u1787\u17b6\u1794\u17cb\u1791\u17c5\u1780\u17b6\u1793\u17cb MySQL server , run queries \u1793\u17b7\u1784 \u1794\u1784\u17d2\u17a0\u17b6\u1789\u179b\u1791\u17d2\u178b\u1795\u179b\u17d4 mySQL \u1780\u17cf\u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1794\u17d2\u179a\u17be\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 mode \u1787\u17b6\u1785\u17d2\u179a\u17be\u1793\u17d6 \u17a2\u17d2\u1793\u1780\u178a\u17b6\u1780\u17cb queries \u179a\u1794\u179f\u17cb\u17a2\u17d2\u1793\u1780\u1791\u17bb\u1780\u1798\u17bb\u1793\u1794\u1793\u17d2\u1791\u17b6\u1794\u17cb\u1798\u1780 \u1794\u17d2\u179a\u17b6\u1794\u17cb mysql \u178a\u17be\u1798\u17d2\u1794\u17b8\u178a\u17c6\u178e\u17be\u1780\u17b6\u179a\u17a2\u178f\u17d2\u1790\u1794\u1791\u179a\u1794\u179f\u17cb file\u17d4
\n\u178a\u17be\u1798\u17d2\u1794\u17b8\u1798\u17be\u179b list \u179a\u1794\u179f\u17cb\u1787\u17c6\u179a\u17be\u179f\u1795\u17d2\u178f\u179b\u17cb\u178a\u17c4\u1799\u00a0 mysql \u1787\u17b6\u1798\u17bd\u1799\u1793\u17b9\u1784 help option \u17d6<\/p>\n

Case Sensitivity\u00a0<\/span><\/h1>\n

\u178a\u17bc\u1785\u1799\u17be\u1784\u1794\u17b6\u1793\u1794\u17d2\u179a\u17be SQL \u1793\u17b7\u1784\u1794\u1784\u17d2\u1780\u17be\u178fMySQL \u1799\u17be\u1784\u1782\u17bd\u179a\u178f\u17c2\u179f\u1784\u17d2\u1781\u17c1\u1794\u1780\u17b6\u179a\u1793\u17b7\u1799\u17b6\u1799\u1796\u17b8 case sensitivity \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 MySQL \u17d4 SQL keyword \u1798\u17b7\u1793\u1798\u17c2\u1793\u1787\u17b6 case sensitivity \u17d4
\n\u1793\u17c1\u17c7\u1782\u17ba\u1787\u17b6\u179f\u17d2\u178f\u1784\u17cb\u178a\u17b6 database systems\u17d4 case sensitivity \u179b\u17c1\u1785\u17a1\u17be\u1784\u1796\u17b9\u1784\u1795\u17d2\u17a2\u17c2\u1780\u179b\u17be database system \u178a\u17c2\u179b\u17a2\u17d2\u1793\u1780\u1794\u17d2\u179a\u17be\u17d4 \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784MySQL database \u1793\u17b7\u1784 table name\u00a0 \u1787\u17b6 case sensitivity \u178a\u17c2\u179b\u1796\u17b9\u1784\u1795\u17d2\u17a2\u17c2\u1780\u179b\u17be operating system \u179a\u1794\u179f\u17cb\u17a2\u17d2\u1793\u1780\u17d4 \u17a0\u17c1\u178f\u17bb\u1795\u179b\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb database \u1793\u17b8\u1798\u17bd\u1799\u17d7\u1793\u17b9\u1784\u1798\u17b6\u1793\u1793\u17c5\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798 directory \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 operating system \u179a\u1794\u179f\u17cb\u17a2\u17d2\u1793\u1780 \u1793\u17b7\u1784 table \u1793\u17b8\u1798\u17bd\u1799\u17d7\u1793\u17b9\u1784\u1798\u17b6\u1793\u1793\u17c5\u1781\u17b6\u1784\u1780\u17d2\u179a\u17c4\u1798 file\u17d4 Directory name \u1793\u17b7\u1784 filename \u1798\u17b6\u1793\u1797\u17b6\u1796\u1781\u17bb\u179f\u1782\u17d2\u1793\u17b6\u17a2\u17b6\u179f\u17d2\u179a\u17d0\u1799\u179b\u17be operating system\u17d4<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Data Types MySQL<\/h1>\n

MySQL \u1794\u17d2\u179a\u17be data type \u1781\u17bb\u179f\u1782\u17d2\u1793\u17b6\u1787\u17b6\u1785\u17d2\u179a\u17be\u1793 \u178a\u17c2\u179b\u1794\u17c6\u1794\u17c2\u1780\u1791\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1787\u1798\u17d2\u179a\u17be\u179f\u1794\u17b8 \u17d6 numeric, date time \u1793\u17b7\u1784 string type \u17d4
\n1.\u00a0 Numeric Data Types
\n<\/strong>MySQL \u1794\u17d2\u179a\u17be\u179f\u17d2\u178f\u1784\u17cb\u178a\u17b6 ANSI numeric data types \u1791\u17b6\u17c6\u1784\u17a2\u179f\u17cb \u17d4<\/p>\n

    \n
  • \u00a0INT \u1787\u17b6\u1791\u17c6\u17a0\u17c6 integer \u1792\u1798\u17d2\u1798\u178f\u17b6\u178a\u17c2\u179b\u17a2\u17b6\u1785\u1787\u17b6 signed \u17ac unsigned \u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be signed \u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796 rang \u1796\u17b8 -2147483648 \u1791\u17c5\u00a0 2147483647\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be unsigned \u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796\u00a0 rang \u1796\u17b8 0 \u1791\u17c5 4294967295\u17d4<\/li>\n
  • TINYINT integer \u178f\u17bc\u1785\u178a\u17c2\u179b\u17a2\u17b6\u1785\u1787\u17b6 signed \u17ac unsigned\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be signed \u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796 rang \u1796\u17b8 -128 \u1791\u17c5\u00a0 127\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be unsigned \u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796\u00a0 rang \u1796\u17b8 0 \u1791\u17c5 255\u17d4<\/li>\n
  • \u00a0SMALLINT\u00a0 integer \u178f\u17bc\u1785\u178a\u17c2\u179b\u17a2\u17b6\u1785\u1787\u17b6 signed \u17ac unsigned\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be signed \u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796 rang \u1796\u17b8 -32768 \u1791\u17c5\u00a0 32767\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be unsigned \u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796\u00a0 rang \u1796\u17b8 0 \u1791\u17c5 65535\u17d4<\/li>\n
  • \u00a0MEDIUMINT integer \u1780\u178e\u17d2\u178f\u17b6\u179b\u178a\u17c2\u179b\u17a2\u17b6\u1785\u1787\u17b6 signed \u17ac unsigned\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be signed \u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796 rang \u1796\u17b8 -8388608\u1791\u17c5\u00a0 8388607\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be unsigned \u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796\u00a0 rang \u1796\u17b8 0 \u1791\u17c5 16777215\u17d4<\/li>\n
  • \u00a0BIGINT integer\u00a0 \u1798\u17b6\u1793\u1791\u17c6\u17a0\u17c6\u1792\u17c6\u178a\u17c2\u179b\u17a2\u17b6\u1785\u1787\u17b6 signed \u17ac unsigned\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be signed \u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796 rang \u1796\u17b8 \u20139223372036854775808 \u1791\u17c5\u00a0 9223372036854775807\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be unsigned \u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796\u00a0 rang \u1796\u17b8 0 \u1791\u17c5 18446744073709551615\u17d4<\/li>\n
  • \u00a0FLOAT(M,D) \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793\u1791\u179f\u1797\u17b6\u1782\u178a\u17c2\u179b\u1798\u17b7\u1793\u17a2\u17b6\u1785 unsigned \u17d4 \u17a2\u17d2\u1793\u1780\u17a2\u17b6\u1785\u1780\u17c6\u178e\u178f\u17cb\u1780\u17b6\u179a\u1794\u1784\u17d2\u17a0\u17b6\u1789\u1785\u17c6\u1784\u17b6\u1799(M) \u1793\u17b7\u1784 \u1785\u17c6\u1793\u17bd\u1799\u179a\u1794\u179f\u17cb\u1794\u17d2\u179a\u1796\u1793\u17d2\u178b\u17d0\u1782\u17c4\u179b\u178a\u1794\u17cb(D)\u17d4 \u178a\u17c2\u179b\u1787\u17b6 default \u1782\u17ba 10,2 \u178a\u17c2\u179b 2\u1787\u17b6\u1785\u17c6\u1793\u17bd\u1799\u1793\u17c3\u1794\u17d2\u179a\u1796\u1793\u17d2\u178b\u17d0\u1782\u17c4\u179b\u178a\u1794\u17cb \u1793\u17b7\u1784 10 \u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793\u179f\u179a\u17bb\u1794\u1793\u17c3 digits<\/li>\n
  • \u00a0DOUBLE(M,D) \u1785\u17c6\u1793\u17bd\u1793 double precision floating-point \u178a\u17c2\u179b\u1798\u17b7\u1793\u17a2\u17b6\u1785\u1787\u17b6 unsigned \u17a2\u17d2\u1793\u1780\u17a2\u17b6\u1785\u1780\u17c6\u178e\u178f\u17cb\u1780\u17b6\u179a\u1794\u1784\u17d2\u17a0\u17b6\u1789\u1785\u1798\u17d2\u1784\u17b6\u1799(M) \u1793\u17b7\u1784\u1785\u17c6\u1793\u17bd\u1793\u1793\u17c3\u1794\u17d2\u179a\u1796\u1793\u17d2\u178b\u17d0\u1782\u17c4\u179b\u178a\u1794\u17cb\u17d4 \u178f\u1798\u17d2\u179b\u17c3\u1787\u17b6 default \u1782\u17ba 16,4 \u178a\u17c2\u179b 4 \u1782\u17ba\u1787\u17b6\u1785\u17c6\u1793\u17bd\u1793\u1794\u17d2\u179a\u1796\u17d2\u178b\u17d0\u1782\u17c4\u179b 10\u17d4<\/li>\n
  • \u00a0DECIMAL(M,D) \u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1794\u17c6\u1794\u17c2\u1780\u1785\u17c1\u1789\u1796\u17b8 floating-point number \u178a\u17c2\u179b\u1798\u17b7\u1793\u17a2\u17b6\u1785\u1787\u17b6 unsigned\u00a0 \u17d4 \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1780\u17b6\u179a\u1794\u17c6\u1794\u17c2\u1780 decimals decimal \u1793\u17b8\u1798\u17bd\u1799\u179f\u17d2\u1798\u17be\u179a\u1793\u17b9\u1784 1 byte\u17d4 \u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb\u1780\u17b6\u179a\u1794\u1784\u17d2\u17a0\u1789\u1785\u17c6\u1784\u17b6\u1799(M) \u1793\u17b7\u1784 decimal (D)\u1782\u17ba\u1787\u17b6\u178f\u1798\u17d2\u179a\u17bc\u179c\u1780\u17b6\u179a\u17d4<\/li>\n<\/ul>\n

    \u179a\u17b6\u179b\u17cbdata type \u1787\u17b6 numeric \u179a\u1794\u179f\u17cb MySQL \u1791\u17b6\u17c6\u1784\u1784\u179f\u17cb \u17a2\u17d2\u1793\u1780\u1793\u17b9\u1784\u1785\u17bc\u179b\u1785\u17b7\u178f\u17d2\u178f\u1794\u17d2\u179a\u17be INT \u1785\u17d2\u179a\u17be\u1793\u1787\u17b6\u1784\u1782\u17c1\u17d4 \u17a2\u17d2\u1793\u1780\u17a2\u17b6\u1785 run \u1791\u17c5\u1780\u17b6\u1793\u17cb\u1794\u1789\u17d2\u17a0\u17b6\u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be\u17a2\u17d2\u1793\u1780\u1780\u17c6\u178e\u178f\u17cb fields \u178f\u17bc\u1785\u1787\u17b6\u1784\u17a2\u17d2\u179c\u17b8\u178a\u17c2\u179b\u17a2\u17d2\u1793\u1780\u178f\u17d2\u179a\u17bc\u179c\u1780\u17b6\u179a\u1796\u17b7\u178f\u1794\u17d2\u179a\u17b6\u1780\u178a \u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be\u17a2\u17d2\u1793\u1780\u17c6\u178e\u178f\u17cb field id \u1798\u17bd\u1799\u1787\u17b6 unsigned TINYINT \u17a2\u17d2\u1793\u1780\u1793\u17b9\u1784\u1798\u17b7\u1793\u1798\u17b6\u1793\u179b\u1791\u17d2\u178b\u1797\u17b6\u1796\u1780\u17d2\u1793\u17bb\u1784\u1780\u17b6\u179a\u1794\u1789\u17d2\u1785\u17bc\u179b 256record \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be id \u1782\u17ba\u1787\u17b6 primary key \u17d4
    \nStorage Requirements for Numeric Types<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    Data Type<\/td>\nStorage Required<\/td>\n<\/tr>\n
    TINYINT<\/td>\n1 byte<\/td>\n<\/tr>\n
    SMALLINT<\/td>\n2 bytes<\/td>\n<\/tr>\n
    MEDIUMINT<\/td>\n3 bytes<\/td>\n<\/tr>\n
    INT, INTEGER<\/td>\n4 bytes<\/td>\n<\/tr>\n
    BIGINT<\/td>\n8 bytes<\/td>\n<\/tr>\n
    FLOAT(p)<\/td>\n4 bytes if 0 <= p <= 24, 8 bytes if 25 <= p <= 53<\/td>\n<\/tr>\n
    FLOAT<\/td>\n4 bytes<\/td>\n<\/tr>\n
    DOUBLE [PRECISION], REAL<\/td>\n8 bytes<\/td>\n<\/tr>\n
    DECIMAL(M,D), NUMERIC(M,D)<\/td>\n\u00a0Varies<\/td>\n<\/tr>\n
    BIT(M)<\/td>\napproximately (M+7)\/8 bytes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    2.\u00a0 Date and Time Types<\/strong>
    \nMySQL \u1798\u17b6\u1793 data type \u1787\u17b6\u1785\u17d2\u179a\u17be\u1793\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a store date \u1793\u17b7\u1784 time \u17a0\u17be\u1799 date type\u1791\u17b6\u17c6\u1784\u1793\u17c1\u17c7\u17a2\u17b6\u1785\u1795\u17d2\u179b\u17b6\u179f\u17cb\u1794\u17d2\u178f\u17bc\u179a\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1780\u17b6\u179a\u1794\u1789\u17d2\u1785\u17bc\u179b\u179a\u1794\u179f\u17cb\u1796\u17bd\u1780\u1782\u17c1\u17d4
    \n\u1797\u17b6\u1796\u178a\u17c2\u179b\u17a2\u17b6\u1785\u1795\u17d2\u179b\u17b6\u179f\u17cb\u1794\u17d2\u178f\u17bc\u179a\u1793\u17c3 \u1794\u17d2\u179a\u1797\u17c1\u1791 date \u1793\u17b7\u1784 time \u179a\u1794\u179f\u17cb MySQL\u1785\u1784\u17d2\u17a2\u17bb\u179b\u1794\u17d2\u179a\u17b6\u1794\u17cb\u1796\u17b8\u1791\u17c6\u1793\u17bd\u179b\u1781\u17bb\u179f\u178f\u17d2\u179a\u17bc\u179c\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u1780\u17b6\u179a\u178f\u17d2\u179a\u17bd\u178f\u1796\u17b7\u1793\u17b7\u178f\u17d2\u1799\u1793\u17c5\u179b\u17be application developer \u17d4 MySQL \u178f\u17d2\u179a\u17bd\u178f\u1796\u17b7\u1793\u17b7\u178f\u17d2\u1799\u178f\u17c2\u1796\u17b8\u179a element \u1794\u17c9\u17bb\u178e\u17d2\u178e\u17c4\u17c7\u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb\u179f\u17bb\u1796\u179b\u1797\u17b6\u1796\u17d6\u178a\u17bc\u1785\u1787\u17b6 month \u1782\u17ba\u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8 0 \u1791\u17c5 12\u00a0 \u1793\u17b7\u1784 day \u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8 0 \u1791\u17c5 31 \u17d4
    \nThe MySQL date and time data types are<\/p>\n

      \n
    • \u00a0DATE\u00a0 \u17d6 date \u1798\u17bd\u1799\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 \u1791\u17c6\u179a\u1784\u17cb YYYY-MM-DD \u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8 1000-01-01\u1793\u17b7\u1784 9999-12-31\u17d4\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd December 30th, 1973 would be stored as 1973-12-30.<\/li>\n
    • DATETIME \u17d6 date and time \u179a\u17bd\u1798\u1794\u1789\u17d2\u1785\u17bc\u179b\u1780\u17d2\u1793\u17bb\u1784\u1791\u17c6\u179a\u1784\u17cb YYYY-DD-MM HH:MM:SS \u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8 1000-01-01 00:00:00 \u1793\u17b7\u1784 9999:-12-31-23:59:59\u17d4 \u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd \u1798\u17c9\u17c4\u1784 3:30 \u1796\u17c1\u179b\u179a\u179f\u17c0\u179b \u1793\u17c5\u1790\u17d2\u1784\u17c3\u1791\u17b8 30 \u1781\u17c2\u1792\u17d2\u1793\u17bc \u1786\u17d2\u1793\u17b6\u17c6 1973 \u17a2\u17b6\u1785\u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793 store \u178a\u17bc\u17851973-12-30 15:30:00\u17d4<\/li>\n
    • TIMESTAMP \u17d6 timestamp\u00a0 \u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b6\u1780\u17cb\u1780\u178e\u17d2\u178f\u17b6\u179b\u1799\u1794\u17cb \u1790\u17d2\u1784\u17c3\u1791\u17b8 1 \u1781\u17c2 \u1798\u1780\u179a\u17b6 \u1786\u17d2\u1793\u17b6\u17c6 1970 \u1793\u17b7\u1784\u1796\u17c1\u179b\u1781\u17d2\u179b\u17c7\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u1786\u17d2\u1793\u17b6\u17c6 2037\u17d4 \u17a2\u17d2\u1793\u1780\u17a2\u17b6\u1785\u1780\u17c6\u178e\u178f\u17cb\u179a\u1799\u17c8\u1796\u17c1\u179b\u1785\u17d2\u179a\u17be\u1793\u1791\u17c5\u17b2\u17d2\u1799 field TIMESTAMP\u178a\u17c2\u179b\u1798\u17b6\u1793\u1791\u17c6\u1793\u17b6\u1780\u17cb\u1791\u17c6\u1793\u1784\u1797\u17d2\u179b\u17b6\u1798\u17d7\u1791\u17c5\u1780\u17b6\u1793\u17cb\u17a2\u17d2\u179c\u17b8\u178a\u17c2\u179b store \u1791\u17bb\u1780\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784\u179c\u17b6\u17d4 \u179a\u1799\u17c8\u1796\u17c1\u179b\u1787\u17b6 default \u179f\u1798\u17d2\u179a\u17b6\u1794\u17cb TIMESTAMP \u1782\u17ba 14 \u178a\u17c2\u179b store \u1780\u17d2\u1793\u17bb\u1784\u1791\u17c6\u179a\u1784\u17cb YYYYMMDDHHMMSS\u17d4 \u179c\u17b6\u1798\u17be\u179b\u1791\u17c5\u178a\u17bc\u1785\u1791\u17c6\u179a\u1784\u17cb DATETIME\u00a0 \u179c\u17b6\u1782\u17d2\u179a\u17b6\u1793\u17cb\u178f\u17c2\u1798\u17b7\u1793\u1798\u17b6\u1793\u179f\u17a0\u179f\u1789\u17d2\u1789\u17b6\u1793\u17c4\u1785\u1793\u17d2\u179b\u17c4\u17c7\u179b\u17c1\u1781\u1794\u17c9\u17bb\u178e\u17d2\u178e\u17c4\u17c7 \u17d4\u17a7\u1791\u17b6\u17a0\u179a\u178e\u17cd \u1798\u17c9\u17c4\u1784 3:30 \u1796\u17c1\u179b\u179a\u179f\u17c0\u179b \u1793\u17c5\u1790\u17d2\u1784\u17c3\u1791\u17b8 30 \u1781\u17c2\u1792\u17d2\u1793\u17bc \u1786\u17d2\u1793\u17b6\u17c6 1973 \u17a2\u17b6\u1785\u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793 store \u178a\u17bc\u178519731230153000\u17d4\u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb\u178a\u17cf\u1791\u17c3\u1791\u17c0\u178f\u179a\u1794\u179f\u17cb TIMESTAMP \u1782\u17ba 12 (YYMMDDHHMMSS), 8 (YYYYMMDD),\u1793\u17b7\u1784 6(YYMMDD).<\/li>\n
    • TIME store \u1796\u17c1\u179b\u179c\u17c1\u179b\u17b6\u1780\u17d2\u1793\u17bb\u1784\u1791\u17c6\u179a\u1784\u17cb HH:MM:SS \u17d4<\/li>\n
    • YEAR(M) store year \u1780\u17d2\u1793\u17bb\u1784\u1791\u17c6\u179a\u1784\u17cb\u00a0 2digit \u17ac 4 digit \u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be\u179a\u1799\u17c8\u1794\u1796\u179b\u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1780\u17c6\u178e\u178f\u17cb\u179f\u17d2\u1798\u17be\u179a 2 (YEAR(2)) YEAR \u17a2\u17b6\u1785\u1785\u17b6\u1794\u17cb\u1796\u17b8 1970 \u1791\u17c5 2069\u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be\u179a\u1799\u17c8\u1796\u17c1\u179b\u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1780\u17c6\u178e\u178f\u17cb\u179f\u17d2\u1798\u17be\u179a 4 YEAR \u17a2\u17b6\u1785\u1785\u17b6\u1794\u17cb\u1796\u17b8 1901\u1791\u17c5 2155\u17d4\u179a\u1799\u17c8\u1796\u17c1\u179b\u1787\u17b6 default \u1782\u17ba 4\u17d4<\/li>\n<\/ul>\n

      Storage Requirements for Date and Time Types<\/p>\n\n\n\n\n\n\n\n\n
      Data Type<\/td>\n\u00a0 Storage Required<\/td>\n<\/tr>\n
      DATE<\/td>\n3 bytes<\/td>\n<\/tr>\n
      TIME<\/td>\n3 bytes<\/td>\n<\/tr>\n
      DATETIME<\/td>\n8 bytes<\/td>\n<\/tr>\n
      TIMESTAMP<\/td>\n4 bytes<\/td>\n<\/tr>\n
      YEAR<\/td>\n1 byte<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      3.\u00a0 String Types<\/strong>
      \n\u1791\u17c4\u17c7\u1794\u17b8\u1787\u17b6 numeric \u1793\u17b7\u1784 data types \u1787\u17b6 fun data \u1797\u17b6\u1782\u1785\u17d2\u179a\u17be\u1793\u178a\u17c2\u179b\u17a2\u17d2\u1793\u1780\u1793\u17b9\u1784 store \u1791\u17bb\u1780\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 string format \u17d4 List \u1793\u17c1\u17c7\u1796\u17b7\u1796\u178e\u17cc\u1793\u17b6\u1796\u17b8 string data type \u179f\u17b6\u1798\u1789\u17d2\u1789\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 MySQL\u17d4<\/p>\n

        \n
      • CHAR(M)\u00a0 \u17d6 String fixed-length \u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8 1\u1791\u17c5 255 \u17a2\u1780\u17d2\u179f\u179a\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 length (CHAR(5)) Right-padded \u1787\u17b6\u1798\u17bd\u1799 spaces \u1791\u17c5\u17b2\u17d2\u1799\u00a0 length \u1796\u17c1\u179b store\u17d4 \u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb length \u1782\u17ba\u1798\u17b7\u1793\u178f\u17d2\u179a\u17bc\u179c\u1780\u17b6\u179a \u1794\u17c9\u17bb\u1793\u17d2\u178f\u17c2\u1787\u17b6 default \u1782\u17ba\u00a0 1\u17d4<\/li>\n
      • \u00a0VARCHAR(M) \u17d6 String variable-length \u1793\u17c5\u1785\u1793\u17d2\u179b\u17c4\u17c7\u1796\u17b8 1 \u1791\u17c5 255\u17a2\u1780\u17d2\u179f\u179a\u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 length (CHAR(5))\u17d4 \u17a2\u17d2\u1793\u1780\u178f\u17d2\u179a\u17bc\u179c\u178f\u17c2\u1780\u17c6\u178e\u178f\u17cb length \u1798\u17bd\u1799\u1793\u17c5\u1796\u17c1\u179b\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u1794\u1784\u17d2\u1780\u17be\u178f field VARCHAR\u17d4<\/li>\n
      • \u00a0BLOB OR TEXT \u17d6 field \u1798\u17bd\u1799\u1787\u17b6\u1798\u17bd\u1799\u1793\u17b9\u1784\u17a2\u178f\u17b7\u1794\u179a\u1798\u17b6 length \u1793\u17c3 65535 \u17a2\u1780\u17d2\u179f\u179a\u17d4 BLOB \u1782\u17ba\u1787\u17b6 \u201cBinary Large Object\u201d\u00a0 \u17a0\u17be\u1799\u1794\u17d2\u179a\u17be\u178a\u17be\u1798\u17d2\u1794\u17b8 store \u1785\u17c6\u1793\u17bd\u1793\u1785\u17d2\u179a\u17be\u1793\u1793\u17c3 binary data \u178a\u17bc\u1785\u1787\u17b6 images \u17ac \u1794\u17d2\u179a\u1797\u17c1\u1791 file \u178a\u17cf\u1791\u17c3\u1791\u17c0\u178f\u17d4 filed \u1780\u17c6\u178e\u178f\u17cb\u178a\u17c4\u1799 TEXT \u1795\u17d2\u1791\u17bb\u1780\u1785\u17c6\u1793\u17bd\u1793\u1785\u17d2\u179a\u17be\u1793\u179a\u1794\u179f\u17cb data\u00a0 \u17d4 \u1797\u17b6\u1796\u1781\u17bb\u179f\u1782\u17d2\u1793\u17b6\u17d2\u179c\u179c\u17b6\u1784 data type \u1791\u17b6\u17c6\u1784\u1796\u17b8\u1793\u17c1\u17c7\u1782\u17ba sort \u1793\u17b7\u1784 comparisons \u179b\u17be\u1780\u17b6\u179a store data \u1787\u17b6 case sensitive \u1793\u17c5\u179b\u17be Blobs \u1793\u17b7\u1784 \u1798\u17b7\u1793\u1798\u17c2\u1793\u1787\u17b6 case sensitive \u1793\u17c5\u1780\u17d2\u1793\u17bb\u1784 TEXT filed \u17d4\u17a2\u17d2\u1793\u1780\u1798\u17b7\u1793\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb length \u1787\u17b6\u1798\u17bd\u1799 BLOB OR TEXT\u17a1\u17be\u1799\u17d4<\/li>\n
      • \u00a0TINYBLOB OR TINYTEXT \u17d6 Column BLOB \u17ac TEXT\u1798\u17bd\u1799\u1787\u17b6\u1798\u17bd\u1799\u1793\u17b9\u1784\u17a2\u178f\u17b7\u1794\u179a\u1798\u17b6 length \u1793\u17c3 255 \u17a2\u1780\u17d2\u179f\u179a\u17d4 \u17a2\u17d2\u1793\u1780 \u1798\u17b7\u1793\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb length \u1787\u17b6\u1798\u17bd\u1799 TINYBLOB OR TINYTEXT\u17a1\u17be\u1799\u17d4<\/li>\n
      • \u00a0MEDIUMBLOB \u17ac MEDIUMTEXT \u17d6 Column BLOB \u17ac TEXT\u1798\u17bd\u1799\u1787\u17b6\u1798\u17bd\u1799\u1793\u17b9\u1784\u17a2\u178f\u17b7\u1794\u179a\u1798\u17b6 length \u1793\u17c3 16777215 \u17a2\u1780\u17d2\u179f\u179a\u17d4 \u17a2\u17d2\u1793\u1780 \u1798\u17b7\u1793\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb length \u1787\u17b6\u1798\u17bd\u1799 MEDIUMBLOB OR MEDIUMYTEXT\u17a1\u17be\u1799\u17d4<\/li>\n
      • \u00a0LONGBLOB \u17ac LOONGTEXT\u00a0 \u17d6 \u17d6 Column BLOB \u17ac TEXT\u1798\u17bd\u1799\u1787\u17b6\u1798\u17bd\u1799\u1793\u17b9\u1784\u17a2\u178f\u17b7\u1794\u179a\u1798\u17b6 length \u1793\u17c3 4294967295 \u17a2\u1780\u17d2\u179f\u179a\u17d4 \u17a2\u17d2\u1793\u1780 \u1798\u17b7\u1793\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb length \u1787\u17b6\u1798\u17bd\u1799 LONGBLOB OR LONGTEXT\u17a1\u17be\u1799\u17d4<\/li>\n
      • \u00a0ENUM\u00a0 \u17d6 Enumeration \u178a\u17c2\u179b\u1787\u17b6 term list \u1794\u17d2\u179a\u179f\u17be\u179a\u1798\u17bd\u1799\u17d4 \u1796\u17c1\u179b\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u1780\u17c6\u178e\u178f\u17cb ENUM \u1798\u17bd\u1799 \u17a2\u17d2\u1793\u1780\u1792\u17d2\u179c\u17be\u1780\u17b6\u179a\u1794\u1784\u17d2\u1780\u17be\u178f list \u1793\u17c3 items \u1796\u17b8\u178f\u1798\u17d2\u179b\u17c3\u178a\u17c2\u179b\u178f\u17d2\u179a\u17bc\u179c\u1794\u17b6\u1793\u1787\u17d2\u179a\u17be\u179f\u179a\u17be\u179f9(\u17ac\u179c\u17b6\u17a2\u17b6\u1785\u1791\u1791\u17c1) \u17d4 \u1794\u17d2\u179a\u179f\u17b7\u1793\u1794\u17be\u17a2\u17d2\u1793\u1780\u1785\u1784\u17cb\u17b2\u17d2\u1799 field \u179a\u1794\u179f\u17cb\u17a2\u17d2\u1793\u1780\u1795\u17d2\u1791\u17bb\u1780 \u201cA\u201d \u17ac\u201cB\u201d\u17ac \u201cC\u201d \u17a2\u17d2\u1793\u1780\u17a2\u17b6\u1785\u1780\u17c6\u178e\u178f\u17cb ENUM \u1798\u17bd\u1799\u178a\u17bc\u1785 ENUM (\u2018A\u2019,\u2019B\u2019,\u2019C\u2019) \u17d4 ENUMs \u17a2\u17b6\u1785\u1798\u17b6\u1793\u178f\u1798\u17d2\u179b\u17c3 65535 \u1781\u17bb\u179f\u17d7\u1782\u17d2\u1793\u17b6\u17d4<\/li>\n<\/ul>\n

        \u17a2\u17d2\u1793\u1780\u1794\u17d2\u179a\u17a0\u17c2\u179b\u1787\u17b6\u1794\u17d2\u179a\u17be field\u00a0 VARCHAR \u1793\u17b7\u1784 TEXT \u1785\u17d2\u179a\u17be\u1793\u1787\u17b6\u1784\u1794\u17d2\u179a\u1797\u17c1\u1791\u00a0 field \u178a\u17cf\u1791\u17c3\u1791\u17c0\u178f \u1793\u17b7\u1784 ENUMs \u1798\u17b6\u1793\u1794\u17d2\u179a\u1799\u17c4\u1787\u1793\u17cd\u178a\u17c2\u179b\u17d4<\/p>\n\n\n\n\n\n\n\n
        Value<\/td>\nCHAR(4)<\/td>\nStorage Required<\/td>\nVARCHAR(4)<\/td>\nStorage required<\/td>\n<\/tr>\n
        ”<\/td>\n‘\u00a0\u00a0\u00a0 ‘<\/td>\n4 bytes<\/td>\n”<\/td>\n1 byte<\/td>\n<\/tr>\n
        ‘ab’<\/td>\n‘ab\u00a0 ‘<\/td>\n4 bytes<\/td>\n‘ab’<\/td>\n3 bytes<\/td>\n<\/tr>\n
        ‘abcd’<\/td>\n‘abcd’<\/td>\n4 bytes<\/td>\n‘abcd’<\/td>\n5 bytes<\/td>\n<\/tr>\n
        ‘abcdefgh’<\/td>\n‘abcd’<\/td>\n4 bytes<\/td>\n‘abcd’<\/td>\n5 bytes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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

        \u1795\u17d2\u1793\u17c2\u1780\u1793\u17c1\u17c7\u1795\u17d2\u178f\u179b\u17cb\u1780\u17b6\u179a\u178e\u17c2\u1793\u17b6\u17c6 My SQL \u178a\u17c4\u1799\u1794\u1784\u17d2\u17a0\u17b6\u1789\u1796\u17b8\u179a\u1794\u17c0\u1794\u1794\u17d2\u179a\u17be mySQL client program…<\/p>\n","protected":false},"author":1,"featured_media":3071,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[450],"tags":[],"class_list":["post-3070","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/3070","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=3070"}],"version-history":[{"count":1,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/3070\/revisions"}],"predecessor-version":[{"id":3072,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/3070\/revisions\/3072"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media\/3071"}],"wp:attachment":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media?parent=3070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/categories?post=3070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/tags?post=3070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}