Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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)//ÏÔʾÊý¾Ý


Ïà¹ØÎĵµ£º

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 ÃüÁî

²é¿´linuxÉÏÊÇ·ñ°²×°mysql
rpm -qa|grep mysql  ;Èç¹ûÓÐmysql°ü£¬±¾»úÓÐmysql£»
service mysqld status;²é¿´mysqlµÄ״̬£¬Èç¹ûΪstop״̬£¬¿ÉÒÔÓÃservice mysqld startÀ´Æô¶¯£»
怬
   mysql  -h Ö÷»úµØÖ·  -uÓû§Ãû -pÃÜÂ룻µÇ¼³É¹¦ºó½øÈëmysql״̬£»
Êý¾Ý¿â²Ù×÷
show databases£»ÏÔʾµ± ......

MySQLѧϰ±Ê¼Ç

Ò»¡¢MySQL»ù±¾ÃüÁºÏ£º
1¡¢  create database mydata£»//´´½¨Êý¾Ý¿â
2¡¢  use mydata; //ÔÚmydataÕâ¸öÊý¾Ý¿âϹ¤×÷
3¡¢  create table dept    //ÔÚmydataÊý¾Ý¿âÏ´´½¨±ídept
(
deptno int primary key,
dname varchar(14),
loc varchar(13)
);
 
create table emp  / ......

mysql µÄdelimiter

ÎÒÔÚ EMS SQL Manager 2005 for MySQL Õâ¸ö MySQL ͼÐοͻ§¶ËÏ¿ÉÒÔ˳ÀûÔËÐС£µ«ÊÇÔÚ SQLyog MySQL GUI v5.02 Õâ¸ö¿Í»§¶Ë¾Í»á³ö´í¡£×îºóÕÒµ½Ô­ÒòÊÇûÓÐÉèÖúà delimiter µÄÎÊÌ⡣ĬÈÏÇé¿öÏ£¬delimiter “;” ÓÃÓÚÏò MySQL Ìá½»²éѯÓï¾ä¡£ÔÚ´æ´¢¹ý³ÌÖÐÿ¸ö SQL Óï¾äµÄ½áβ¶¼Óиö “;”£¬Èç¹ûÕâʱºò£¬Ã¿ ......

MysqlÊý¾ÝÀàÐÍ


ÊýÖµÀàÐÍ
¡¡¡¡MySQL
µÄÊýÖµÊý¾ÝÀàÐÍ¿ÉÒÔ´óÖ»®·ÖΪÁ½¸öÀà±ð£¬Ò»¸öÊÇÕûÊý£¬ÁíÒ»¸öÊǸ¡µãÊý»òСÊý¡£Ðí¶à²»Í¬µÄ×ÓÀàÐͶÔÕâЩÀà±ðÖеÄÿһ¸ö¶¼ÊÇ¿ÉÓõģ¬Ã¿¸ö×ÓÀàÐÍÖ§³Ö²»Í¬´óСµÄÊý¾Ý£¬²¢ÇÒ
MySQL ÔÊÐíÎÒÃÇÖ¸¶¨ÊýÖµ×Ö¶ÎÖеÄÖµÊÇ·ñÓÐÕý¸ºÖ®·Ö»òÕßÓÃÁãÌî²¹¡£
¡¡¡¡±íÁгöÁ˸÷ÖÖÊýÖµÀàÐÍÒÔ¼°ËüÃǵÄÔÊÐí·¶Î§ºÍÕ¼ÓõÄÄÚ´æ¿Õ¼ä¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ