VB6.0ÈçºÎÓà libmySQL.dll API·ÃÎÊMYSQLÊý¾Ý¿â
MYSQL Ó¦ÓÃÊ®·Ö¹ã·¶£¬ºÜ¶àÍøÕ¾¼¸ºõ¶¼ÔÚÓÃËû£¬ÒòΪËûµÄСÇɺÍÁé»îÐԵȷ½ÃæÈÃÎÒ¾ö¶¨Òª¶ÔËû½øÐÐÑо¿£¬µ½ÏÖÔÚÒѾ³É¹¦µÄ²»Óþ¹ýODBC£¬ADOµÈ·½Ê½¾Í¿ÉÒÔ¶ÁÈ¡ºÍ¸üÐÂÊý¾Ý¡£
ºÃÁ˲»¶àÂÞ࣬ÒÔÏÂÎÒÀ´½éÉÜ×ܸö³ÌÐòµÄϸ½Ú:
£¨Ò»£©APIÉùÃ÷
1. '·ÖÅä»ò³õʼ»¯ÊʺÏmysql_real_connect()µÄÒ»¸öMYSQL¶ÔÏñ¡£
Public Declare Function mysql_init Lib "libmySQL" (ByVal lMysql As Long) As Long
2. '¹Ø±ÕÒ»¸öÒÔÇ°´ò¿ªÁ˵ÄÁ¬½Ó
Public Declare Sub mysql_close Lib "libmySQL" (ByVal lMysql As Long)
3. 'ÄÜÓÃì¶ÉèÖöîÍâÁ¬½ÓÑ¡Ïî²¢ÇÒÓ°ÏìÒ»¸öÁ¬½ÓµÄÐÐΪ¡£
'Õâ¸öº¯Êý¿ÉÒÔ±»¶à´Îµ÷ÓÃÀ´ÉèÖöà¸öÑ¡Ïî¡£
'mysql_options()Ó¦¸ÃÔÚmysql_init()Ö®ááºÍmysql_connect()»òmysql_real_connect()֮ǰµ÷Óá£
'option²ÎÊýÊÇÄãÏëÒªÉèÖõÄÑ¡Ï
'arg ²ÎÊýÊÇÑ¡ÏîµÄÖµ¡£Èç¹ûÑ¡ÏîÊÇÒ»¸öÕûÊý£¬ÄÇ÷áargÓ¦¸ÃÖ¸ÏòÕûÊýÖµ¡£
Public Declare Function mysql_options Lib "libmySQL" _
(ByVal lMysql As Long, _
ByVal lOption As Long, _
ByVal sArg As String) As Long
4. ÉèÖÿͻ§¶Ë·ÃÎʵÄ×Ö·û¼¯ £¨Õâ¸öºÜÖØÒª£¬·ÃÎÊÖÐÎÄʱһ¶¨ÒªÓÃÕâ¸ö£©
Public Declare Function mysql_set_character_set Lib "libmySQL" (ByVal lMysql As Long, ByVal cs_name As String) As Long
5.Áª½ÓÊý¾Ý¿â
Public Declare Function mysql_real_connect Lib "libmySQL" _
(ByVal lMysql As Long, _
Ïà¹ØÎĵµ£º
ΪÁ˸øG×¼±¸ÂÛÎÄ£¬ÏëÖ±½ÓÓÃÒ»¸öÏîÄ¿¡£
ÄǸöÏîÄ¿ÔÀ´ÓõÄÊý¾Ý¿âÊÇORACLE£¬µ«ËûµÄ»úÆ÷ÅäÖõͣ¬ÄÚ´æÖ»ÓÐ256M£¬ÅÜORALCEÁËÌ«³ÔÁ¦ÁË¡£ÓÚÊǾÍÏë°ÑÊý¾Ý¿â²¿·ÖÒÆÖ²µ½MYSQL¡£×Ô¼ºÏÈ
×öʵÑ飬ÄêÇ°¾Í×°ÁË£¬ÏÖÔÚÏë×öÒÆÖ²£¬ROOTÃÜÂë¸øÍüÁË¡£µ¹ÊÇ¿ÉÒÔÖØ×°£¬¿ÉÄÇÒ»¶¨²»ÊÇ×î¼Ñ½â¾ö·½°¸¡£
UNIX°æ
1.ÏÈÍ£µômysql
# /etc/rc.d/init.d/mys ......
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:jee="http://www.springframework.org/schema/jee"
&nbs ......
£¨1£©»ñÈ¡MysqlÊý¾Ý¿âµÄrootÓû§ÃÜÂëºÍÊý¾Ý¿âÓû§Ãû
£¨2£©ÉÏ´«ÌáȨphpľÂí£¬Í¨¹ýÁ¬½Ó3389¿ÉÒÔÖªµÀ·þÎñÆ÷ÊÇ2003ϵͳ
£¨3£©udf.dll¶ÔÓ¦²Ù×÷ϵͳ
C:\Winnt\udf.dll 2000
C:\Windows\udf.dll 2003
£¨4£©ÉèÖÃÏàÓ¦µÄ·¾¶ºóÖ±½Óµ¼³ö¡£
£¨5£©Ö´ÐÐÒÔÏÂÃüÁî
create function cmdshell returns string soname 'udf ......
½ñÌì¸ãÁËÒ»Ì죬ÖÕÓڸ㶨ÁË¡£
¶ÔÓÚMysqlÓÐÁ½ÖÖģʽ£¬MYISAMÓëINNODB
Èç¹ûÊÇMYISAMµÄ»°£¬ÔÚdataĿ¼ÏÂÀï»á.frm .myd .myi ÈýÖÖÎļþ£¬ÄÇôֱ½Ó°ÑDATAÒƹýÈ¥£¬ÅäÖúÃȨÏ޾ͿÉÒÔ»¹ÔÁË¡£
Èç¹ûÊÇINNODBµÄ»°£¬ÄÇÊÇÏ൱µÄ·³°¡¡£ÔÚdataĿ¼ÏÂÖ»ÓÐ.frm(ÕâÖ»ÊÇÒ»¸öÊý¾Ý¸ñʽ£©£¬Õâ¸öÒƹýÈ¥ºó£¬ÊÇÎÞ·¨»¹ÔÔʼÊý¾ÝµÄ¡£
ÕæÕýµÄÊý¾ÝÊÇÕ ......
information_schema¿âÖаüº¬Á˶ÔÕû¸öÊý¾Ý¿âµÄºÜ¶àͳ¼ÆÐÅÏ¢£¬¿ÉÒÔͨ¹ý²é¿´ËüÃÇ£¬À´µÃµ½Êý¾Ý¿âÏà¹ØµÄÐÅÏ¢¡£
mysql> use information_schema;
Database changed
mysql> select count(1) as tables, concat(round(sum(table_rows)/1000000,2),'M') as rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') a ......