{"id":4744,"date":"2024-01-12T10:32:59","date_gmt":"2024-01-12T07:32:59","guid":{"rendered":"https:\/\/blog.inetmar.com\/?p=4744"},"modified":"2024-07-29T09:47:10","modified_gmt":"2024-07-29T06:47:10","slug":"mysql-auto_increment-degerini-sifirlama","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mysql-auto_increment-degerini-sifirlama\/","title":{"rendered":"MySQL AUTO_INCREMENT De\u011ferini S\u0131f\u0131rlama"},"content":{"rendered":"<p><strong>MySQL AUTO_INCREMENT De\u011ferini S\u0131f\u0131rlama<\/strong><br \/><br \/>MySQL&#8217;de <strong>AUTO_INCREMENT<\/strong> de\u011ferini s\u0131f\u0131rlaman\u0131n birka\u00e7 farkl\u0131 yolu vard\u0131r. AUTO_INCREMENT de\u011ferini s\u0131f\u0131rlamak i\u00e7in a\u015fa\u011f\u0131daki SQL komutunu kullanabilirsiniz: <br \/><strong><span class=\"hljs-keyword\"><br \/>ALTER<\/span> <span class=\"hljs-keyword\">TABLE<\/span> tablo_adi AUTO_INCREMENT <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-number\">1<\/span>;<\/strong> <br \/><br \/>Burada <code>tablo_adi<\/code>, AUTO_INCREMENT de\u011ferini s\u0131f\u0131rlamak istedi\u011finiz tablonun ad\u0131n\u0131 temsil eder. Bu komut, tablonun AUTO_INCREMENT de\u011ferini 1&#8217;e ayarlayacakt\u0131r. \u0130sterseniz 1 yerine farkl\u0131 bir ba\u015flang\u0131\u00e7 de\u011feri de belirleyebilirsiniz. <br \/><br \/>E\u011fer tablonun i\u00e7indeki verileri silmek istiyorsan\u0131z, bu i\u015flemi ger\u00e7ekle\u015ftirdikten sonra a\u015fa\u011f\u0131daki DELETE komutunu kullanabilirsiniz: <br \/><strong><span class=\"hljs-keyword\"><br \/>DELETE<\/span> <span class=\"hljs-keyword\">FROM<\/span> tablo_adi;<\/strong> <br \/><br \/><strong>Ancak, bu komut tablodaki t\u00fcm verileri silecektir, bu y\u00fczden dikkatli olmal\u0131s\u0131n\u0131z. AUTO_INCREMENT de\u011ferini s\u0131f\u0131rlamak istiyorsan\u0131z ve ayn\u0131 zamanda mevcut verileri korumak istiyorsan\u0131z, yukar\u0131daki ALTER TABLE komutunu kullanman\u0131z yeterli olacakt\u0131r.<\/strong><\/p>\r\n\r\n<p style=\"text-align: center;\"><a class=\"waffle-rich-text-link\" href=\"https:\/\/www.inetmar.com\/sunucu\/vds-cloud-server\/\">VDS fiyatlar\u0131<\/a> hakk\u0131ndaki detayl\u0131 bilgi ile en uygun paketi se\u00e7erek memnun kalacaks\u0131n\u0131z.<\/p>","protected":false},"excerpt":{"rendered":"<p>MySQL AUTO_INCREMENT De\u011ferini S\u0131f\u0131rlama MySQL&#8217;de AUTO_INCREMENT de\u011ferini s\u0131f\u0131rlaman\u0131n birka\u00e7 farkl\u0131 yolu vard\u0131r. AUTO_INCREMENT de\u011ferini s\u0131f\u0131rlamak i\u00e7in a\u015fa\u011f\u0131daki SQL komutunu kullanabilirsiniz: ALTER TABLE tablo_adi AUTO_INCREMENT = 1; Burada tablo_adi, AUTO_INCREMENT de\u011ferini s\u0131f\u0131rlamak istedi\u011finiz tablonun ad\u0131n\u0131 temsil&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":4752,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-4744","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlserver"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/4744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=4744"}],"version-history":[{"count":10,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/4744\/revisions"}],"predecessor-version":[{"id":9563,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/4744\/revisions\/9563"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/4752"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=4744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=4744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=4744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}