mysql:8000
From: ·§ÅĽ½»ÖÇ· ¥Î¡¼¥È£Ð£Ã <·§ÅĽ½»ÖÇ· ¥Î¡¼¥È£Ð£Ã <gf2d914@xxxxxxxxxx>>
Date: Tue, 8 Jul 2003 20:17:36 +0900
Subject: [mysql 08000] LOCK / UNLOCK ¤Ë¤Ä¤¤¤Æ
¤³¤ó¤Ë¤Á¤Ï¡¢·§ÅĤȿ½¤·¤Þ¤¹¡£
¸½ºß¡¢£Ö£Ã¡Ü¡Ü¤Ç³«È¯¤ò¹Ô¤Ã¤Æ¤¤¤ë¤Î¤Ç¤¹¤¬¡¢¼¡¤Î¤è¤¦¤Ê¤³¤È¤ò¼Â¸½¤¹¤ë¤Î¤Ë¼ºÇÔ¤·
¤Æ¤¤¤Þ¤¹¡£
¡¡
/---------------------------------------------------------------------/
¤¢¤ë¡¢ÅöÆü¥ì¥³¡¼¥É¡¡"IDTable ÅöÆüÆüÉդΥ쥳¡¼¥É" ¤òÊ£¿ô¤Î¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤«
¤é¹¹¿·¤¹¤ë°Ù¡¢
£Ì£Ï£Ã£Ë¡¿£Õ£Î£Ì£Ï£Ã£Ë¤ò»ÈÍѤ·¤è¤¦¤È¹Í¤¨¤Æ¤¤¤Þ¤¹¡£
strSQL = _T("LOCK TABLES IDTable WRITE") ;
mysql_real_query( mysqlMAGConn, strSQL, strSQL.GetLength() ) ; ----> Æɤß
½ñ¤¥í¥Ã¥¯
¡¡¡¡¡¡
"IDTable" ¤ÎÅöÆü¥ì¥³¡¼¥É¤òÆɤ߹þ¤ß¥Õ¥£¡¼¥ë¥É¤ò¹¹¿·
UPDATE ¤Ë¤Æ¥ì¥³¡¼¥É¹¹¿·
strSQL = _T("UNLOCK TABLES") ;
mysql_real_query( mysqlMAGConn, strSQL, strSQL.GetLength() ) ; -----> ¥í¥Ã
¥¯²ò½ü
/---------------------------------------------------------------------/
¤Î¤è¤¦¤Ê¤³¤È¤ò¤·¤Æ¤¤¤Þ¤¹¡£
¤·¤«¤·¡¢¥Ç¡¼¥¿¤ò¸«¤Æ¤ß¤ë¤È¹¹¿·¤·¤¿¥Õ¥£¡¼¥ë¥É¤¬²¿¤âÊѤï¤Ã¤Æ¤¤¤Þ¤»¤ó¡¥¡¥¡¥¡¥
¤É¤Î¤è¤¦¤Ë¡¡LOCK/UNLOCK¡¡¤¹¤ë¤Î¤¬Àµ¤·¤¤¤Î¤Ç¤·¤ç¤¦¤«¡©
¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
¢£´Ä¶
¡¡¡¡Windows XP Pro + .NET Stadio 2003 VC++
MySQL Ver.4.0.13
/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/
¡¡·§ÅÄ¡¡½½»ÖÇ· ¡¡¡¡¡¡¡¡¡¡¡¡ E-mail : <mailto:kumada@xxxxxxxxxx>
kumada@xxxxxxxxxx
/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/~/_/
-> @ 8000 2003-07-08 20:17 [·§ÅĽ½»ÖÇ· ¥Î¡¼¥È£Ð£] LOCK / UNLOCK ¤Ë¤Ä¤¤¤Æ 8001 2003-07-09 06:51 ¨²[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] 8011 2003-07-10 10:49 ¨±["¶¶ËÜ ¹ë" <gou@xxxxx] MySQL ¤Î¥µ¡¼¥Ó¥¹¤¬µ¯Æ°¤·¤Ê¤¤ 8012 2003-07-10 11:36 ¡¡¨±[<yaemon@xxxxxxxxxx> ]