{"id":2166,"date":"2017-04-12T00:17:28","date_gmt":"2017-04-12T00:17:28","guid":{"rendered":"http:\/\/www.kodcafe.com\/?p=2166"},"modified":"2020-10-23T01:02:06","modified_gmt":"2020-10-22T22:02:06","slug":"mysql_degiskenler","status":"publish","type":"post","link":"https:\/\/www.kodcafe.com\/?p=2166","title":{"rendered":"MYSQL de de\u011fi\u015fkenler"},"content":{"rendered":"<p>Mysql de kullan\u0131labilinecek veri tipleri listelenmi\u015ftir.<strong><span style=\"color: #ff0000;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SAYISAL DE\u011e\u0130\u015eKEN<\/span><\/strong><br \/>\n1 &nbsp;TINYINT 0 ile 255 UNSIGNED \u00f6zelli\u011fi belirtilmi\u015fse -128 ile 127 1 BYTE<br \/>\n2 SMALLINT 0- 65535 UNSIGNED &nbsp;32768 &#8211; 32767 2 BYTE<br \/>\n3 MEDIUMINT 0 ile 16777215 UNSIGNED &nbsp;8388608 &#8211; 8388607 3 BYTE<br \/>\n4 INT 0 ile 4294967295 UNSIGNED -2147683648 ile 2147683647 4 BYTE<br \/>\n5 BIGINT 9223372036854775808 ile 9223372036854775807 8 BYTE<br \/>\n6 FLOAT pozitif ondal\u0131k say\u0131lar\u0131 depolar.<\/p>\n<p>7 DOUBLE negatif ve pozitif ondal\u0131k say\u0131lar\u0131 depolar.<br \/>\n8 DECIMAL 10&#8217;luk de\u011ferleri depolar.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; S\u00d6ZEL DE\u011e\u0130\u015eKEN<\/strong><\/span><br \/>\n9 &nbsp;CHAR(x), x kadar karakter bar\u0131nd\u0131r\u0131r (x en fazla 255 olabilir).<br \/>\n10 VARCHAR(x), x kadar karakter bar\u0131nd\u0131r\u0131r (x en fazla 255 olabilir).<br \/>\n11 TINYTEXT, k\u0131sa yaz\u0131lar.<br \/>\n12 MEDIUMTEXT, orta uzunlukta yaz\u0131lar.<br \/>\n13 TEXT, uzun yaz\u0131lar<br \/>\n14 LONGTEXT, \u00e7ok uzun yaz\u0131lar.<\/p>\n<p style=\"text-align: left;\"><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"color: #ff0000;\">TAR\u0130H VE SAAT DE\u011e\u0130\u015eKEN<\/span><\/strong><br \/>\n15 &nbsp;DATE, YYYY-AA-GG format\u0131yla tarihi depolar<br \/>\n16 TIME, hh:mm:ss format\u0131ysa saati depolar.<br \/>\n17 DATETIME g\u00fcn \u00f6nce ba\u015flamak \u00fczere tarih ve saati depolar.<br \/>\n18 TIMESTAMP say\u0131sal bir de\u011fer olarak saati i\u015fler.<br \/>\n19 YEAR y\u0131l\u0131 depolar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mysql de kullan\u0131labilinecek veri tipleri listelenmi\u015ftir.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SAYISAL DE\u011e\u0130\u015eKEN 1 &nbsp;TINYINT 0 ile 255 UNSIGNED \u00f6zelli\u011fi belirtilmi\u015fse -128 ile 127 1 BYTE 2 SMALLINT 0- 65535 UNSIGNED &nbsp;32768 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2264,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[273,276,280,283],"class_list":["post-2166","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql","tag-mysql-datatype","tag-mysql-degisken","tag-mysql-integer"],"_links":{"self":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2166"}],"version-history":[{"count":1,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2166\/revisions"}],"predecessor-version":[{"id":2272,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2166\/revisions\/2272"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/media\/2264"}],"wp:attachment":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}