<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>琪琪小站 - MySQL</title>
    <link>https://kikishop.fengleo.com/forum.php?mod=forumdisplay&amp;fid=69</link>
    <description>Latest 20 threads of MySQL</description>
    <copyright>Copyright(C) 琪琪小站</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Wed, 06 May 2026 08:15:17 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>https://kikishop.fengleo.com/static/image/common/logo_88_31.gif</url>
      <title>琪琪小站</title>
      <link>https://kikishop.fengleo.com/</link>
    </image>
    <item>
      <title>MySQL自增序列重置0開始</title>
      <link>https://kikishop.fengleo.com/forum.php?mod=viewthread&amp;tid=733</link>
      <description><![CDATA[]]></description>
      <category>MySQL</category>
      <author>genie</author>
      <pubDate>Wed, 26 Mar 2025 01:25:34 +0000</pubDate>
    </item>
    <item>
      <title>MySQL sql auto_increment 歸零和重新計算</title>
      <link>https://kikishop.fengleo.com/forum.php?mod=viewthread&amp;tid=666</link>
      <description><![CDATA[for Mysql alter table tablename AUTO_INCREMENT=2; 
//tablename是你的資料表名稱
//數字是代表你要從哪邊開始接著新增 如最後一筆是4 新增的想要讓他變成5就打上4
for MMSQLDBCC CHECKIDENT (\'tablename\',RESEED,2) 
//跟上面說明差不多
另外附上一個終極毀滅的指令
 ...]]></description>
      <category>MySQL</category>
      <author>genie</author>
      <pubDate>Sat, 12 Feb 2022 15:08:30 +0000</pubDate>
    </item>
    <item>
      <title>連接遠端MYSQL ERROR 1130解決辦法</title>
      <link>https://kikishop.fengleo.com/forum.php?mod=viewthread&amp;tid=310</link>
      <description><![CDATA[mysql ERROR 1130: Host \'*****\' is not allowed to connect to this MySQL server
解決方法：1. 改表法。可能是你的帳號不允許從遠程登陸，只能在localhost。這個時候只要在localhost的那臺電腦，登入mysql後，更改 \&quot;mysql\&quot; 數據庫裡的 \&quot;user\&quot; 表裡的 \&quot;host\&quot; 項，從\&quot;lo ...]]></description>
      <category>MySQL</category>
      <author>genie</author>
      <pubDate>Tue, 18 Oct 2016 15:42:59 +0000</pubDate>
    </item>
  </channel>
</rss>