MySQL5.1ÄÚ±íתµ½MS SQL£¬±í½á¹¹Ó¦ÈçºÎÉèÖã¿
# MySQL-Front 5.1 (Build 4.2)
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
# Host: localhost Database: scanmaster
# ------------------------------------------------------
# Server version 5.1.46-community
#
# Source for table tabapp
#
DROP TABLE IF EXISTS `tabapp`;
CREATE TABLE `tabapp` (
`appid` int(4) NOT NULL AUTO_INCREMENT,
`appname` varchar(32) NOT NULL DEFAULT '',
`apppath` varchar(255) CHARACTER SET gbk COLLATE gbk_bin NOT NULL DEFAULT '',
`outputpath` varchar(255) CHARACTER SET gbk COLLATE gbk_bin NOT NULL DEFAULT '',
`indexed` int(4) NOT NULL DEFAULT '0',
`key1` varchar(64) DEFAULT NULL,
`key2` varchar(64) DEFAULT NULL,
PRIMARY KEY (`appid`),
UNIQUE KEY `appname` (`appname`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;
#
# Dumping data for table tabapp
#
LOCK TABLES `tabapp` WRITE;
/*!40000 ALTER TABLE `tabapp` DISABLE KEYS */;
INSERT INTO `tabapp` VALUES (4,'FDCdoc1','\\\\aqlcserver\\in$\\FDCdoc1','\\\\aqlcserver\\out$\\FDCdoc1',1,'Åú´ÎºÅ','ºÐÄÚÐòºÅ');
/*!40000 ALTER TABLE `tabapp` ENABLE KEYS */;
UNLOCK TABLES;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
ÒÔÉÏÊÇMySQLµ¼³ö±íµÄSQL,ÈôÔÚMS SQLÖн¨Á¢ÏàͬµÄ±í£¬ºìÉ«×ÖÌ岿·ÖÔÚMS SQLÖÐÈçºÎÉèÖã¿
Ïà¹ØÎĵµ£º
Ò»¡¢Apache HTTP Server °²×°£º
ÔËÐÐApache .msi Îļþ£¬°²×°³ÌÐò½«ÒªÇóÄãÌîдÈçÏÂÄÚÈÝ£º
1. Network Domain¼üÈëÄãµÄ·þÎñÆ÷£¨»òÕßÊÇÄã¼´½«×¢²áµÄ·þÎñÆ÷£©µÄDNS ÓòÃû¡£ÀýÈ磬ÄãµÄ·þÎñÆ÷µÄDNSÓòÃûÈ«³ÆÊÇserver.mydomain.net,ÄãÖ»ÐèÔÚÕâÀïÊäÈëmydomain.net¡£
2. Server Name ¾ÍÊÇÄãµÄ·þÎñÆ÷µÄDNSÓòÃûÈ«³Æ£¬»¹ÊÇÉÏÃæµÄÀ ......
http://www.mysqlperformanceblog.com/2006/11/12/trying-archive-storage-engine/
£¨1£©ÔÚÏàͬµÄÌõ¼þÏ£¬archiveµÄÊý¾Ý´óСԶСÓÚmyisam
£¨2£©ÔÚѹËõarchiveÊý¾Ýʱ£¬bzip2ºÃÓÚgzip
£¨3£©ÐèÒªÌí¼ÓarchiveµÄ·½·¨ºÍѹËõµÄlevel£¬ÒÔÂú×㲻ͬÓû§µÄÐèÇó
£¨4£©Õâ¸ö´æ´¢ÒýÇæÊÊÓÃÓÚÈÕÖ¾Êý¾Ý
£¨5£©´ËÒýÇæ²»ÄÜupdate,delete£¬²¢ ......
¸ãÁ˺ܾᣡ£ÖÕÓÚ·¢ÏÖÔÀ´ÊÇȨÏÞÎÊÌâ¡£¡£
2ÐÐÃüÁî¸ã¶¨
grant all privileges on rogue.* to admin@localhost identified by 'admin' with grant option
grant all privileges on rogue.* to admin@'%' identified by 'admin' with grant option
¾µäÁË¡£¡£¡£
ħÁ¦Ë½·þÍøÒ³¶Ë¸ã¶¨¿©~~ ......
Join²Ù×÷·û
ÊÊÓó¡¾°£ºÔÚÎÒÃÇ±í¹ØÏµÖÐÓÐÒ»¶ÔÒ»¹ØÏµ£¬Ò»¶Ô¶à¹ØÏµ£¬¶à¶Ô¶à¹ØÏµµÈ¡£¶Ô¸÷¸ö±íÖ®¼äµÄ¹ØÏµ£¬¾ÍÓÃÕâЩʵÏÖ¶Ô¶à¸ö±íµÄ²Ù×÷¡£
˵Ã÷£ºÔÚJoin²Ù×÷ÖУ¬·Ö±ðΪJoin(Join²éѯ), SelectMany(SelectÒ»¶Ô¶àÑ¡Ôñ)ºÍGroupJoin(·Ö×éJoin²éѯ)¡£
¸ÃÀ©Õ¹·½·¨¶ÔÁ½¸öÐòÁÐÖмüÆ¥ÅäµÄÔªËØ½øÐÐinner join²Ù×÷
SelectMany
˵Ã÷£ºÎÒà ......