×Ô¼ºÈçºÎÕýÈ·»ñÈ¡MYSQLµÄADOÁ¬½Ó×Ö·û´®
ÔÚ×ÀÃæÉÏн¨Ò»¸ö¿ÕµÄÎı¾Îļþmysql.txt,ÖØÃüÃûΪmysql.udl,Ë«»÷Õâ¸ömysql.udlÎļþ£¬´ò¿ª“Êý¾Ý¿âÁ¬½ÓÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ìṩ³ÌÐò”ҳѡÔñ”Micrsoft Ole DB Provider for ODBC Drivers“£¬ µã»÷ÏÂÒ»²½£¬ÔÚ“Á¬½Ó”Ò³µÄ,"Ö¸¶¨Êý¾ÝÔ´"Ñ¡Ôñ"ʹÓÃÁ¬½Ó×Ö·û´®",µã»÷“±àÒ딣¬µ¯³ö“Ñ¡ÔñÊý¾ÝÔ´”£¬ÔÚ“ÎļþÊý¾ÝÔ´”Ò³Öеã»÷”н¨“£¬ÔÚ´´½¨ÐÂÊý¾ÝÔ´Ñ¡ÔñMYSQLµÄÇý¶¯³ÌÐò”MySQL ODBC 5.1 Driver",µã»÷“ÏÂÒ»²½”£¬µã»÷"ä¯ÀÀ",ÔÚ”Áí´æÎª“¶Ô»°¿òÖÐÎļþÃûÖÖдÈë“mysql",µã»÷”ÏÂÒ»²½“£¬µã»÷”Íê³É“£¬ÔÚ"MySQL Connnettor/ODBC Data Source Configuration"¶Ô»°¿òÖа´ÐèÇó£¨ÈçÏÂͼ£©
µã»÷“Test”£¬¿´Á¬½ÓÊÇ·ñ³É¹¦£¬Á¬½Ó³É¹¦»áÓиö”Connenction successful“Ìáʾ¿ò£¬ÐèÒª¸üÏêϸµÄÉèÖõã»÷“Details”£¬µã»÷”OK“£¬ÉèÖÃÍê³É¡£·µ»Ø“Êý¾Ý¿âÁ¬½ÓÊôÐÔ”¶Ô»°¿ò£¬µã»÷È·¶¨±£´æÁ¬½Ó×Ö·û´®¡£
Ïà¹ØÎĵµ£º
×é³ÉLVS×îÖØÒªµÄ²¿·ÖÓÐÈý¸ö£ºÇëÇó·Ö·¢·þÎñÆ÷¡¢´¦Àí·þÎñÆ÷¡¢¹²Ïí´æ´¢¡£
µäÐ͵ÄWeb¼¯Èº²¢²»ÐèÒª¹²Ïí´æ´¢£¬Ö»ÓÐÇëÇó·Ö·¢·þÎñÆ÷ºÍ´¦Àí·þÎñÆ÷£¬ÈçÏÂͼËùʾ£º
Èç¹ûÍê³ÉÇëÇóÐèÒª»ùÓÚÊý¾Ý£¬ÄÇô¹²Ïí´æ´¢¾ÍÊÇLVS±ØÐëµÄ×é¼þÁË¡£LVSÓʼþ·þÎñÆ÷¼¯ÈºÈçÏÂËùʾ£º
ĿǰÄÜÓ¦ÓÃÓÚLVSµÄMySQL¼¯ÈºÖ»ÄÜÊÇNDB Cluster£¬ÒòΪMySQLÖÚ¶àµÄ´æ´¢ÒýÇæ ......
×î½üÐÂÂòÁ˸öµçÄÔ£¬ÏµÍ³ÊÇwindows7£¬window7ÔÚ½çÃæ£¬¹¦ÄÜ·½Ã涼ͦÈÃÈËÂúÒâµÄ£¬¸Ð¾õºÜˬ£¬²»Ë¬µÄÊÇÓÖÒªÖØÐ°²×°»·¾³ÁË¡£
ËùÓÐÈí¼þ¾ù°²×°ÔÚF:\server\ÏÂ
apacheĿ¼£ºF:\server\apache2.2
phpĿ¼£ºF:\server\php
msyqlĿ¼£ºF:\server\mysql
Ò»¡¢°²×°apache
°²×°apacheµÄ°æ±¾ÊÇ£ºhttpd-2.2.15-win32-x86-no_ssl.msi
° ......
http://hi.baidu.com/xiyouwang/blog/item/9f15bbee99b0ce202df5349e.html
ÏÖÔڵĻ¥ÁªÍøÉÏ£¬ºÜ¶àÍøÕ¾¶¼ÌṩÁËÈ«ÎÄËÑË÷¹¦ÄÜ£¬ä¯ÀÀÕß¿ÉÒÔͨ¹ýÊäÈë¹Ø¼ü×Ö»òÕßÊǶÌÓïÀ´ËÑË÷ÌØ¶¨µÄ×ÊÁÏ¡£ÔÚPHP+MySQL¹¹¼ÜµÄÍøÕ¾ÖУ¬Í¨³£µÄ×ö·¨ÊÇͨ¹ýSELECT²éѯµÄLikeÓï¾äÀ´½øÐÐËÑË÷£¬ÕâÒ»°ì·¨´æÔÚËÑË÷²»¹»¾«È·¡¢ÒÔ¼°Ð§Âʷdz£µÍϵÄȱµã¡£±ÈÈç¶Ô ......
delimiter // ¸Ä±ä½ç¶¨·û Ϊ//
ÁгöËùÓÐÊý¾Ý¿â show databases;
ÁгöËùÓÐÊý¾Ý±í show tables;
¸Ä±äÁ¬½ÓÊý¾Ý¿â use databaes
²åÈë¼Ç¼ insert into users(UserName,Password) values('ivwshjj','123456');
ɾ³ý¼Ç¼ delete from users  ......