{"id":2179,"date":"2017-05-28T20:27:04","date_gmt":"2017-05-28T20:27:04","guid":{"rendered":"http:\/\/www.kodcafe.com\/?p=2179"},"modified":"2020-10-23T00:55:56","modified_gmt":"2020-10-22T21:55:56","slug":"mysql-de-fonksiyon-komutlari-function","status":"publish","type":"post","link":"https:\/\/www.kodcafe.com\/?p=2179","title":{"rendered":"Mysql de Fonksiyon Komutlar\u0131 (Function)"},"content":{"rendered":"

MYSQL de fonksiyonlar (Function)<\/strong><\/p>\n

ABS() : Girilen say\u0131n\u0131n mutlak de\u011ferini verir.<\/strong>
\nSELECT ABS(say\u0131);<\/p>\n

BIT_COUNT() : Girilen say\u0131da ka\u00e7 tane bit kullan\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6sterir..<\/strong>
\nSELECT BIT_COUNT(say\u0131);
\nSelect bit_count(1); 1 Bit
\nSelect bit_count(65); 2 Bit
\nCEIL() : Girilen say\u0131y\u0131 yukar\u0131ya yuvarlar.<\/strong>
\nSELECT CEIL(say\u0131);
\nCEILING()
\nSelect ceil(1,2); say\u0131y\u0131 2 yuvarlad\u0131
\nFLOOR() : Girilen say\u0131y\u0131 a\u015fa\u011f\u0131ya yuvarlar.<\/strong>
\nSELECT FLOOR(say\u0131);<\/p>\n

CONV() : Bir say\u0131y\u0131 ba\u015fka bir tabana \u00e7evirir.<\/strong>
\nSELECT CONV(say\u0131,taban,yeni_taban);
\nSelect conv(65,10,2); Ekran \u00e7\u0131kt\u0131s\u0131 10000001sonucu verir.
\nCOS() : Girilen say\u0131n\u0131n cosin\u00fcs\u2019\u00fcn\u00fc verir.<\/strong>
\nSELECT COS(say\u0131);
\nDEGREES() : Girilen radyan de\u011feri dereceye \u00e7evirir.<\/strong>
\nSELECT DEGREES(radyan);
\nselect degrees(pi()\/4); sonu\u00e7 45 derece olarak verir
\nEXP() : e say\u0131s\u0131n\u0131n kuvvetini hesaplar.<\/strong>
\nSELECT EXP(\u00fcs);<\/p>\n

FORMAT() : Girilen say\u0131y\u0131 ###,###.## format\u0131na \u00e7evirir.<\/strong>
\nSELECT FORMAT(say\u0131, basamak);
\nselect format(12536528,2); ekran \u00e7\u0131kt\u0131s\u0131 : 12,536,528.00<\/p>\n

GREATEST() : Girilen say\u0131lardan en b\u00fcy\u00fc\u011f\u00fcn\u00fc verir.<\/strong>
\nSELECT GREATEST(say\u01311, say\u01312,\u2026.say\u0131N);
\nselect greatest(1,3,0,9,5,100,-1); ekran \u00e7\u0131kt\u0131s\u0131 100 d\u00fcr
\nLEAST() : Girilen say\u0131lardan en k\u00fc\u00e7\u00fc\u011f\u00fcn\u00fc verir.<\/strong>
\nSELECT LEAST(say\u01311, say\u01312,\u2026.say\u0131N);
\nselect greatest(1,3,0,9,5,100,-1); ekran \u00e7\u0131kt\u0131s\u0131 -1 dir
\nINTERVAL() : Bir de\u011ferin di\u011ferleri i\u00e7inde hangi aral\u0131kta oldu\u011funa bakar. De\u011fer listesi artan s\u0131rada yaz\u0131lmal\u0131d\u0131r.<\/strong>
\nSELECT INTERVAL(aranan,s1,s2\u2026sN);
\nselect interval (11,1,3,6,9,10); ekran \u00e7\u0131kt\u0131s\u0131 5 verecektir. 10 dan sonra gelir de\u011ferler i\u00e7inde 5 s\u0131radad\u0131r 10
\nLOG() : Logaritma hesaplar. Tek parametreli girilirse taban e kabul edilir.<\/strong>
\nSELECT LOG(say\u0131);
\nSELECT LOG(taban, say\u0131);
\ns elect log(2,16); ekran \u00e7\u0131kt\u0131s\u0131 4 t\u00fcr.
\nLOG10() : 10 taban\u0131nda logaritma hesaplar.<\/strong>
\nSELECT LOG10(say\u0131);
\nMOD() : Girilen say\u0131lar\u0131n b\u00f6l\u00fcm\u00fcnden kalan\u0131 verir.<\/strong>
\nSELECT MOD(say\u01311, say\u01312);
\nselect mod(128,3); \/*kalan 2 dir*\/<\/p>\n

  PI() : PI say\u0131s\u0131n\u0131n de\u011ferini verir.<\/strong>
\nSELECT PI();
\nPOW() : Girilen say\u0131n\u0131n kuvvetini verir.<\/strong>
\nSELECT POW(taban, \u00fcs);
\nPOWER(taban, \u00fcs)<\/strong>
\nselect pow(2,5); 2 \u00fczeri 5 ifadesisnin \u00e7\u00f6z\u00fcm\u00fc 32 dir*\/
\nRADIANS() : Girilen dereceyi radyan\u2019a \u00e7evirir.<\/strong>
\nSELECT RADIANS(derece);
\nRAND() : 0<=X SELECT RAND();
\nROUND() : Girilen say\u0131y\u0131 yuvarlar.<\/strong>
\nSELECT ROUND(say\u0131);
\nSELECT ROUND(say\u0131, basamak);
\nselect round(3.8892,2); ekran \u00e7\u0131kt\u0131s\u0131 3,89
\nSIGN() : Girilen say\u0131n\u0131n i\u015faretini verir.<\/strong>
\nSELECT SIGN(say\u0131);
\nSQRT() : Girilen say\u0131n\u0131n k\u00f6k\u00fcn\u00fc verir.<\/strong>
\nSELECT SQRT(say\u0131);
\nSelect sqrt(81); ekran \u00e7\u0131kt\u0131s\u0131 9
\nTRUNCATE() : Girilen say\u0131n\u0131n ondal\u0131k k\u0131sm\u0131n\u0131 d\u00fczenler.<\/strong>
\nSELECT TRUNCATE(say\u0131, basamak);
\nASCII() : Girilen karakterin ASCII kodunu verir.<\/strong>
\nSELECT ASCII(karakter);
\nCHAR() : Girilen say\u0131 veya say\u0131lar\u0131n ASCII tablosundaki kar\u015f\u0131l\u0131\u011f\u0131n\u0131 verir.<\/strong>
\nSELECT CHAR(say\u0131);
\nSELECT CHAR(say\u01311,say\u01312,say\u01313\u2026);<\/p>\n

CONCAT() : Girilen stringleri birle\u015ftirir.<\/em><\/strong>
\nSELECT CONCAT(str1, str2, \u2026);
\nSelect Concat (\u201cAli \u201c,\u201dVeli\u201d); Ali Veli
\nCONCAT_WS() : Girilen stringleri aralar\u0131na bir string ekleyerek birle\u015ftirir.<\/strong>
\nSELECT CONCAT_WS(krk, str1, str2, \u2026);
\nELT() : Girilen elemanlar aras\u0131ndan uygun istenilen s\u0131radakini se\u00e7er.<\/strong>
\nSELECT ELT(s\u0131ra, ele1, ele2, \u2026);
\nFIELD() : Aranan de\u011ferin ka\u00e7\u0131nc\u0131 s\u0131rada oldu\u011funu bulur.<\/strong>
\n         <\/strong>         SELECT FIELD(aranan, str1, str2, \u2026);
\nINSERT() : String bir ifadenin i\u00e7erisinden belli bir yeri de\u011fi\u015ftirir.<\/strong>
\nSELECT INSERT(metin,ba\u015flang\u0131\u00e7,say\u0131,yeni);
\nINSTR() : Bir metin i\u00e7erisinde aranan de\u011ferin ilk konumunu verir.<\/strong>
\nSELECT INSTR(metin, aranan);
\nLCASE() : Girilen metni k\u00fc\u00e7\u00fck harflere \u00e7evirir.<\/strong>
\nSELECT LCASE(metin);
\nLOWER()
\nLEFT() : Metnin sol ba\u015f\u0131ndan belli say\u0131da karakter se\u00e7meye yarar.<\/strong>
\nSELECT LEFT(metin, say\u0131);
\nRIGHT()
\nLENGTH() : Bir metin ifadesindeki karakter say\u0131s\u0131n\u0131 verir.<\/strong>
\nSELECT LENGTH(metin);
\n LOAD_FILE() : Bir dosya i\u00e7erisindeki metni okur.<\/strong>
\nSELECT LOAD_FILE(dosya yolu);
\nLOCATE() : Bir metin i\u00e7erisinde aranan de\u011ferin ilk konumu verir.<\/strong>
\nSELECT LOCATE(aranan, metin);
\nSELECT LOCATE(aranan, metin, ba\u015flang\u0131\u00e7);
\nPOSITION(aranan IN metin)
\nLPAD() : Bir metin ifadesinin sol ba\u015f\u0131n\u0131 istenilen karakterle istenilen say\u0131ya kadar doldurur.<\/strong>
\nSELECT LPAD(metin, say\u0131, krk);<\/p>\n

LTRIM() :  <\/strong>Bir metin ifadesinin sol ba\u015f\u0131ndaki bo\u015fluklar\u0131 siler.<\/p>\n

SELECT LTRIM(metin);<\/em><\/p>\n

             <\/em>RTRIM()<\/p>\n

REGEXP :  <\/strong>\u0130fadelerin e\u015fle\u015fip e\u015fle\u015fmedi\u011fini s\u0131nar. E\u015fle\u015fme varsa 1, yoksa 0 \u00fcretir.<\/p>\n

SELECT metin REGEXP format;<\/em><\/p>\n

REPEAT() : <\/strong> Bir metin ifadesini istenilen say\u0131da yan yana \u00e7o\u011falt\u0131r.<\/p>\n

SELECT REPEAT(metin, say\u0131);<\/em><\/p>\n

REPLACE() :  <\/strong>Bir metin ifadesinin i\u00e7indeki istenilen karakteri ba\u015fka karakterle de\u011fi\u015ftirir.<\/p>\n

SELECT REPLACE(metin, eski, yeni);<\/em><\/p>\n

REVERSE() :  <\/strong>Bir metin ifadesini tersine \u00e7evirir.<\/p>\n

SELECT REVERSE(metin);<\/em><\/p>\n

SPACE() :  <\/strong>Girilen say\u0131 kadar bo\u015fluktan olu\u015fan bir string \u00fcretir.<\/p>\n

SELECT SPACE(say\u0131);<\/em><\/p>\n

STRCMP() : <\/strong> \u0130ki string ifadeyi kar\u015f\u0131la\u015ft\u0131r. \u0130lk string k\u00fc\u00e7\u00fckse -1, b\u00fcy\u00fckse 1 d\u00f6ner. Stringler e\u015fitse 0.<\/p>\n

SELECT STRCMP(metin1, metin2);<\/em><\/p>\n

SUBSTRING() : <\/strong>Bir metin ifadesinin i\u00e7inden belli say\u0131da karakter al\u0131r.<\/p>\n

SELECT SUBSTRING(metin,ba\u015flang\u0131\u00e7);<\/em><\/p>\n

  SELECT SUBSTRING(metin FROM ba\u015flang\u0131\u00e7);<\/em><\/p>\n

  SELECT SUBSTRING(metin,ba\u015flang\u0131\u00e7,say\u0131);<\/em><\/p>\n

  SELECT SUBSTRING(mtn FROM ba\u015fl FOR say\u0131);<\/em><\/p>\n

  <\/em>SELECT MID(metin, ba\u015flang\u0131\u00e7, say\u0131)<\/p>\n

SUBSTRING_INDEX() : <\/strong>  Bir metin ifadenin ba\u015f\u0131ndan veya sonundan metin se\u00e7er. Verilen karakterin verilen s\u0131rada g\u00f6r\u00fcnt\u00fclendi\u011fi noktaya kadar se\u00e7er.<\/p>\n

SELECT SUBSTRING_INDEX(metin, karakter, s\u0131ra);<\/em><\/p>\n

 <\/em><\/p>\n

TRIM() :  <\/strong>Ba\u015ftan ve\/veya sondan bo\u015fluk ya da karakter siler.<\/p>\n

SELECT TRIM(<\/em><\/p>\n

                        [BOTH | LEADING| TRAILING<\/em><\/p>\n

                        [karakter] FROM] metin);<\/em><\/p>\n

select trim(trailing ‘x’ from ‘xx1235bxbxx’);  sondakileri siler<\/em><\/p>\n

select trim(LEADING ‘x’ from ‘xx1235bxbxx’);  ba\u015ftakileri siler<\/em><\/p>\n

select trim(both ‘x’ from ‘xx1235bxbxx’);  ba\u015ftan ve sondan siler<\/em><\/p>\n

UCASE() :  <\/strong>Girilen metni b\u00fcy\u00fck harflere \u00e7evirir.<\/p>\n

SELECT UCASE(metin);<\/em><\/p>\n

            <\/em>UPPER()<\/p>\n","protected":false},"excerpt":{"rendered":"

MYSQL de fonksiyonlar (Function) ABS() : Girilen say\u0131n\u0131n mutlak de\u011ferini verir. SELECT ABS(say\u0131); BIT_COUNT() : Girilen say\u0131da ka\u00e7 tane bit kullan\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6sterir.. SELECT BIT_COUNT(say\u0131); Select bit_count(1); 1 Bit Select bit_count(65); 2 Bit CEIL() : Girilen say\u0131y\u0131 yukar\u0131ya yuvarlar. SELECT CEIL(say\u0131); CEILING() Select ceil(1,2); say\u0131y\u0131 2 yuvarlad\u0131 FLOOR() : Girilen say\u0131y\u0131 a\u015fa\u011f\u0131ya yuvarlar. SELECT FLOOR(say\u0131);<\/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":[273,281,282],"class_list":["post-2179","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql","tag-mysql-function","tag-mysql-function-kumutlari"],"_links":{"self":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2179","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=2179"}],"version-history":[{"count":1,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2179\/revisions"}],"predecessor-version":[{"id":2260,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2179\/revisions\/2260"}],"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=2179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}