{"id":13751,"date":"2023-12-29T00:53:22","date_gmt":"2023-12-29T07:53:22","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=13751"},"modified":"2024-01-12T07:08:39","modified_gmt":"2024-01-12T14:08:39","slug":"mysql-data-types","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/","title":{"rendered":"MySQL Data Types"},"content":{"rendered":"\n<p><strong>Summary<\/strong><em>: <\/em>in this tutorial, you will learn about\u00a0<strong>MySQL data types\u00a0<\/strong>and how to use them effectively in designing databases in MySQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction to MySQL Data Types<\/h2>\n\n\n\n<p>A table contains multiple columns with specific data types such as numeric or string. MySQL provides more data types other than just numeric and string.\u00a0Each data type in MySQL can be determined by the following characteristics:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The kind of values it represents.<\/li>\n\n\n\n<li>The space that takes up and whether the values are a fixed-length or variable length.<\/li>\n\n\n\n<li>The values of the data type can be indexed or not.<\/li>\n\n\n\n<li>How MySQL compares the values of a specific data type.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1040\" height=\"720\" src=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2024\/01\/mysqldatatypes.jpg\" alt=\"\" class=\"wp-image-14561\" srcset=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2024\/01\/mysqldatatypes.jpg 1040w, https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2024\/01\/mysqldatatypes-200x138.jpg 200w, https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2024\/01\/mysqldatatypes-768x532.jpg 768w\" sizes=\"auto, (max-width: 1040px) 100vw, 1040px\" \/><\/figure>\n\n\n\n<p><a href=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2018\/03\/MySQL-Data-Types.pdf\" class=\"buttonDownload\" target=\"_blank\" rel=\"noopener noreferrer\">Download MySQL Data Types Overview<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL numeric data types<\/h2>\n\n\n\n<p>In MySQL, you can find all SQL standard numeric types including exact number data types, and approximate numeric data types including integer, fixed-point, and floating-point. <\/p>\n\n\n\n<p>In addition, MySQL also has <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-bit\/\"><code>BIT<\/code><\/a>\u00a0data type for storing bit values. Numeric types can be signed or unsigned except for\u00a0the <code>BIT<\/code> type.<\/p>\n\n\n\n<p>The following table shows the summary of numeric types in MySQL:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Numeric Types<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-int\/\"><code>TINYINT<\/code><\/a><\/td><td>A very small integer<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-int\/\"><code>SMALLINT<\/code><\/a><\/td><td>A small integer<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-int\/\"><code>MEDIUMINT<\/code><\/a><\/td><td>A medium-sized integer<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-int\/\"><code>INT<\/code><\/a><\/td><td>A standard integer<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-int\/\"><code>BIGINT<\/code><\/a><\/td><td>A large integer<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-decimal\/\"><code>DECIMAL<\/code><\/a><\/td><td>A fixed-point number<\/td><\/tr><tr><td><code>FLOAT<\/code><\/td><td>A single-precision floating point number<\/td><\/tr><tr><td><code>DOUBLE<\/code><\/td><td>A double-precision floating point number<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-bit\/\"><code>BIT<\/code><\/a><\/td><td>A bit field<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL Boolean data type<\/h2>\n\n\n\n<p>MySQL does not have the&nbsp;built-in&nbsp;<code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-boolean\/\">BOOLEAN<\/a><\/code> or <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-boolean\/\"><code>BOOL<\/code><\/a> data type. To represent boolean values, MySQL uses the smallest integer type which is <code>TINYINT(1)<\/code>. In other words,&nbsp;<code>BOOLEAN<\/code> and <code>BOOL<\/code> are synonyms for <code>TINYINT(1).<\/code><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL String data types<\/h2>\n\n\n\n<p>In MySQL, a string can hold anything from plain text to binary data such as images or files. Strings can be compared and searched based on pattern matching by using the <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-like\/\"><code>LIKE<\/code><\/a> operator,&nbsp;<a title=\"MySQL Regular Expression\" href=\"https:\/\/www.mysqltutorial.org\/mysql-regular-expressions\/mysql-regexp\/\">regular expression<\/a>, and <a href=\"https:\/\/www.mysqltutorial.org\/mysql-full-text-search\/\">full-text search<\/a>.<\/p>\n\n\n\n<p>The following table shows the string data types in MySQL:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>String Types<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-char-data-type\/\">CHAR<\/a><\/td><td>A fixed-length nonbinary (character) string<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-varchar\/\">VARCHAR<\/a><\/td><td>A variable-length non-binary string<\/td><\/tr><tr><td><code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-binary\/\">BINARY<\/a><\/code><\/td><td>A fixed-length binary string<\/td><\/tr><tr><td><code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-varbinary\/\">VARBINARY<\/a><\/code><\/td><td>A variable-length binary string<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-blob\/\">TINYBLOB<\/a><\/td><td>A very small BLOB (binary large object)<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-blob\/\">BLOB<\/a><\/td><td>A small BLOB<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-blob\/\">MEDIUMBLOB<\/a><\/td><td>A medium-sized BLOB<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-blob\/\">LONGBLOB<\/a><\/td><td>A large BLOB<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-text\/\">TINYTEXT<\/a><\/td><td>A very small non-binary string<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-text\/\">TEXT<\/a><\/td><td>A small non-binary string<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-text\/\">MEDIUMTEXT<\/a><\/td><td>A medium-sized non-binary string<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-text\/\">LONGTEXT<\/a><\/td><td>A large non-binary string<\/td><\/tr><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-enum\/\">ENUM<\/a><\/td><td>An enumeration; each column value may be assigned one enumeration member<\/td><\/tr><tr><td>SET<\/td><td>A set; each column value may be assigned zero or more <code>SET<\/code> members<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL date and time data types<\/h2>\n\n\n\n<p>MySQL provides types for date and time as well as the combination of date and time. In addition, MySQL supports&nbsp;the <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/understanding-mysql-timestamp\/\">timestamp<\/a> data type for tracking the changes in a row of a table. If you just want to store years without dates and months, you can use the <code>YEAR<\/code> data type.<\/p>\n\n\n\n<p>The following table illustrates the MySQL date and time data types:<\/p>\n\n\n\n<figure class=\"wp-block-table ref\"><table><thead><tr><th>Date and Time Types<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-date\/\">DATE<\/a><\/td><td>A date value in <code>CCYY-MM-DD<\/code> format<\/td><\/tr><tr><td><code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-time\/\">TIME<\/a><\/code><\/td><td>A time value in <code>hh:mm:ss<\/code> format<\/td><\/tr><tr><td><code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-datetime\/\">DATETIME<\/a><\/code><\/td><td>A date and time value in <code>CCYY-MM-DD hh:mm:ss<\/code>format<\/td><\/tr><tr><td><code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/understanding-mysql-timestamp\/\">TIMESTAMP<\/a><\/code><\/td><td>A timestamp value in <code>CCYY-MM-DD hh:mm:ss<\/code> format<\/td><\/tr><tr><td><code>YEAR<\/code><\/td><td>A year value in <code>CCYY<\/code> or <code>YY <\/code>format<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL spatial data types<\/h2>\n\n\n\n<p>MySQL supports many spatial data types that contain various kinds of geometrical and geographical values&nbsp;as shown in the following table:<\/p>\n\n\n\n<figure class=\"wp-block-table ref\"><table><thead><tr><th>Spatial Data Types<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><code>GEOMETRY<\/code><\/td><td>A spatial value of any type<\/td><\/tr><tr><td><code>POINT<\/code><\/td><td>A point (a pair of X-Y coordinates)<\/td><\/tr><tr><td><code>LINESTRING<\/code><\/td><td>A curve (one or more <code>POINT<\/code> values)<\/td><\/tr><tr><td><code>POLYGON<\/code><\/td><td>A polygon<\/td><\/tr><tr><td><code>GEOMETRYCOLLECTION<\/code><\/td><td>A collection of <code>GEOMETRY<\/code> values<\/td><\/tr><tr><td><code>MULTILINESTRING<\/code><\/td><td>A collection of <code>LINESTRING<\/code> values<\/td><\/tr><tr><td><code>MULTIPOINT<\/code><\/td><td>A collection of <code>POINT<\/code> values<\/td><\/tr><tr><td><code>MULTIPOLYGON<\/code><\/td><td>A collection of <code>POLYGON<\/code> values<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">JSON data type<\/h2>\n\n\n\n<p>MySQL supported a native <code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-json\/\">JSON<\/a><\/code> datatype since version 5.7.8 which allows you to store and manage JSON documents more effectively. <\/p>\n\n\n\n<p>The native JSON data type provides automatic validation of JSON documents and optimal storage format.<\/p>\n\n\n\n<p>In this tutorial, you have learned various MySQL data types that help you determine which data type you should use for columns when you <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-create-table\/\">create tables<\/a>.<\/p>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful? <\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"13751\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/\"\n\t\t\t\tdata-post-title=\"MySQL Data Types\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"13751\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/\"\n\t\t\t\tdata-post-title=\"MySQL Data Types\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summary: in this tutorial, you will learn about\u00a0MySQL data types\u00a0and how to use them effectively in designing databases in MySQL. Introduction to MySQL Data Types A table contains multiple columns with specific data types such as numeric or string. MySQL provides more data types other than just numeric and string.\u00a0Each data type in MySQL can [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":174,"menu_order":37,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-13751","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL Data Types<\/title>\n<meta name=\"description\" content=\"This tutorial shows you various MySQL data types so that you can apply them effectively in designing your database tables.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Data Types\" \/>\n<meta property=\"og:description\" content=\"This tutorial shows you various MySQL data types so that you can apply them effectively in designing your database tables.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/\" \/>\n<meta property=\"og:site_name\" content=\"MySQL Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-12T14:08:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2024\/01\/mysqldatatypes.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-data-types\\\/\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-data-types\\\/\",\"name\":\"MySQL Data Types\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-data-types\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-data-types\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/mysqldatatypes.jpg\",\"datePublished\":\"2023-12-29T07:53:22+00:00\",\"dateModified\":\"2024-01-12T14:08:39+00:00\",\"description\":\"This tutorial shows you various MySQL data types so that you can apply them effectively in designing your database tables.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-data-types\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-data-types\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-data-types\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/mysqldatatypes.jpg\",\"contentUrl\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/mysqldatatypes.jpg\",\"width\":1040,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/mysql-data-types\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Basics\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-basics\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MySQL Data Types\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\",\"name\":\"MySQL Tutorial\",\"description\":\"A comprehensive MySQL Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mysqltutorial.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Data Types","description":"This tutorial shows you various MySQL data types so that you can apply them effectively in designing your database tables.","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:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Data Types","og_description":"This tutorial shows you various MySQL data types so that you can apply them effectively in designing your database tables.","og_url":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/","og_site_name":"MySQL Tutorial","article_modified_time":"2024-01-12T14:08:39+00:00","og_image":[{"url":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2024\/01\/mysqldatatypes.jpg","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/","url":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/","name":"MySQL Data Types","isPartOf":{"@id":"https:\/\/www.mysqltutorial.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/#primaryimage"},"image":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2024\/01\/mysqldatatypes.jpg","datePublished":"2023-12-29T07:53:22+00:00","dateModified":"2024-01-12T14:08:39+00:00","description":"This tutorial shows you various MySQL data types so that you can apply them effectively in designing your database tables.","breadcrumb":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/#primaryimage","url":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2024\/01\/mysqldatatypes.jpg","contentUrl":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2024\/01\/mysqldatatypes.jpg","width":1040,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-data-types\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mysqltutorial.org\/"},{"@type":"ListItem","position":2,"name":"MySQL Basics","item":"https:\/\/www.mysqltutorial.org\/mysql-basics\/"},{"@type":"ListItem","position":3,"name":"MySQL Data Types"}]},{"@type":"WebSite","@id":"https:\/\/www.mysqltutorial.org\/#website","url":"https:\/\/www.mysqltutorial.org\/","name":"MySQL Tutorial","description":"A comprehensive MySQL Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mysqltutorial.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/13751","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/comments?post=13751"}],"version-history":[{"count":4,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/13751\/revisions"}],"predecessor-version":[{"id":14563,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/13751\/revisions\/14563"}],"up":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/174"}],"wp:attachment":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/media?parent=13751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}