{"id":2176,"date":"2017-05-28T13:33:31","date_gmt":"2017-05-28T13:33:31","guid":{"rendered":"http:\/\/www.kodcafe.com\/?p=2176"},"modified":"2020-10-23T00:56:29","modified_gmt":"2020-10-22T21:56:29","slug":"mysql-de-sql-komutlari","status":"publish","type":"post","link":"https:\/\/www.kodcafe.com\/?p=2176","title":{"rendered":"Mysql de SQL Komutlar\u0131"},"content":{"rendered":"

\u25cf CREATE DATABASE – creates a new database
\n\u25cf CREATE TABLE – creates a new table
\n\u25cf INSERT INTO – inserts new data into a database
\n\u25cf UPDATE – updates data in a database
\n\u25cf DELETE – deletes data from a database
\n\u25cf ALTER DATABASE – modifies a database
\n\u25cf ALTER TABLE – modifies a table
\n\u25cf DROP TABLE – deletes a table
\n\u25cf CREATE INDEX – creates an index (search key)
\n\u25cf SELECT – extracts data from a database<\/p>\n

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

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

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

CREATE DATABASE if not exists Bilgi<\/span>
\n char set utf8<\/span>
\n collate utf8_turkish_ci;<\/span><\/p>\n

\u201c 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<\/p>\n

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

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

SHOW CHARACTER SET;<\/span> \u201cmysql sisteminde karakter setlerini listeler grup halindedir\u201d
\nSET NAMES UTF8;<\/span> sonradan karakter setimizi set names komutu ile ayarlayabiliriz.
\nshow collation;<\/span> \u201c desteklene collate yani collation karakter setlerini g\u00f6sterir\u201d<\/p>\n

CREATE TABLE \u2013 Yeni bir tablo olu\u015fturmak<\/span><\/strong><\/p>\n

create table deneme (<\/span>
\n id int auto_increment primary key, \u201cint olacak otomatik artacak tek olacak\u201d<\/span>
\n ad char(50),<\/span>
\n soyad char(100),<\/span>
\n sinav int);<\/span><\/p>\n

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

 <\/p>\n

CREATE TABLE `iller` (<\/span>
\n `id_il` int(11) NOT NULL unique,,<\/span>
\n `il_adi` varchar(30) COLLATE utf8_turkish_ci DEFAULT NULL,<\/span>
\n `plaka` tinyint(4) DEFAULT NULL<\/span>
\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;<\/span><\/p>\n

Not..: \u201cENGINE mysql arama motorudur.\u201d
\nUnique : numara sadece tek olsun. Kimseye verilmesin.<\/p>\n

INSERT INTO \u2013 VER\u0130 G\u0130R\u0130\u015e\u0130<\/strong><\/span><\/p>\n

insert into ogrenci (id,isim,numara,vize,final)<\/span>
\n values(null,’nuri can’,’201710050052′,10,80),<\/span><\/p>\n

Bu \u00f6rnekte ogrenci tablosu i\u00e7indeki belirtilen isimlere belirtilen de\u011ferleri tek tek veya altaki gibi birden fazla veri giri\u015fi yap\u0131labilir.<\/p>\n

insert into ogrenci(id,isim,numara,vize,final)<\/span>
\n values(null,’nuri can’,’201710050053′,10,80),<\/span>
\n (null,’veli \u00e7am’,’201596235154′,50,90);<\/span><\/p>\n

UPDATE \u2013 G\u00fcncelleme komutu<\/span><\/p>\n

update ogrenci set ayakno=42.5 where id=1; <\/span>\/*id 1 ayakno g\u00fcncelle*\/<\/p>\n

update dene set soyad=”cem” , sinav=50 where id=5;  <\/span>id si 5 olan soyad ve sinav notunu g\u00fcncelledik.<\/p>\n

NOT: update ve delete komutunu kullanacak iseniz workbench bu i\u015flemi yapman\u0131z gerekmektedir.
\n\/*edit refences workbench refenrans da sql safe updates \u00e7elti\u011fi kald\u0131r*\/<\/p>\n

DELETE \u2013 Silme komutu<\/span><\/p>\n

UPDATE FROM ogrenci WHERE id=5;<\/span> 5 numarali id yi siler
\nUPDATE FROM ogrenci WHERE soyad=\u2019can\u2019;<\/span> soyad\u0131 can olanlar\u0131 siler<\/p>\n

UPDATE FROM ogrenci WHERE sinav<50;<\/span> sinav notu 50 den a\u015fa\u011f\u0131 olanlar sil;<\/p>\n

NOT: update ve delete komutunu kullanacak iseniz workbench bu i\u015flemi yapman\u0131z gerekmektedir.
\n\/*edit refences workbench refenrans da sql safe updates \u00e7elti\u011fi kald\u0131r*\/<\/p>\n

                                               ALTER DATABASE \u2013 VER\u0130 TABANINI G\u00dcNCELLE<\/strong><\/span><\/p>\n

ALTER TABLE \u2013 TABLO G\u00dcNCELLE<\/span><\/p>\n

ALTER TABLE ogrenci ADD COLUMN vize int(2) AFTER sinav;<\/span> ogrenci tablosunda sinav kolonundan sonra vize alan\u0131 olu\u015ftur. Tipide integer tipli de\u011fi\u015fken olsun<\/p>\n

Alter table ogrenci modify vize varchar(10) float;<\/span> vize isimli alan\u0131n tipini varchar tipinde de\u011fi\u015ftirdim
\nAlter table ogrenci drop column vize;<\/span> vize isimli colonu siler<\/p>\n

DROP TABLE \u2013 tabloyu silmek<\/span><\/p>\n

DROP TABLE yeni;<\/span> yeni isimli bir tablomuz vard\u0131. Bu tablomuzu drop table komutu ile sildik<\/p>\n

TRUNCATE OGRENC\u0130<\/span>; ogrenci tablosu i\u00e7eri\u011fini siler . tabloyu komple silmez<\/p>\n","protected":false},"excerpt":{"rendered":"

\u25cf CREATE DATABASE – creates a new database \u25cf CREATE TABLE – creates a new table \u25cf INSERT INTO – inserts new data into a database \u25cf UPDATE – updates data in a database \u25cf DELETE – deletes data from a database \u25cf ALTER DATABASE – modifies a database \u25cf ALTER TABLE – modifies a […]<\/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":[285,406,488],"class_list":["post-2176","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql-komutlari","tag-sql-komutlari","tag-workbench-komutlari"],"_links":{"self":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2176","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=2176"}],"version-history":[{"count":1,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2176\/revisions"}],"predecessor-version":[{"id":2261,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2176\/revisions\/2261"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/media\/2258"}],"wp:attachment":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}