mysql:11876
From: "Kenichiro Fuji" <"Kenichiro Fuji" <k_fuji@xxxxxxxxxx>>
Date: Wed, 3 Aug 2005 17:00:36 +0900
Subject: [mysql 11876] Re: Ä´ºº·ë²Ì
ÉڻΤȿ½¤·¤Þ¤¹¡£ º£Æü¤Á¤ç¤Ã¤Èº¤¤Ã¤¿¤Î¤Ç¡¢¼ÁÌä¤ËÊؾ褷¤Æ¼ÁÌ䤷¤Æ¤·¤Þ¤¤¤Þ¤¹¡£ #¤Þ¤º¤«¤Ã¤¿¤é¡¢Ê̤Υ¹¥ì¤Ë¤·¤Þ¤¹¤Î¤Ç¡¢¤´»ØŦ¤¯¤À¤µ¤¤¡£ Á°Äó MySQL¤òLinux¾å¤ÇΩ¤Æ¤Æ»È¤Ã¤Æ¤¤¤Þ¤¹¡£ ¥Ð¡¼¥¸¥ç¥ó¤Ï4.0.18¤Ç¤¹¡£ #4.1¤Ë¾å¤²¤ë¤ÈÉݤ½¤¦¤À¤Ã¤¿¤Î¤Ç¾å¤²¤Æ¤Þ¤»¤ó¡£ ʸ»ú¥³¡¼¥É¤Ïeuc¤Ç¤¹¡£ ¤³¤³¤ÇÊ̤ζÈ̳¤ÇMSSQL¥µ¡¼¥Ð¤ò¹½ÃÛ¤·¤¿Æ±Î½¤¬µï¤Æ¡¢ »ä¤¬»È¤Ã¤Æ¤¤¤ëMySQL¤«¤é¥Ç¡¼¥¿¤ò°ú¤ÃÄ¥¤ê¤¿¤¤¡¢¤È¸À¤Ã¤Æ¤¤Þ¤·¤¿¡£ ¤ä¤Ã¤¿¤³¤È mysql.com¤«¤émyodbc3.51.11-2¤òÆþ¼ê http://dev.mysql.com/downloads/connector/odbc/3.51.html MSSQL¥µ¡¼¥Ð¤¬Î©¤Ã¤Æ¤¤¤ë¥Þ¥·¥ó¡ÊWin2K¥µ¡¼¥Ð¡Ë¤Ë¤³¤ì¤òƳÆþ odbc¤ÎÀßÄê¸åexcel2000/access2000¤Ë¤ÆMySQL¤Î¥Æ¡¼¥Ö¥ë¤òÆɤ߽Ф·¤Æ¤ß¤ë¤Èʸ»ú²½ ¤±¡£ #Åö¤¿¤êÁ°¤Ç¤¹¤¬¡¢¿·¤·¤¤¤Î¤Ç¤Á¤ç¤Ã¤È¤À¤±´üÂÔ¤·¤¿¤ó¤Ç¤¹¡Ê´À ¥½¥Õ¥È¥¨¡¼¥¸¥§¥ó¥·¡¼¤µ¤ó¤Ë¤Ïmyodbc3.51.06ÍѥѥåÁ¤·¤«Ìµ¤¤¤Î¤Ç¤³¤ì¤òÅö¤Æ¤¿¡£ http://www.softagency.co.jp/products/mysql/win_myodbc.html excel2000¤Ç¤Ïʸ»ú²½¤±¤¬Ä¾¤Ã¤¿¡£ MSSQL¥µ¡¼¥Ð¤ËMySQL¾å¤Î¥Æ¡¼¥Ö¥ë¤ò¥¤¥ó¥Ý¡¼¥È¤·¤¿¤È¤³¤í¡¢Ê¸»ú²½¤±¤¬ºÆȯ¡£ ¥½¥Õ¥È¥¨¡¼¥¸¥§¥ó¥·¡¼¤µ¤ó¤Î¥µ¥¤¥È¤ò¤è¤¯Ãµ¤¹¤È¡¢ÀΤΥߥ顼¡©¤«¤émyodbc3.51.08 ¤òȯ¸«¡£ http://download.softagency.net/MySQL/Downloads/MyODBC3/ myodbc3.51.11-2¤òºï½ü¡¢myodbc3.51.08¤ò¥¤¥ó¥¹¥È¡¼¥ë¸å¡¢3.51.06ÍѥѥåÁ¤ò¾å½ñ ¤¤ÇƳÆþ¡£ odbc¤ÎÀßÄê¸å¡¢excel¤Èaccess¤Çodbc¤Ë¤è¤ëÆɤ߽Ф·¤¬Ê¸»ú²½¤±¤»¤º½ÐÍ褿¡£ MSSQL¥µ¡¼¥Ð¤Ø¤Î¥¤¥ó¥Ý¡¼¥È¤âº£Å٤ϼºÇÔ¤»¤º½ÐÍ褿¡£ ¤Ç¡¢²¿¤¬Ê¹¤¤¿¤¤¤Î¤«¡© ># SOFT AGENCY¤µ¤ó°Ê³°¤ÇÆüËܸìÂбþ¤Î libmySQL.dll ¤òÇÛÉÛ¤µ¤ì¤Æ¤¤¤ë¤È¤³¤í¤Ï ># ¤¢¤ê¤Þ¤¹¤Ç¤·¤ç¤¦¤«¡© ¤Þ¤º¡¢¤³¤ì¤òÃΤꤿ¤«¤Ã¤¿¤ó¤Ç¤¹¡£ ÀΤΥߥ顼¡©¤«¤é¼è¤Ã¤¿3.51.08¤Ç¤âÆ°¤¤Þ¤·¤¿¤¬¡¢ËÜÅö¤Ë¤½¤ì¤Ç¤¤¤¤¤Î¤Ç¤·¤ç¤¦¤« ¡© ¥°¡¼¥°¥ëÀèÀ¸¤Ë¤âʹ¤¤¤Æ¤ß¤Þ¤·¤¿¤¬¡¢3.51.06¤Îµ»ö¤·¤«È¯¸«¤Ç¤¤Þ¤»¤ó¤Ç¤·¤¿¡£ #MySQL¤ÈMSSQL¤ò¥ê¥ó¥¯¤·¤Æ»È¤¦¤Ê¤ó¤Æ¤Î¤¬¥¢¥ì¤À¤È¤¤¤¦¤Î¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡£ MySQL¤ÎËܲȤǤϡ¢¦ÁÈǤΤ褦¤Ç¤¹¤¬5.0.0¤¬¤Ç¤Æ¤¤¤ë¤è¤¦¤Ç¤¹¡£ http://dev.mysql.com/downloads/connector/odbc/5.0.html ¤³¤ì¤ò»î¤µ¤ì¤¿Êý¤Ï¤¤¤é¤Ã¤·¤ã¤¤¤Þ¤¹¤«¡© ÉÔí¿¤Ê¼ÁÌä¤Ç¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¤¬¡¢¥Ý¥¤¥ó¥¿¤Ê¤É¤ª¼¨¤·¤¤¤¿¤À¤±¤ì¤Ð¹¬¤¤¤Ç¤¹¡£
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]