{"id":2131,"date":"2017-03-22T23:11:44","date_gmt":"2017-03-22T23:11:44","guid":{"rendered":"http:\/\/www.kodcafe.com\/?p=2131"},"modified":"2020-10-25T23:25:04","modified_gmt":"2020-10-25T20:25:04","slug":"mysql-konsol-ve-workbench-komutlari","status":"publish","type":"post","link":"http:\/\/www.kodcafe.com\/?p=2131","title":{"rendered":"Mysql Konsol  ve Workbench Komutlar\u0131"},"content":{"rendered":"<p>\u00c7o\u011fumuz MYSQL i veritabanlar\u0131nda kullan\u0131r\u0131z. Lakin kullan\u0131rken hep ba\u011flant\u0131 ayarlar\u0131n\u0131 yap\u0131p, &nbsp;di\u011fer diller arac\u0131l\u0131\u011f\u0131 ile mysql de i\u015flemlerimizi yapar\u0131z. Kay\u0131tlar olu\u015fturur sileriz. Sorgulamalar yapar bunlar\u0131 yazaca\u011f\u0131m\u0131z uygulamalarda kullan\u0131r\u0131z. Lakin Mysql komut sat\u0131r\u0131nda yada vtys (veri tabani y\u00f6netim sistemi) pro\u011fram\u0131 olan workbench gibi pro\u011framlarda nadir kullan\u0131r\u0131z. Kullanan arkada\u015flardan genellikle veri taban\u0131n\u0131 y\u00f6neten arkada\u015flard\u0131r. Bug\u00fcn sizlere mysql console komutlar\u0131ndan bahsedece\u011fim. Ayni komutlar\u0131 workbench \u00fczerinde kullanabilirsiniz.<\/p>\n<p>Bu yaz\u0131da<\/p>\n<ul>\n<li><span style=\"color: #008000;\"><strong>Mysql konsol nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r.<\/strong><\/span><\/li>\n<li>\n<pre class=\"lang-sql prettyprint prettyprinted\"><span style=\"color: #0000ff;\"><strong><code><span class=\"pln\">show databases <span style=\"color: #ff0000;\">komutu ( Veri tabanlar\u0131n\u0131 g\u00f6ster)<\/span><\/span><\/code><\/strong><\/span><\/pre>\n<\/li>\n<li>\n<pre class=\"lang-sql prettyprint prettyprinted\"><span style=\"color: #0000ff;\"><strong><code><span class=\"pln\">create database <span style=\"color: #ff0000;\">komutu(Yeni bir veri taban\u0131 olu\u015fturmak)<\/span><\/span><\/code><\/strong><\/span><\/pre>\n<\/li>\n<li>\n<pre class=\"lang-sql prettyprint prettyprinted\"><span style=\"color: #0000ff;\"><strong><code><span class=\"pln\">Use <span style=\"color: #ff0000;\">komutu (Veri taban\u0131 se\u00e7mek )<\/span><\/span><\/code><\/strong><\/span><\/pre>\n<\/li>\n<li>\n<pre class=\"lang-sql prettyprint prettyprinted\"><span style=\"color: #0000ff;\"><strong><code><span class=\"pln\">show tables <span style=\"color: #ff0000;\">komutu ( Tablolar\u0131 g\u00f6ster )<\/span><\/span><\/code><\/strong><\/span><\/pre>\n<\/li>\n<li><span style=\"color: #0000ff;\"><strong>create &nbsp;table <span style=\"color: #ff0000;\">komutu ( Yeni bir tablo olu\u015fturmak)<\/span><\/strong><\/span><\/li>\n<li>\n<pre class=\"lang-sql prettyprint prettyprinted\"><span style=\"color: #0000ff;\"><strong><code><span class=\"pln\">drop table <span style=\"color: #ff0000;\">komutu ( <\/span><\/span><\/code><span style=\"color: #ff0000;\">Tablo silmek )<\/span><\/strong><\/span><\/pre>\n<\/li>\n<li>\n<pre class=\"lang-sql prettyprint prettyprinted\"><\/pre>\n<p><span style=\"color: #0000ff;\"><strong><code>drop database <span style=\"color: #ff0000;\">komutu( Veri taban\u0131n\u0131 silmek)<\/span><\/code><\/strong><\/span><\/p>\n<\/li>\n<li>\n<span style=\"color: #008000;\"><strong><code><span style=\"color: #0000ff;\">select <span style=\"color: #ff0000;\">komutu (Listeleme) &nbsp;<\/span><\/span>&nbsp;<\/code><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><!--more--><\/p>\n<p><span style=\"color: #ff0000;\"><strong>Mysql konsol nas\u0131l \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r.<\/strong><\/span><\/p>\n<p>1- \u0130lk olarak wamp server yada apache uygulamalar\u0131nda wamp veya di\u011fer uygulamalar\u0131 \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda ekran sa\u011f al k\u00f6\u015fede uygulama t\u0131klad\u0131\u011f\u0131n\u0131zda MYSQL sekmesi alt\u0131nda MYSQL CONSOLE uygulamas\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2132\" src=\"http:\/\/www.kodcafe.com\/wp-content\/uploads\/2017\/03\/mysql1.jpg\" alt=\"\" width=\"458\" height=\"356\"><\/p>\n<p>yada Cmd komut sat\u0131r\u0131nda &#8220;<strong>C:\\ cd &nbsp;C:\\wamp64\\bin\\mysql \\mysql5.7.14\\bin\\mysql -u root -p -h localhost &#8220;<\/strong> uygulamas\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2133\" src=\"http:\/\/www.kodcafe.com\/wp-content\/uploads\/2017\/03\/mysql11.jpg\" alt=\"\" width=\"459\" height=\"396\"><\/p>\n<p>burada mysql.exe uygulamas\u0131n\u0131 local host da root yetkisi ile a\u00e7\u0131n.<\/p>\n<pre class=\"lang-sql prettyprint prettyprinted\"><code><span class=\"pln\">\"mysql <\/span><span class=\"pun\">-<\/span><span class=\"pln\">u USERNAME <\/span><span class=\"pun\">-<\/span><span class=\"pln\">p PASSWORD <\/span><span class=\"pun\">-<\/span><span class=\"pln\">h HOSTNAME <\/span><\/code><\/pre>\n<p>harf kodlar\u0131n\u0131n\u0131 anlam\u0131 :<\/p>\n<pre class=\"lang-sql prettyprint prettyprinted\"><code><span class=\"pun\">-<\/span><span class=\"pln\">u<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> username (veri tabanlar\u0131 ilk kuruldu\u011funda root kullan\u0131c\u0131 ad\u0131n\u0131 al\u0131r)\n<\/span><span class=\"pun\">-<\/span><span class=\"pln\">p<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> password <\/span><span class=\"pun\">(<\/span><span class=\"pln\">ilk kullan\u0131\u015fta parola olmaya bilir<\/span><span class=\"pun\">)<\/span>\n<span class=\"pun\">-<\/span><span class=\"pln\">h<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> hostname( kendi bilgisayar\u0131n\u0131zda \u00e7al\u0131\u015facak iseniz localhost )\"\n\n2- Gelen ekranda sizden parola isteyecektir. Parola vermi\u015f iseniz giriniz. Yoksa enter tu\u015funa bas\u0131n\u0131z.\n\nart\u0131k mysql komut sat\u0131r\u0131na girmi\u015f olduk.\n\nMysql komut sat\u0131r\u0131nda kullanaca\u011f\u0131m\u0131z komutlar\n\n1- <span style=\"color: #ff0000;\"><strong>Veritabanlar\u0131 g\u00f6ster<\/strong><\/span> : show databases ile veritabanlar\u0131m\u0131z\u0131 listeler\n   <span style=\"color: #0000ff;\"> mysql&gt; show databases;\n   <\/span> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2134\" src=\"http:\/\/www.kodcafe.com\/wp-content\/uploads\/2017\/03\/mysql21.jpg\" alt=\"\" width=\"559\" height=\"445\">\n2- <span style=\"color: #ff0000;\"><strong>Yeni bir veri taban\u0131 olu\u015fturmak.<\/strong><\/span>\n     <span style=\"color: #0000ff;\">m<\/span><\/span><\/code><code><span class=\"pln\"><span style=\"color: #0000ff;\">ysql&gt; create database kodcafe;<\/span>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2135\" src=\"http:\/\/www.kodcafe.com\/wp-content\/uploads\/2017\/03\/mysql22.jpg\" alt=\"\" width=\"544\" height=\"444\">\n3- <span style=\"color: #ff0000;\">Veri taban\u0131 se\u00e7mek , o veri taban\u0131 \u00fczerinde i\u015flem yapacak ise o veritaban\u0131n\u0131 se\u00e7memiz gerekir.<\/span> \n<\/span><\/code><span style=\"color: #0000ff;\"><code><span class=\"pln\">    m<\/span><\/code><\/span><code><span class=\"pln\"><span style=\"color: #0000ff;\">ysql&gt; use kodcafe;<\/span>\n\n4- <span style=\"color: #ff0000;\">veri taban\u0131 i\u00e7indeki tablolar\u0131 listelemek. use komutunu kullanman\u0131z gerekmektedir.<\/span>\n  <span style=\"color: #0000ff;\"> mysql&gt;show tables;<\/span>\n5- <span style=\"color: #ff0000;\">Yeni bir tablo olu\u015fturmak i\u00e7in ise:<\/span>\n \n   <span style=\"color: #0000ff;\">mysql&gt; create table kullanici (kullanici_id int auto_increment primary key,\n   kullanici_adi varchar(50),\n   parola varchar(100),\n   mail varchar(30));<\/span>\n\n   \"kullanici id integer tipinde otomatik artan say\u0131 ve anahtar id olmas\u0131n\u0131 belirtir.\"\n <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2136\" src=\"http:\/\/www.kodcafe.com\/wp-content\/uploads\/2017\/03\/mysql31.jpg\" alt=\"\" width=\"600\" height=\"322\">\n<strong>6- <\/strong><\/span><\/code><strong>Tablo silmek :<\/strong><\/pre>\n<p><code>&nbsp; &nbsp; &nbsp;<span style=\"color: #0000ff;\">mysql&gt; drop table [tablo_adi];<\/span><\/code><\/p>\n<p><strong>7- &nbsp; Veritaban\u0131n\u0131 silmek :<\/strong><\/p>\n<p><code>&nbsp; &nbsp; <span style=\"color: #0000ff;\">mysql&gt; drop database [database name];<\/span><\/code><\/p>\n<p>&nbsp;<\/p>\n<p><strong>8- &nbsp; Bir tablodaki t\u00fcm datay\u0131 g\u00f6stermek :<\/strong><\/p>\n<p><code>&nbsp; <span style=\"color: #0000ff;\">&nbsp;mysql&gt; SELECT * FROM [tablo_adi];<\/span><\/code><\/p>\n<pre class=\"lang-sql prettyprint prettyprinted\"><code>\n\n\n\n\n\n\n\n   <\/code><\/pre>\n<pre class=\"lang-sql prettyprint prettyprinted\"><code>\n\n<\/code><\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00c7o\u011fumuz MYSQL i veritabanlar\u0131nda kullan\u0131r\u0131z. Lakin kullan\u0131rken hep ba\u011flant\u0131 ayarlar\u0131n\u0131 yap\u0131p, &nbsp;di\u011fer diller arac\u0131l\u0131\u011f\u0131 ile mysql de i\u015flemlerimizi yapar\u0131z. Kay\u0131tlar olu\u015fturur sileriz. Sorgulamalar yapar bunlar\u0131 yazaca\u011f\u0131m\u0131z uygulamalarda kullan\u0131r\u0131z. Lakin Mysql komut sat\u0131r\u0131nda yada vtys (veri tabani y\u00f6netim sistemi) pro\u011fram\u0131 olan workbench gibi pro\u011framlarda nadir kullan\u0131r\u0131z. Kullanan arkada\u015flardan genellikle veri taban\u0131n\u0131 y\u00f6neten arkada\u015flard\u0131r. Bug\u00fcn sizlere mysql [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2258,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[227,273,487],"class_list":["post-2131","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-konsol-komutlari","tag-mysql","tag-workbench"],"_links":{"self":[{"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2131","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=2131"}],"version-history":[{"count":1,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2131\/revisions"}],"predecessor-version":[{"id":2282,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2131\/revisions\/2282"}],"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=2131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2131"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}