¼Ç¼MYSQLµÄÊý¾ÝÐÞ¸Ä
ÇëÎÊ¿ÉÒÔÀ¹½ØMYSQLµÄÊý¾ÝÐ޸IJ»£¿
ÎÒÏÖÔÚÓÐÒ»¸öPHP+MYSQLϵͳ ÎÒÏÖÔÚÏë¿´¿´Ìí¼ÓÒ»¸ö»áÔ±»á¶ÔmysqlÊý¾Ý±í½øÐÐÄÄЩÐ޸Ļò²åÈë ÇëÎÊÎÒ¿ÉÒÔÔÚÌí¼Ó»áÔ±µÄʱºò mysql¼Ç¼Ï¶ÔÄÄЩ±í½øÐÐÁËÐ޸ĻòÕß²åÈë²»£¿
·ÖÎöPHPÔ´ÎļþºÜÂé·³ ÓÐЩ»¹zend¼ÓÁËÃܵÄ55
´ò¿ªÈÕÖ¾¼´¿É¼Ç¼SQLÓï¾ä
[mysqld]
log=123.log
ÎÒÔÚ[mysql]ÏÂÃæ¼ÓÁËÕâ¸ö£º
#LOG
log=mylog.log
È»ºóÖØÆôÁËmysql
show variables like 'log';
È»¶ølog»¹ÊÇOFF ÊDz»ÊÇÄÄÀïû¿ªÆô³É¹¦£¿
ÄãµÄmysql °æ±¾ÊǶàÉÙ£¿
select version()
select version();
5.0.22-community-nt;
»¹ÓÐÔÙÈõÈõµÄÎÊÏ Ôõô¸´ÖÆcmdÀïµÄÄÚÈÝ£¿
OKÁË ÔÀ´ÎÒ·Å´íÁË Òª·ÅÔÚmysqldÏÂ..55
ÈçºÎ²é¿´ÈÕ־Ĩ£¿±ÈÈç²é¿´ÎÒµÄmylog.log
ÎÒÔõôÔÚwinÉÏËÑË÷²»µ½Õâ¸öÎļþ£¿
ÔÚÄãµÄdatadir Ŀ¼ÖÐ
¼Ç¼±¾´ò¿ª
¹þ¹þ ÓÐÓÃÁË Ð»Ð»acmain_chm ллWWWWA лл´ó¼Ò
ºÇºÇ£¬À´ÍíÁË
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì² ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......