{"id":268,"date":"2010-08-17T21:32:30","date_gmt":"2010-08-17T19:32:30","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=268"},"modified":"2017-04-16T17:18:13","modified_gmt":"2017-04-16T14:18:13","slug":"268","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/268\/","title":{"rendered":"SQL Komutlar\u0131"},"content":{"rendered":"<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"199\">SELECT<\/td>\n<td valign=\"top\" width=\"420\">Listelemek istedi\u011fimiz alanlar s\u0131ras\u0131 ile buraya yaz\u0131l\u0131r ad\u0131n\u0131 AS ile de\u011fi\u015fitirebiliriz<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">FROM<\/td>\n<td valign=\"top\" width=\"420\">Sorguda kullan\u0131lacak Tablolar\u0131n yaz\u0131ld\u0131\u011f\u0131 b\u00f6l\u00fcm<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">ORDER BY<\/td>\n<td valign=\"top\" width=\"420\">Listelenen sonu\u00e7lar\u0131 belirli bir alana g\u00f6re s\u0131ralamaya yarar. Artan s\u0131ralamada ASC veya hi\u00e7bir\u015fey yazmay\u0131z azalan s\u0131ralamada DESC kullan\u0131l\u0131r<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">DESC<\/td>\n<td valign=\"top\" width=\"420\">Azalan s\u0131ralama i\u00e7inkullan\u0131l\u0131r<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">ASC<\/td>\n<td valign=\"top\" width=\"420\">Artan s\u0131ralama i\u00e7in kullan\u0131l\u0131r.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">SUM<\/td>\n<td valign=\"top\" width=\"420\">Say\u0131sal alanlar\u0131n toplam\u0131n\u0131 verir Select ten sonra tek ba\u015f\u0131na kullan\u0131l\u0131r sadece group by ile birlikte 2 alan kullan\u0131labilir<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">AVG<\/td>\n<td valign=\"top\" width=\"420\">Say\u0131sal alanlar\u0131n ortalamas\u0131n\u0131 verir. Group by ile de kullan\u0131l\u0131r<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">COUNT<\/td>\n<td valign=\"top\" width=\"420\">Sayma i\u015fleminde kullan\u0131l\u0131r.Group by ile de kullan\u0131l\u0131r<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">BETWEEN<\/td>\n<td valign=\"top\" width=\"420\">Aras\u0131nda 2 tarih aras\u0131 veya 2 de\u011fer aras\u0131 i\u015flemlerinde kullan\u0131l\u0131r \u00f6rnek:Maas between 500 and 1000<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">GROUP BY<\/td>\n<td valign=\"top\" width=\"420\">Grouplard\u0131rarak sayma toplama gibi i\u015flemlerde kullan\u0131l\u0131r.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">INTO<\/td>\n<td valign=\"top\" width=\"420\">Listelenen sorguyu yeni bir taboya aktarma i\u015fleminde kullan\u0131l\u0131r.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">DISTINCT<\/td>\n<td valign=\"top\" width=\"420\">Birden fazla kullan\u0131lan de\u011ferlerden sadece 1 er tanesini listeler<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">WHERE<\/td>\n<td valign=\"top\" width=\"420\">\u0130li\u015fki ve kriterlerin yaz\u0131ld\u0131\u011f\u0131 aland\u0131r. From dan sonra kullan\u0131lan tablo say\u0131s\u0131ndan 1 eksik ili\u015fki yaz\u0131lmas\u0131 gerekir<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">HAVING<\/td>\n<td valign=\"top\" width=\"420\">GROUP BY ile birlikte kullan\u0131l\u0131r \u00e7\u0131kan sonu\u00e7lar\u0131n aras\u0131ndaki kriterleri belirlemek i\u00e7in kullan\u0131l\u0131r<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">TRUE<\/td>\n<td valign=\"top\" width=\"420\">Evet hay\u0131r alanlar\u0131n\u0131n kriterlerini belirlerken kullan\u0131l\u0131r. TRUE ifadesi genelde kullan\u0131lmaz varsay\u0131lan zaten true dur.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">FALSE<\/td>\n<td valign=\"top\" width=\"420\">Evet hay\u0131r alanlar\u0131n\u0131n kriterlerini belirlerken kullan\u0131l\u0131r. FALSE kullanmak yerine bazen not ile tersinide alabiliriz not cinsiyet gibi<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">LIKE<\/td>\n<td valign=\"top\" width=\"420\">Benzer ifadeleri bulmak i\u00e7in kullan\u0131l\u0131r. = yerine kullan\u0131lmas\u0131 gerekir. ? tek karakter * \u00e7ok karakter yerine kullan\u0131l\u0131r.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">ANDOR<\/td>\n<td valign=\"top\" width=\"420\">VE anlam\u0131nda gelir ili\u015fkilerin aras\u0131nda ve kriterlerin aras\u0131nda kullan\u0131l\u0131r. Ayn\u0131 alanda 2 farkl\u0131 ktiterin istenmesi durumunda arada AND olamaz. \u0130l.ad=\u201dburdur\u201d and il.ad=\u201dAntalya\u201d bu olamaz AND yerine OR kullan\u0131ulmaz\u0131 gerekir.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">NOT<\/td>\n<td valign=\"top\" width=\"420\">De\u011fil anlam\u0131nda kullan\u0131l\u0131r. B\u00fct\u00fcn kriterlerde kullan\u0131labilir tersini istiyor isek NOT LIKE \u201cA*\u201d a \u0130LE BA\u015eLAMAYANLAR<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">MAX<\/td>\n<td valign=\"top\" width=\"420\">Bir alandaki en b\u00fcy\u00fck de\u011feri verir.Group By ile de kullan\u0131l\u0131r<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">MIN<\/td>\n<td valign=\"top\" width=\"420\">Bir alandaki en k\u00fc\u00e7\u00fck de\u011feri verir.Group By ile de kullan\u0131l\u0131r<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">AS<\/td>\n<td valign=\"top\" width=\"420\">Select den sonra yaz\u0131lan alanlar\u0131n listedeki ismini de\u011fi\u015ftirir<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">DAY<\/td>\n<td valign=\"top\" width=\"420\">Tarihlerdeki g\u00fcn\u00fc bulur<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">YEAR<\/td>\n<td valign=\"top\" width=\"420\">Tarihlerdeki y\u0131l\u0131 bulur<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">MONTH<\/td>\n<td valign=\"top\" width=\"420\">Tarihlerdeki ay\u0131 bulur<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">#<\/td>\n<td valign=\"top\" width=\"420\">Tarih sorgular\u0131nda ba\u015fta ve sonda kullan\u0131l\u0131r.Tarih sorgular\u0131nda \u00f6nce ay sonra g\u00fcn sonra y\u0131l yaz\u0131l\u0131r.Tarih=#04\/09\/2009# tarihi 9 nisan olanlar\u0131 listeler.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">NOW<\/td>\n<td valign=\"top\" width=\"420\">Bug\u00fcn\u00fcn tarihi verir.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">SELECT IN SELECT<\/td>\n<td valign=\"top\" width=\"420\">\u0130\u00e7 i\u00e7e select\u00a0 2. select te buldu\u011fu de\u011feri birinci select kullan\u0131r.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">UPDATE SET<\/td>\n<td valign=\"top\" width=\"420\">G\u00fcncellemek i\u00e7in kullan\u0131l\u0131rUPDATE tabloismi SET alanismi=yenide\u011fer where kriterler<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">DELETE<\/td>\n<td valign=\"top\" width=\"420\">Silmek i\u00e7in kullan\u0131l\u0131r delete * from tabloismi birden fazla tablo i\u00e7in delete ile birlikte select kullanmak laz\u0131m<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">INSERT<\/td>\n<td valign=\"top\" width=\"420\">Tabolya veri eklemek i\u00e7in kullan\u0131l\u0131rINSERT INTO tabloismi VALUES (tablodaki alanlara s\u0131ras\u0131 ile format\u0131na g\u00f6re de\u011ferler yaz\u0131l\u0131r.)<\/p>\n<p>(29,\u201dmert\u201d,\u201dy\u0131ld\u0131r\u0131m\u201d,1,500,true)<\/p>\n<p>INSERT INTO tabloismi (soyad,ad,id) VALUES (\u201cmerter\u201d,\u201dTuncay\u201d,35)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">INNER JOIN<\/td>\n<td valign=\"top\" width=\"420\">Where ile ayn\u0131 i\u015fi yapar genelde 2 tablo kullan\u0131l\u0131yor<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">LEFT OUTER JOINRIGHT OUTER JOIN<\/td>\n<td valign=\"top\" width=\"420\">2 tabloyu birle\u015ftirir ancak left ile soldaki tablodaki b\u00fct\u00fcn alanlar sa\u011fdaki tablodaki ili\u015fkili alanlarR\u0131ght ilede tersi i\u015flem yapmak i\u00e7in kullan\u0131l\u0131r<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">IS NULLIS NOT NULL<\/td>\n<td valign=\"top\" width=\"420\">Bo\u015f verileri olan kay\u0131tlar\u0131 listelemek i\u00e7inIS NOT NULL Bo\u015f olmayanlar\u0131 listelemek i\u00e7in<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"199\">IN<\/td>\n<td valign=\"top\" width=\"420\">\u0130\u00e7erisinde istedi\u011fimiz verileri listelemek i\u00e7in IN ( 2,10,15)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>SELECT Listelemek istedi\u011fimiz alanlar s\u0131ras\u0131 ile buraya yaz\u0131l\u0131r ad\u0131n\u0131 AS ile de\u011fi\u015fitirebiliriz FROM Sorguda kullan\u0131lacak Tablolar\u0131n yaz\u0131ld\u0131\u011f\u0131 b\u00f6l\u00fcm ORDER BY<\/p>\n","protected":false},"author":14,"featured_media":459,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[36,66],"class_list":["post-268","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-sql-2","tag-sql-komutlari","comments-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Komutlar\u0131 | F.Murat ALTINI\u015eIK<\/title>\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.fethimurat.com\/blog\/268\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Komutlar\u0131 | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"SELECT Listelemek istedi\u011fimiz alanlar s\u0131ras\u0131 ile buraya yaz\u0131l\u0131r ad\u0131n\u0131 AS ile de\u011fi\u015fitirebiliriz FROM Sorguda kullan\u0131lacak Tablolar\u0131n yaz\u0131ld\u0131\u011f\u0131 b\u00f6l\u00fcm ORDER BY\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/268\/\" \/>\n<meta property=\"og:site_name\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-17T19:32:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T14:18:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"711\" \/>\n\t<meta property=\"og:image:height\" content=\"382\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:site\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"F.Murat ALTINI\u015eIK\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/268\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/268\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"SQL Komutlar\u0131\",\"datePublished\":\"2010-08-17T19:32:30+00:00\",\"dateModified\":\"2017-04-16T14:18:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/268\/\"},\"wordCount\":626,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"image\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/268\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/7.png\",\"keywords\":[\"sql\",\"sql komutlar\u0131\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/268\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/268\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/268\/\",\"name\":\"SQL Komutlar\u0131 | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/268\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/268\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/7.png\",\"datePublished\":\"2010-08-17T19:32:30+00:00\",\"dateModified\":\"2017-04-16T14:18:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/268\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/268\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/268\/#primaryimage\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/7.png\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/7.png\",\"width\":711,\"height\":382},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/268\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Komutlar\u0131\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/\",\"name\":\"F.Murat ALTINI\u015eIK\",\"description\":\"HTML | PHP | C# | SQL | ASP.net | Bitcoin\",\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\",\"name\":\"F.Murat ALTINI\u015eIK\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"caption\":\"F.Murat ALTINI\u015eIK\"},\"logo\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server\",\"sameAs\":[\"http:\/\/www.fethimurat.com\",\"https:\/\/www.facebook.com\/muratfethi\",\"https:\/\/www.instagram.com\/muratfethi\/\",\"https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/\",\"https:\/\/x.com\/muratfethi\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Komutlar\u0131 | F.Murat ALTINI\u015eIK","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.fethimurat.com\/blog\/268\/","og_locale":"tr_TR","og_type":"article","og_title":"SQL Komutlar\u0131 | F.Murat ALTINI\u015eIK","og_description":"SELECT Listelemek istedi\u011fimiz alanlar s\u0131ras\u0131 ile buraya yaz\u0131l\u0131r ad\u0131n\u0131 AS ile de\u011fi\u015fitirebiliriz FROM Sorguda kullan\u0131lacak Tablolar\u0131n yaz\u0131ld\u0131\u011f\u0131 b\u00f6l\u00fcm ORDER BY","og_url":"https:\/\/www.fethimurat.com\/blog\/268\/","og_site_name":"F.Murat ALTINI\u015eIK","article_publisher":"https:\/\/www.facebook.com\/muratfethi","article_author":"https:\/\/www.facebook.com\/muratfethi","article_published_time":"2010-08-17T19:32:30+00:00","article_modified_time":"2017-04-16T14:18:13+00:00","og_image":[{"width":711,"height":382,"url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/7.png","type":"image\/png"}],"author":"F.Murat ALTINI\u015eIK","twitter_card":"summary_large_image","twitter_creator":"@muratfethi","twitter_site":"@muratfethi","twitter_misc":{"Yazan:":"F.Murat ALTINI\u015eIK","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/268\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/268\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"SQL Komutlar\u0131","datePublished":"2010-08-17T19:32:30+00:00","dateModified":"2017-04-16T14:18:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/268\/"},"wordCount":626,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"image":{"@id":"https:\/\/www.fethimurat.com\/blog\/268\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/7.png","keywords":["sql","sql komutlar\u0131"],"articleSection":["SQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/268\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/268\/","url":"https:\/\/www.fethimurat.com\/blog\/268\/","name":"SQL Komutlar\u0131 | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/268\/#primaryimage"},"image":{"@id":"https:\/\/www.fethimurat.com\/blog\/268\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/7.png","datePublished":"2010-08-17T19:32:30+00:00","dateModified":"2017-04-16T14:18:13+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/268\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/268\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/268\/#primaryimage","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/7.png","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/7.png","width":711,"height":382},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/268\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Komutlar\u0131"}]},{"@type":"WebSite","@id":"https:\/\/www.fethimurat.com\/blog\/#website","url":"https:\/\/www.fethimurat.com\/blog\/","name":"F.Murat ALTINI\u015eIK","description":"HTML | PHP | C# | SQL | ASP.net | Bitcoin","publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2","name":"F.Murat ALTINI\u015eIK","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","caption":"F.Murat ALTINI\u015eIK"},"logo":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/"},"description":"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server","sameAs":["http:\/\/www.fethimurat.com","https:\/\/www.facebook.com\/muratfethi","https:\/\/www.instagram.com\/muratfethi\/","https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/","https:\/\/x.com\/muratfethi"]}]}},"_links":{"self":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/comments?post=268"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/268\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media\/459"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}