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

mysqlÖÐcountº¯Êý×¢ÒâÊÂÏî

񡜧
CREATE TABLE `user` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(10) DEFAULT NULL,
  `password` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
ÆäÖÐÓÐÊý¾ÝΪ£º
1 name1 123456
2 name2 123456
3 name3 123456
4 name4  NULL
ÒÔÏÂÈý¸ö²éѯ·µ»Ø¼¸ÄØ£¿
£¨1£©select count(*) from `user`
£¨2£©select count(name) from `user`
£¨3£©select count(password) from `user`
´ð°¸ÊÇ£º4,4,3
ÒòΪ£º
£¨1£©count(*)ÊǶÔÐÐÊýÄ¿½øÐмÆÊý£¬ËùÒÔµ±È»ÊÇ4
£¨2£©count(column_name)ÊǶÔÁÐÖв»Îª¿ÕµÄÐнøÐмÆÊý£¬ËùÒÔcount(name)=4£¬¶øcount(password)=3


Ïà¹ØÎĵµ£º

MySqlµÄ±íÀàÐÍ

create database sample;
create table 't_user' (
    'id' int(11) not null auto_increment,
    'name' varchar(100) not null default '',
    primary key ('id')
) type=myisam;
Ñ¡ÏîÖ»ÔÚMySQL 3.23ºÍÒÔºó°æ±¾Öб»ÊµÏÖ¡£
²»Í¬µÄ±íÀàÐÍÊÇ£º
ISAM Ô­À´µÄ±í´¦ÀíÆ ......

Óöµ½µÄÒ»¸ömysql±¸·Ý»Ö¸´µÄÎÊÌâ

Êý¾Ý¿âÌØµã
£­£­Ê¹ÓÃpartition£¬´æÔÚÉϰٸö·ÖÇø
£­£­½¨±íʱָ¶¨ÁËdata_dirºÍindex_dir£¬Êý¾Ý²»ÊÇ´æ´¢ÔÚĬÈÏλÖ㬶øÊÇÔÚmysqldµÄÊý¾ÝĿ¼ÏÂlinkµ½ÕæÕýµÄÊý¾ÝÎļþ
±¸·Ý»Ö¸´ÒªÇó
£­£­±¸·Ý³öÀ´µÄÊý¾Ý»Ö¸´Ê±Òª»Ö¸´³É²»Í¬µÄ±íÃû
£­£­»Ö¸´³öÀ´µÄÊý¾Ýʵ¼Ê´æ´¢Î»ÖÃÒ²Òª´æ´¢ÔÚÓëÔ­±í²»Í¬µÄλÖÃ
ÎÊÌâ
Èç¹ûÖ±½Ómysqldump£­sourc ......

ʵ¼ù¾­Ñé»ã¼¯³ÉµÄMySQLÓ¦ÓÃÖ¸ÄÏ


 
¡¾ÊéÃû¡¿¸ßÐÔÄÜMySQL£¨µÚ¶þ°æ£©
¡¾Ô­ÊéÃû¡¿High Performance MySQL, second edition
¡¾×÷Õß¡¿Baron Schwartz£¬Peter Zaitsev£¬Vadim
Tkachenko£¬Jeremy D.Zawodny£¬Arjen Lentz£¬Derek
J.Balling  Öø
¡¾ÒëÕß¡¿ÍõС¶« Àî¾ü ¿µ½¨Ñ« Òë
¡¾³ö°æÉç¡¿µç×Ó¹¤Òµ³ö°æÉç     
¡¾ÊéºÅ¡¿978- ......

mysqlÐÂÔöÓû§ºÍµÇ¼


ÐÂÔöÓû§£º
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ÄãµÄÔ¶¶Ëip' IDENTIFIED BY 'ÄãµÄÃÜÂë' WITH GRANT OPTION;
È磺
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.10.19.220' IDENTIFIED BY '123456' WITH GRANT OPTION;
µÇ¼µ½ÐÂÔöµÄÓû§£º£¨¼ÙÈçÔ­ÊÚȨ»úµÄIPΪ10.10.19.222£©
mysql -uroot  -p123456&n ......

MysqlÍâ¼üÔ¼Êø

1.myisam±í²»Ö§³ÖÍâ¼ü£¬innodb²ÅÖ§³ÖÍâ¼ü
2.mysqlÍâ¼üµÄÁÐÀàÐͺÍÖ÷±íÖÐÏàÓ¦µÄÖ÷¼üÁÐÀàÐͱØÐëÒ»Ö£¬¼´ÀàÐÍÒ»Ö¡¢³¤¶ÈÒ»Ö£¬·ñÔò»á±¨´í¡£ERROR 1005: Can't create table (errno: 150)
3.ÔÚÒ»¸öÊý¾Ý¿âÖÐÍâ¼üÃû×Ö²»ÄÜÖØ¸´£¬·ñÔò»á±¨ERROR 1005: Can't create table 'XXXXXX' (errno: 121) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ