mysql:11846

煽★枆匹允﹝

域勾及澎蟾午仄化﹜氾□皮伙伕永弁匹反卅仁﹜
失皿伉弗□扑亦件伊矛伙及伕永弁窗チ毛厙迕允月杅芊互丐曰引允﹝

拺﹌
﹛SELECT get_lock( 'lock1', 30 );
﹛DELETE FROM from table_name;
﹛ALTER TABLE table_name AUTO_INCREMENT = 1;
﹛SELECT release_lock( 'lock1' );

劓﹜DELETE 匹反卅仁﹜TRUNCATE TABLE 毛迕中化蟈伊戊□玉毛
綽輪允月午﹜AUTO_INCREMENT 及襖互賡渝襖(1)卞枑月方丹匹允﹝

曉筏反 MySQL 4.1.12 午 5.0.7 及 MyISAM 氾□皮伙匹割カ仄引仄凶﹝
穴瓦亙失伙及筏課卞楮仄化反窒午手中尹引六氏﹝


"Tetsuya Hirotsu" <hirotsu@xxxxxxxxxx> wrote:
> 云壑狪卞卅曰引允﹜僮霰午蕭仄引允﹝
> 
> 
> AUTO_INCREMENT 市仿丞毛儅勾氾□皮伙及伕永弁醱卞﹜公及氾□皮伙井日
> 蟈伊戊□玉毛綽輪詨﹜幻廿⑺元醒及伊戊□玉毛 INSERT 允月午中丹質咥互丐曰引允﹝
> 仇及午五﹜INSERT 允月伊戊□玉及 AUTO_INCREMENT襖毛 1 井日銨戶今六凶中及匹允互﹜
> 丹引仁中五引六氏﹝
> 
> 
> 5.0.6-beta 及穴瓦亙失伙﹋http://dev.mysql.com/doc/mysql/ja/index.html﹌卞
> 
> ∩6.5.3. CREATE TABLE 厭妐
> ∩AUTO_INCREMENT 市仿丞及瘉釐襖互じ勻凶伊戊□玉毛綽輪仄凶樺寧﹜公及襖反 ISAM 氾□皮伙支 BDB 氾□皮伙匹反瘋厙迕今木月互﹜
> ∩MyISAM 氾□皮伙支 InnoDB 氾□皮伙匹反瘋厙迕今木卅中﹝
> ∩DELETE FROM table_name﹋WHERE 濡卅仄﹌毛 AUTOCOMMIT 乒□玉匹撢墊仄化氾□皮伙〇及允屯化及伊戊□玉毛綽輪仄凶樺寧﹜
> ∩InnoDB 毛輪仁允屯化及氾□皮伙滇匹﹜洘糧襖互賡戶井日釩銨今木月﹝
> 
> 午丐曰引允互﹜癲杅及棕雁匹反﹜DELETE FROM table_name; 及樺寧手﹜賡渝祭今木內卞綽輪蟆及
> AUTO_INCREMENT 市仿丞襖 + 1 互本永玄今木引允﹝
> 手切欠氏 AUTOCOMMIT = 1 匹允﹝
> 
> 扔□田□    WindowsXP
> MySQL      4.1.3b-beta-nt﹋田奶瓜伉﹌
> 
> 伕□市伙及 Windows 穴扑件井日﹜MySQL ODBC 3.51 + VBA﹜云方太﹜
> MySQL ODBC 3.51 + MySQL Query Browser 1.1.0 gamma 匹曉筏瑛絆匹仄凶﹝
> 田□斥亦件 4 匹反請侳卅中及匹仄斤丹井〝
> 
> 
> ALTER TABLE table_name AUTO_INCREMENT = 0; 毛撢墊允月午﹜公及慼井日反賡渝祭今木引允互﹜
> LOCK 醱及氾□皮伙及凶戶﹜ALTER 匹五引六氏﹝
> ﹋ALTER 詨及氾□皮伙互�LOCK橇謫卞卅月﹛◤﹛仇木毛莢�允月杅芊互丐曰引仄凶日﹜仇木匹手恌中及匹允互﹜﹜﹜﹌
> 
> 
> 升卅凶井樹扷毛云儅切及杅反中日勻仄扎日卅中匹仄斤丹井〝 
> 
> 
> 
>

11815 2005-07-29 12:29 [H M <hassy_94@xxxxxx] 陸朿弁仿奶失件玄井日及濤糧 11816 2005-07-29 14:17 迆["T.Sasaki" <papasan2] 11818 2005-07-29 15:41 身迂[H M <hassy_94@xxxxxx] 11820 2005-07-29 16:15 身﹛迆["T.Sasaki" <papasan2] 11822 2005-07-29 16:29 身﹛身迆[H M <hassy_94@xxxxxx] 11824 2005-07-29 16:37 身﹛身身迂["T.Sasaki" <papasan2] 11825 2005-07-29 16:35 身﹛身迂[棄③ 諉芚 <endo@xxxx] 11826 2005-07-29 16:39 身﹛身﹛迆[棄③ 諉芚 <endo@xxxx] 11827 2005-07-29 16:54 身﹛身﹛迂["T.Sasaki" <papasan2] 11830 2005-07-29 18:19 身﹛身﹛﹛迂[棄③ 諉芚 <endo@xxxx] 11831 2005-07-29 19:00 身﹛身﹛﹛﹛迂["T.Sasaki" <papasan2] 11821 2005-07-29 16:17 身﹛迂[toki <toki@xxxxxxxxx] 11823 2005-07-29 16:32 身﹛﹛迂["T.Sasaki" <papasan2] 11817 2005-07-29 14:25 迆[SUGIMURA Takashi 錯擻 11819 2005-07-29 16:06 身迂[H M <hassy_94@xxxxxx] 11828 2005-07-29 17:03 迆[SATOH Fumiyasu <fumi] 11829 2005-07-29 18:16 身迂[棄③ 諉芚 <endo@xxxx] 11832 2005-07-29 23:00 迂[seidai hirota <seida] 11833 2005-07-30 15:25 ﹛迂[H M <hassy_94@xxxxxx] 譬犖瑛絆 11834 2005-07-30 22:59 ﹛﹛迆[tateyan <tateyan@xxx] 11835 2005-07-31 14:56 ﹛﹛迂["T.Sasaki" <papasan2] 11836 2005-07-31 20:03 ﹛﹛﹛迂[H M <hassy_94@xxxxxx] 11837 2005-07-31 20:09 ﹛﹛﹛﹛迂[Kazuhiro Yoshida <mo] 11838 2005-07-31 20:16 ﹛﹛﹛﹛﹛迆[H M <hassy_94@xxxxxx] 11840 2005-07-31 20:47 ﹛﹛﹛﹛﹛身迆["T.Sasaki" <papasan2] 11841 2005-07-31 22:15 ﹛﹛﹛﹛﹛身迂[iida_yuichi <y_iida@] 11842 2005-08-01 09:05 ﹛﹛﹛﹛﹛身﹛迆["T.Sasaki" <papasan2] 11853 2005-08-01 20:55 ﹛﹛﹛﹛﹛身﹛身迆[iida_yuichi <y_iida@] 11854 2005-08-01 21:50 ﹛﹛﹛﹛﹛身﹛身迂[H M <hassy_94@xxxxxx] 11858 2005-08-02 12:33 ﹛﹛﹛﹛﹛身﹛身﹛迂["T.Sasaki" <papasan2] 11865 2005-08-02 22:55 ﹛﹛﹛﹛﹛身﹛身﹛﹛迂[H M <hassy_94@xxxxxx] 11868 2005-08-03 09:47 ﹛﹛﹛﹛﹛身﹛身﹛﹛﹛迂[toki <toki@xxxxxxxxx] 11870 2005-08-03 10:03 ﹛﹛﹛﹛﹛身﹛身﹛﹛﹛﹛迂["T.Sasaki" <papasan2] 11872 2005-08-03 10:51 ﹛﹛﹛﹛﹛身﹛身﹛﹛﹛﹛﹛迂[<numata@xxxxxxxxxx> ] 11873 2005-08-03 11:05 ﹛﹛﹛﹛﹛身﹛身﹛﹛﹛﹛﹛﹛迂["T.Sasaki" <papasan2] 11874 2005-08-03 15:00 ﹛﹛﹛﹛﹛身﹛身﹛﹛﹛﹛﹛﹛﹛迂["T.Sasaki" <papasan2] 11875 2005-08-03 16:10 ﹛﹛﹛﹛﹛身﹛身﹛﹛﹛﹛﹛﹛﹛﹛迆["T.Sasaki" <papasan2] 11877 2005-08-03 18:16 ﹛﹛﹛﹛﹛身﹛身﹛﹛﹛﹛﹛﹛﹛﹛身迂[H M <hassy_94@xxxxxx] 11876 2005-08-03 17:00 ﹛﹛﹛﹛﹛身﹛身﹛﹛﹛﹛﹛﹛﹛﹛迂["Kenichiro Fuji" <k_] 11843 2005-08-01 15:48 ﹛﹛﹛﹛﹛身﹛迂["Tetsuya Hirotsu" <h] DELETE FROM table_name; 匹 AUTO_INCREMENT 襖互賡渝祭今木卅中 11844 2005-08-01 15:58 ﹛﹛﹛﹛﹛身﹛﹛迆["Tetsuya Hirotsu" <h] 11845 2005-08-01 16:24 ﹛﹛﹛﹛﹛身﹛﹛迆[KIshii <kn-ishi@xxxx] -> 11846 2005-08-01 16:28 ﹛﹛﹛﹛﹛身﹛﹛迂["T.Sasaki" <papasan2] 11856 2005-08-02 11:19 ﹛﹛﹛﹛﹛身﹛﹛﹛迂["Tetsuya Hirotsu" <h] 11839 2005-07-31 20:27 ﹛﹛﹛﹛﹛迂[H M <hassy_94@xxxxxx]