{"id":2160,"date":"2017-04-11T23:20:16","date_gmt":"2017-04-11T23:20:16","guid":{"rendered":"http:\/\/www.kodcafe.com\/?p=2160"},"modified":"2020-10-25T23:26:38","modified_gmt":"2020-10-25T20:26:38","slug":"mysql-de-veri-tabani-olusturma-komutu","status":"publish","type":"post","link":"http:\/\/www.kodcafe.com\/?p=2160","title":{"rendered":"Mysql de veri taban\u0131 olu\u015fturma komutu"},"content":{"rendered":"

CREATE DATABASE – YEN\u0130 B\u0130R VER\u0130 TABANI OLU\u015eTURMAK<\/span><\/strong><\/p>\n

 mysql de veri taban\u0131 olu\u015fturmak i\u00e7in create database komutunu kullan\u0131r\u0131z. <\/strong><\/p>\n

CREATE DATABASE Bilgi;<\/span> \u201c<\/strong> Bilgi veri taban\u0131 olu\u015fturma komutu<\/strong>\u201d<\/strong><\/p>\n

 E\u011fer b\u00f6yle bir veri taban\u0131 olup olmad\u0131\u011f\u0131n\u0131 veya hangi veritabanlar\u0131 var diye merak ediyorsak <\/strong><\/p>\n

SHOW DATABASES; “MYSQL de t\u00fcm veri tabanlar\u0131n\u0131 listeler”<\/span><\/span><\/p>\n

E\u011fer veri taban\u0131m\u0131z daha \u00f6nce olu\u015fturulmu\u015f o veri taban\u0131 \u00fczerinde i\u015flem yapacak isek<\/p>\n

USE [veri taban\u0131 ismi] ;<\/span> <\/strong> veya USE bilgi; bilgi veri taban\u0131n\u0131 se\u00e7er<\/span><\/span><\/strong><\/p>\n

 <\/p>\n

CREATE DATABASE  if not exists Bilgi;<\/span>  \u201c<\/strong> E\u011fer b\u00f6yle bir veri taban\u0131 yoksa olu\u015fturma komutu<\/strong>\u201d<\/strong><\/p>\n

 <\/strong><\/p>\n

CREATE DATABASE  if not exists Bilgi<\/strong><\/span><\/p>\n

char set  utf8  <\/strong><\/span><\/p>\n

collate utf8_turkish_ci; <\/span>   \u201c <\/strong>burada veri taban\u0131m\u0131z\u0131n turkce karakter sorunu              ya\u015famamas\u0131 i\u00e7in karakter kodlamas\u0131n\u0131 T\u00fcrk\u00e7e karakteri destekleyen utf 8 ayarlam\u0131\u015f olduk. \u201d<\/strong><\/p>\n

 <\/strong><\/p>\n

\u201cturk\u00e7e karakter destekleyen yeni <\/strong>Latin 5 ( <\/strong>ISO-8859-9 ) <\/strong>se\u00e7ebiliriz.”<\/strong><\/span><\/p>\n

 <\/strong><\/p>\n

E\u011fer hangi karakter setleri mysql de var kontrol etmek istiyorsak <\/strong><\/p>\n

 <\/strong><\/p>\n

SHOW CHARACTER SET; <\/strong><\/span>\u201cmysql sisteminde karakter setlerini listeler grup halindedir\u201d<\/strong><\/p>\n

SET NAMES UTF8<\/span>;  <\/strong>sonradan karakter setimizi set names komutu ile ayarlayabiliriz.<\/strong><\/p>\n

show collation<\/strong><\/span>;<\/span>  \u201c desteklene collate yani collation karakter setlerini g\u00f6sterir\u201d<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

CREATE DATABASE – YEN\u0130 B\u0130R VER\u0130 TABANI OLU\u015eTURMAK  mysql de veri taban\u0131 olu\u015fturmak i\u00e7in create database komutunu kullan\u0131r\u0131z.  CREATE DATABASE Bilgi; \u201c Bilgi veri taban\u0131 olu\u015fturma komutu\u201d  E\u011fer b\u00f6yle bir veri taban\u0131 olup olmad\u0131\u011f\u0131n\u0131 veya hangi veritabanlar\u0131 var diye merak ediyorsak  SHOW DATABASES; “MYSQL de t\u00fcm veri tabanlar\u0131n\u0131 listeler” E\u011fer veri taban\u0131m\u0131z daha \u00f6nce olu\u015fturulmu\u015f […]<\/p>\n","protected":false},"author":1,"featured_media":2258,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[227,273,275,331,406,487],"class_list":["post-2160","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-konsol-komutlari","tag-mysql","tag-mysql-create","tag-php-mysql","tag-sql-komutlari","tag-workbench"],"_links":{"self":[{"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2160"}],"version-history":[{"count":1,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2160\/revisions"}],"predecessor-version":[{"id":2286,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2160\/revisions\/2286"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/media\/2258"}],"wp:attachment":[{"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2160"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}