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

PBÁ¬½ÓMYSQLÊý¾Ý¿â

È¥mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØodbc connector(http://dev.mysql.com/downloads/connector/odbc/3.51.html)
ÏÂÔØµÄÊÇmysql-connector-odbc-noinstall-3.51.rar
½âѹºóÖ±½ÓÔËÐÐÎļþ¼ÐÖÐµÄ Install.bat Åú´¦ÀíÎļþ
mysql-connectorÓкü¸ÖÖ£¬Ñ¡ÔñÒ»¸ö×Ô¼ºÏ²»¶µÄ¼´¿É¡£
ÔÚxpÖдò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖÆÃæ°å£­¡·¹ÜÀí¹¤¾ß£­¡·ODBCÊý¾ÝÔ´¹ÜÀíÆ÷£©£¬“Ìí¼Ó”°´Å¥£¬È»ºóÔÚÁбíÖÐÑ¡Ôñ“MySQL ODBC 3.51 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Ñ¡ÏÖеõ½¡£
Êý¾Ý´°¿ÚÑ¡ÔñÏàÓ¦µÄÊý¾Ý´°¿Ú¿Ø¼þºó
string getv
getv = dw_1.getitemstring(2,2)
messagebox("ÓÑÇéÌáʾ","È¡³öµÄֵΪ" + getv)//ÏÔʾÊý¾Ý


Ïà¹ØÎĵµ£º

Apache::DBIÓëMYsqlµÄ³ÖÐøÁ¬½ÓÌ«¶àµÄÎÊÌâ

ÎÒ¾­¹ýÕ⼸ÌìÑо¿·¢ÏÖmod_perlÌṩµÄ³ÖÐøÁ¬½Ó²¢²»ÖÇÄÜ£¨Ò²ÐíÊÇÎÒ»¹Ã»ÓÐÕÒµ½¸ü
ºÃµÄ½â¾ö·½°¸£©£¬Èç¹û½Å±¾ÖеIJÎÊýºÍ³õʼ»¯µÄ²ÎÊý²»Ò»Ñù£¬ÔÚÄÚ´æÖлá³öÏÖÁ½¸ö
¾ä±ú¡£
Apache::DBI->connect_on_init("DBI:mysql:mysql:localhost","root","root",
{
PrintError => 1,
RaiseError => 0,
AutoCommit => ......

MYSQLÒѾ­ÉúЧµÄÉèÖúÍ״̬²éѯÃüÁî

ÒÔÏÂÃüÁî¿ÉÒÔÔÚÈκÎÒѾ­Á¬½ÓÉÏMYSQL·þÎñÆ÷µÄ¿Í»§¶ËÉÏÖ´ÐС£
show full processlist ;
kill 57725;#ɱµôÉÏÃæ²éµ½µÄij¸öµ¼ÖÂ×èÈûµÄÁ¬½Ó
SELECT @@profiling;
SET profiling = 1;
SHOW PROFILES;
SHOW PROFILE for QUERY 1;
#ϵͳÉèÖÃ
show variables like '%key%';
show variables like '%key%';
show variables l ......

MySQL ShowÃüÁîµÄʹÓÃ

show tables»òshow tables from database_name;
½âÊÍ£ºÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ
show databases;
½âÊÍ£ºÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ
show processlist;
½âÊÍ£ºÏÔʾϵͳÖÐÕýÔÚÔËÐеÄËùÓнø³Ì£¬Ò²¾ÍÊǵ±Ç°ÕýÔÚÖ´ÐеIJéѯ¡£´ó¶àÊýÓû§¿ÉÒԲ鿴
ËûÃÇ×Ô¼ºµÄ½ø³Ì£¬µ«ÊÇÈç¹ûËûÃÇÓµÓÐprocessȨÏÞ£¬¾Í¿ÉÒԲ鿴ËùÓÐÈ˵Ľø ......

ÅäÖÃMySQLÖ÷´Ó¸´ÖÆ(Replication)


MySQLÖ§³Öµ¥Ïò¡¢Òì²½¸´ÖÆ£¬¸´Öƹý³ÌÖÐÒ»¸ö·þÎñÆ÷³äµ±Ö÷·þÎñÆ÷£¬¶øÒ»¸ö»ò¶à¸öÆäËü·þÎñÆ÷³äµ±´Ó·þÎñÆ÷¡£Ö÷·þÎñÆ÷½«¸üÐÂдÈë¶þ½øÖÆÈÕÖ¾Îļþ£¬²¢Î¬»¤ÈÕÖ¾ÎļþµÄÒ»¸öË÷ÒýÒÔ¸ú×ÙÈÕ־ѭ»·¡£µ±Ò»¸ö´Ó·þÎñÆ÷Á¬½Óµ½Ö÷·þÎñÆ÷ʱ£¬Ëü֪ͨÖ÷·þÎñÆ÷´Ó·þÎñÆ÷ÔÚÈÕÖ¾ÖжÁÈ¡µÄ×îºóÒ»´Î³É¹¦¸üеÄλÖᣴӷþÎñÆ÷½ÓÊÕ´ÓÄÇʱÆð·¢ÉúµÄÈκθüУ¬È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ