Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 5.0.16 ÂÒÂëÎÊÌâ´¦Àí°ì·¨


1 ÉèÖÃphpMyAdmin
Language:Chinese simplified (zh-utf-8)
MySQL ×Ö·û¼¯£ºUTF-8 Unicode (utf8)
MySQL Á¬½ÓУ¶Ô gbk_chinese_ci
2 ´´½¨Êý¾Ý¿âʱ
ÕûÀíÉèÖÃ³É gbk_chinese_ci
3 ÓÃSQL½¨Á¢±íÖÐ
ENGINE=MyISAM DEFAULT CHARSET=gbk;
ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=40 ;
4 ¼ì²é±í½á¹¹ÖÐ
varcha ......

hibernate mysqlÓ³ÉäÀàÐÍ

 
integer »òÕß int
int »òÕß java.lang.Integer
INTEGER
4 ×Ö½Ú
long
long  Long
BIGINT
8 ×Ö½Ú
short
short  Short
SMALLINT
2 ×Ö½Ú
byte
byte  Byte
TINYINT
1 ×Ö½Ú
float
float  Float
FLOAT
4 ×Ö½Ú
double
double  Double
DOUBLE
8 ×Ö½Ú
b ......

mysql show status


²é¿´·þÎñÆ÷Ŀǰ״̬ÐÅÏ¢µÄÃüÁÁ½ÖÖ·½Ê½£º
 
1.      ÃüÁîÐУ¬½øÈëmysql/binĿ¼Ï£¬ÊäÈëmysqladmin extended-status
2.      Á¬½Óµ½mysql£¬ÊäÈëshow status;
3.      Èç¹ûÒª²é¿´Ä³¸öÊý¾Ý£¬¿ÉÒÔ
mysql> show s ......

¸ù¾ÝstatusÐÅÏ¢¶ÔMySQL·þÎñÆ÷½øÐÐÓÅ»¯

¡¡ÍøÉÏÓкܶàµÄÎÄÕ½ÌÔõôÅäÖÃMySQL·þÎñÆ÷£¬µ«¿¼Âǵ½·þÎñÆ÷Ó²¼þÅäÖõIJ»Í¬£¬¾ßÌåÓ¦ÓõIJî±ð£¬ÄÇЩÎÄÕµÄ×ö·¨Ö»ÄÜ×÷Ϊ³õ²½ÉèÖòο¼£¬ÎÒÃÇÐèÒª¸ù¾Ý×Ô¼ºµÄÇé¿ö½øÐÐÅäÖÃÓÅ»¯£¬ºÃµÄ×ö·¨ÊÇMySQL·þÎñÆ÷Îȶ¨ÔËÐÐÁËÒ»¶Îʱ¼äºóÔËÐУ¬¸ù¾Ý·þÎñÆ÷µÄ”״̬”½øÐÐÓÅ»¯¡£
mysql> show global status;
¡¡¡¡¿ÉÒÔÁгöMySQL·þÎ ......

mysqlÖÐÎÄÂÒÂëÎÊÌâ½â¾ö·½°¸

    ÔÚ֮ǰµÄÎÄÕÂÀÎÒÒѾ­Ìá¹ýÈçºÎ½â¾öJSPÖÐÂÒÂëÎÊÌ⣨½â¾ötomcatÏÂÖÐÎÄÂÒÂëÎÊÌâ £©£¬ÆäÖÐÒ²Ïêϸ½â˵ÁËMYSQLÂÒÂëÎÊÌ⣬ÏàÐÅͨ¹ýÀïÃæµÄ°ì·¨£¬¿Ï¶¨¶¼ÒѾ­½â¾öÁËJSPÀïµÄÂÒÂëÎÊÌ⣬²»¹ý»¹ÊÇÓÐЩÈ˵ÄMYSQLÂÒÂëÎÊÌâûÓеõ½½â¾ö£¬°üÀ¨ÎÒ×Ô¼º£¬ËùÒÔÓÖÕÒÁËһЩ×ÊÁÏ£¬Ï£ÍûÕâ´ÎÄÜÍêÈ«½â¾öMYSQLÊý¾Ý¿âµÄÂÒÂëÎÊÌâ¡£
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ