Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

pbÁ¬½ÓmySqlÊý¾Ý¿â

PBÁ¬½ÓMySQLÊý¾Ý¿â
 
È¥mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØodbc connector(http://dev.mysql.com/downloads/connector/odbc/)
ÏÂÔØµÄÊÇmysql-connector-odbc-noinstall-5.1.6-win32.zip
½âѹºóÖ±½ÓÔËÐÐÎļþ¼ÐÖÐµÄ Install.bat Åú´¦ÀíÎļþ
mysql-connectorÓкü¸ÖÖ£¬Ñ¡ÔñÒ»¸ö×Ô¼ºÏ²»¶µÄ¼´¿É¡£
ÔÚxpÖдò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖÆÃæ°å£­¡·¹ÜÀí¹¤¾ß£­¡·ODBCÊý¾ÝÔ´¹ÜÀíÆ÷£©£¬“Ìí¼Ó”°´Å¥£¬È»ºóÔÚÁбíÖÐÑ¡Ôñ“MySQL ODBC 5.1 Driver”È»ºó¸ù¾ÝÌáʾÌîдÒÑÓеÄmysqlÊý¾Ý¿âµÄÏà¹ØÐÅÏ¢¼´¿É¡£“OK” Êý¾ÝÔ´µÄÌí¼ÓÍê³É¡£
´ò¿ªPB£­¡·¿ØÖÆÃæ°åÖÐDatabse»­°å->ODB ODBC(ÓÒ¼ü)£­¡·New profile->connection Ñ¡ÏÖÐÌîдmysqlÊý¾Ý¿âÏà¹ØÐÅÏ¢ ¼´¿É¡£
 
// Profile xxx
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=Mysql_odbc;UID=root;PWD=root'"
connect using sqlca;
ÒÔÉÏÓï¾ä¿ÉÒÔ´ÓdatabaseÃæ°åÖÐpreviewÑ¡ÏÖеõ½¡£


Ïà¹ØÎĵµ£º

¶ÔmysqlµÄorder by¼°limitÓÅ»¯ÒªÊÊÊý¾ÝÇé¿ö¶ø¶¨

ÒÔÏÂÕâÆªÎÄÕÂÂÛÊöÉÏÔÚʲôÇé¿öÏÂ×Ó²éѯ±ÈÒ»°ãµÄÄÚÁ¬½Ó²éѯ¸ü¼Ó¿ìËÙ
http://www.mysqlperformanceblog.com/2010/03/18/when-the-subselect-runs-faster/
ÒÔÏÂÊÇÎÒ¶ÔmysqlµÄorder byºÍlimitÓÅ»¯µÄ½¨Ò飬ҪÊʱíµÄÊý¾ÝÁ¿ºÍÓÃÀ´¹ýÂËÁеÄΨһֵµÄ¸öÊý¶ø¶¨
£¨1£©where×Ó¾äÖÐÓÃÀ´¹ýÂ˽á¹ûµÄÁÐËùÔÚË÷ÒýµÄcadinalityºÜС£¬¼´ÓÃÏà¹Ø ......

windows7ϰ²×°apache+php+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
° ......

Ò»¸öMYSQLµÄСÎÊÌâ

Ò»ÏÂÊÇÒ»¸öSQLµÄСÎÊÌ⣬À§ÈÅÁË3·ÖÖÓ£¬Ð´ÏÂÀ´¼Ç¼һÏ¡£
Êý¾Ý¿âÊÇMYSQL 5, ±íµÄ½á¹¹ºÜ¼òµ¥, ¾ÍÒ»¸ö×Ö¶ÎÊÇabc£¬ÕûÐÍ¡£
Ò»ÏÂÓï¾äÔËÐеĽá¹ûÊÇÒ»ÑùµÄ¡£×Ô¼º²»ÁôÉñ£¬µ¼ÖÂÀ§ÈÅÁË3·ÖÖÓ¡£
select * from table1 from abc = '123'
select * from table1 from abc = '123_1'
ÒÔÉÏÓï¾äÔ­À´ÊDzéÕÒÊÇ·ñÊý¾Ý´æÔÚ£¬½á¹û123_1ºÍ1 ......

Mysql³£ÓÃÃüÁî

ËäÈ»ºÜ¶àÈËÓÃmysql front£¬ µ«ÊǸöÈ˾õµÃmysql»¹ÊÇÃüÁîÐÐϱȽϺÃÓ㬱Ͼ¹Êý¾Ý¿âÔÚÃüÁîÐÐϲÙ×÷±È½ÏÍõµÀ¶øÇÒmysqlÍêÈ«Ãâ·Ñ¡£¡£
ÏÂÃæ½éÉÜһЩmysqlÃüÁîÐÐϳ£ÓõÄÃüÁÓÐһЩÊý¾Ý¿â»ù´¡µÄ£¬¼´Ê¹ÊǵÚÒ»´ÎÓÃmysql¶ÔÕÕÏÂÃæµÄÃüÁî²Ù×÷Ò²ÍêÈ«¿ÉÒÔ£¬Èç¹ûÎÒ·¢ÏÖ»¹ÓÐÆäËüÃüÁîÒ²ÊǾ­³£Óõ½µÄÎÒ»áÂ½Ðø¸üС£¡£¡£
·þÎñÆ÷£º
1. Æô¶¯m ......

PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö

PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö
ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕß¶¼Í³Ò»²ÅÐУ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ