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

mysql ÐÐתÁÐÎÊÌâ

Õ⼸ÌìËù×÷µÄ¹¤×÷Éæ¼°µ½Êý¾Ý¿âÐÐתÁеÄÎÊÌâ
¼Ç¼һϳöÏֵĴíÎó£¬ÒÔÃâÒÔºóÔÙ·¸
¾ÙÍøÉÏ×îͨË×µÄÀý×Ó°É
Name Subject Result
ÕÅÈý    ÓïÎÄ         80
ÕÅÈý    Êýѧ         90
ÕÅÈý    ÎïÀí         85
ÀîËÄ    ÓïÎÄ         85
ÀîËÄ    Êýѧ         92
ÀîËÄ    ÎïÀí         82
ÏëÒªµÄ½á¹û
ÐÕÃû ÓïÎÄ Êýѧ ÎïÀí
ÕÅÈý  80  90    85
ÀîËÄ  85  92    82  
ÕýÈ·µÄд·¨
select name as ÐÕÃû,
max
(case when subject='ÓïÎÄ' then result end) as ÓïÎÄ,
max
(case when subject='Êýѧ' then result end) as Êýѧ,
max
(case when subject='ÎïÀí' then result end) as ÎïÀí
from T1 group by
name
×ʼдµÄʱºò²»ÖªµÀmax
º¯ÊýÓÐʲôÓÃ
¶øÇÒҲûÓмÓ
group by
×îºóµÄ½á¹ûÊÇ
ÐÕÃû     ÓïÎÄ      Êýѧ      ÎïÀí
ÕÅÈý      80
ÕÅÈý                 90        
ÕÅÈý                             85
ÀîËÄ      85  
ÀîËÄ                 92       
ÀîËÄ                             82
·¢ÏÖ½á¹û²»¶Ô£¬È»ºó¼ÓÁË
group byÓï¾ä
½á¹ûÊÇ
ÕÅÈý      80
ÀîËÄ      85


Ïà¹ØÎĵµ£º

¹ØÓÚMySQLµÄ1067´íÎó½â¾ö·½·¨

 ¡ù ¹ØÓÚMySQLµÄ1067´íÎó½â¾ö·½·¨ ¡ù
ÄÚÈÝ£º
*************
1
°²×°MYSQLºó¸ü¸ÄÁËROOTµÄÃÜÂëºóÓÃ
net startmysql
Æô¶¯Ê±ÎÒ¾ÍÓöµ½ÁËÕâÑùµÄÎÊÌ⣮ʹÓÃÒÔÏÂÃüÁîºó
c:\mysql\bin\mysqladmin-u root -p shutdown
ÔÙnet start mysql¾ÍûÓÐÕâ¸ö´íÎóÌáʾÁË!
*************
2
MySQLµÄ1067´íÎó
Q£ºÎÒµÄMysqlÅöµ½ÁË 1 ......

MYSQLµÄһЩС¼Ç

ÏÂÎç¿´ÁËÒ»¶ÎPHP100µÄÊÓÆµ¡£
Ò²ËãÓеãÊÕ»ñ¡£
ÀïÃæµÄÒ»¶Î×ÔдµÄfindallµÄSQLº¯Êý£º
public function findall($table) {
$this->query("SELECT * from $table");
}

Ô­À´Ö»ÊÇÕâô¼òµ¥£¬¸Õ»¹ÔÚ˼¿¼¡£
ʹÓÃÁËTAB¼üÉÏÃæµÄ¶ÙºÅÀ´ÐÞÊÎMYSQLÀïµÄ×Ö¶ÎÃû£¬È磺
UPDATE tablename SET `fieldname`='values' wh ......

mysqlÃüÁî_»ù´¡

ÏÔʾmysql»ù±¾ÐÅÏ¢£ºmysql>status;
²é¿´±äÁ¿£ºshow variables like '%version%';
±¸·ÝÓ뻹ԭÃüÁÔÚ×îºó»¹ÓÐ
1.±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî:
ÔÚcmdÖнøÈëµ½mysqlµÄlibĿ¼ÏÂÖ´ÐÐÈçÏ£º
mysqldump -hhostname -uusername -ppassword databaseName > backupfile.sql
Àý£ºmysqldump -hlocalhost -uroot -p123456 test ......

nagios ¼ì²é mysql·þÎñ

 http://blog.c1gstudio.com/archives/602
nagios_plugin°²×°Ê±ÕýÈ·¹ØÁªmysqlºó»áÔÚlibexecϲúÉúcheck_mysqlÎļþ
/usr/local/nagios/libexec/check_mysql -h
 
check_mysql v2034 (nagios-plugins 1.4.13)
Copyright (c) 1999-2007 Nagios Plugin Development Team
        < ......

*nix»·¾³ÏÂÔ´Âë±àÒë°²×°mysql

 ÎªÊ²Ã´Ñ¡ÔñÔ´Âë±àÒë°²×°mysql£ºÎÒÔÚʹÓÃrpm»òÕßÊÇyum°²×°Ê±myql£¬ÀÏÊÇÌáʾÎÒÕÒ²»µ½*.sockÎļþ£¬ÕÒÁ˵ã
×ÊÁÏ˵ÊǸðüÊǷǹٷ½°æ±¾£¨Ã÷Ã÷Êǹٷ½ÏÂÔØ µÄ£©£¬ÆäÖÐÔ­Òòµ½ÏÖÔÚ»¹Ã»ÓиãÇå³þ¡£Ï£ÍûÖªÇéÈËÊ¿¸æÖª¡££¨¿ªÊ¼±àÒëµÄʱºò£¬ÏµÍ³»·¾³Ò»¶¨ÒªÅäÖúã¬GCC£¬GC++...µÈµÈµÄ±àÒëÆ÷Ò»¶¨Òª×öºÃ,±¾È˵ÄcentosÓÉÓÚ¿ªÊ¼
ϵͳ»·¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ