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

mysql Ë÷Òý


 
 
²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽âÆäº¬Òå¼°×÷Óã¬ÏêϸµÄ½éÉÜÇë²Î¿¼µÚ14Õ¡£
1£®Ë÷ÒýʾÀý
¼ÙÉè¶ÔÓÚ10.3½ÚËù½¨µÄ±í£¬¸÷¸ö±íÉ϶¼Ã»ÓÐË÷Òý£¬Êý¾ÝµÄÅÅÁÐҲûÓйæÂÉ£¬Èç±í13.3Ëùʾ¡£
±í13.3                                                     ûÓÐË÷ÒýµÄstudents±í
sid
sname
sgender
sage
52
zhang
M
21
22
wang
M
22
33
li
F
19
41
zhao
M
20
...
...
...
 
 
µ±²éÕÒij¸öѧÉúÐÅϢʱ£¬±ØÐë˳Ðò²é¿´±ístudentsÖеÄÿһÐУ¬¼ì²éÊÇ·ñÓëËùÐèֵƥÅ䣬ÕâÐèҪɨÃèÈ«±í£¬Ð§Âʺܵ͡£
±í13.4¸ø³öÁËÔÚnameÁÐÉÏÔö¼ÓÁËË÷ÒýµÄstudents±í¡£
±í13.4                                        ÔÚnameÁÐÉÏÔö¼ÓÁËË÷ÒýµÄstudents±í
 
Ë÷ÒýÊÇÔÚnameÉÏÅÅÐòµÄ¡£ÏÖÔÚ£¬µ±²éÕÒij¸öѧÉúÐÅϢʱ£¬¾Í²»ÐèÒªÖðÐÐËÑË÷È«±í£¬¿ÉÒÔÀûÓÃË÷Òý½øÐÐÓÐÐò²éÕÒ£¨Èç¶þ·Ö²éÕÒ·¨£©£¬²¢¿ìËÙ¶¨Î»µ½Æ¥ÅäµÄÖµ£¬ÒÔ½ÚÊ¡´óÁ¿ËÑË÷ʱ¼ä¡£
2£®Ë÷Òý×÷ÓÃ
ÔÚË÷ÒýÁÐÉÏ£¬³ýÁËÉÏÃæÌáµ½µÄÓÐÐò²éÕÒÖ®Í⣬Êý¾Ý¿âÀûÓø÷ÖÖ¸÷ÑùµÄ¿ìËÙ¶¨Î»¼¼Êõ£¬Äܹ»´ó´óÌá¸ß²éѯЧÂÊ¡£ÌرðÊǵ±Êý¾ÝÁ¿·Ç³£´ó£¬²éÑ¯Éæ¼°¶à¸ö±íʱ£¬Ê¹ÓÃË÷ÒýÍùÍùÄÜʹ²éѯËٶȼӿì³ÉǧÉÏÍò±¶¡£
ÀýÈ磬ÓÐ3¸öδË÷ÒýµÄ±ít1¡¢t2¡¢t3£¬·Ö±ðÖ»°üº¬ÁÐc1¡¢c2¡¢c3£¬Ã¿¸ö±í·Ö±ðº¬ÓÐ1000ÐÐÊý¾Ý×é³É£¬Ö¸Îª1¡«1000µÄÊýÖµ£¬²éÕÒ¶ÔÓ¦ÖµÏàµÈÐеIJéѯÈçÏÂËùʾ¡£
 
SELECT c1,c2,c3 from t1,t2,t3 WHERE c1=c2 AND c1=c3
´Ë²éѯ½á¹ûÓ¦¸ÃΪ1000ÐУ¬Ã¿Ðаüº¬3¸öÏàµÈµÄÖµ¡£ÔÚÎÞË÷ÒýµÄÇé¿öÏ´¦Àí´Ë²éѯ£¬±ØÐëѰÕÒ3¸ö±íËùÓеÄ×éºÏ£¬ÒÔ±ãµÃ³öÓëWHE


Ïà¹ØÎĵµ£º

mysqlµÄÅäÖÃÎļþmy.ini

# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Li ......

mysqlË÷Òý

ÆÕͨË÷Òý¡¢Î¨Ò»Ë÷ÒýºÍÖ÷Ë÷Òý
1. ÆÕͨË÷Òý
ÆÕͨË÷Òý(Óɹؼü×ÖKEY»òINDEX¶¨ÒåµÄË÷Òý)µÄΨһÈÎÎñÊǼӿì¶ÔÊý¾ÝµÄ·ÃÎÊËÙ¶È¡£Òò´Ë£¬Ó¦¸ÃֻΪÄÇЩ×î¾­³£³öÏÖÔÚ²éѯÌõ¼þ(WHERE column = …)»òÅÅÐòÌõ¼þ(ORDER BY column)ÖеÄÊý¾ÝÁд´½¨Ë÷Òý¡£Ö»ÒªÓпÉÄÜ£¬¾ÍÓ¦¸ÃÑ¡ÔñÒ»¸öÊý¾Ý×îÕûÆë¡¢×î½ô´ÕµÄÊý¾ÝÁÐ(ÈçÒ»¸öÕûÊýÀàÐ͵ÄÊý¾ÝÁÐ)À ......

php PDO Á´½Ó mysql ×î¼òµ¥ ʵÀý

define("DB_SERVER","127.0.0.1");
define("DB_PORT",3306);
define("DB_CATALOG","uab");
define("DB_USERID","root");
define("DB_PASSWORD","");
$dsn="mysql:host=".DB_SERVER.";port=".DB_PORT.";dbname=".DB_CATALOG;
self::$__PDO=new PDO($dsn, DB_USERID, DB_PASSWORD);
//support long connection
self:: ......

Ó¦Ó÷ÃÎÊMysqlÓöµ½µÄÁ¬½ÓÎÊÌâ

×î½üÔÚ×öÒ»¸öСÏîÄ¿£¬¿ª·¢»·¾³£ºÊý¾Ý¿âmysql5.0£¬·þÎñÆ÷Tomcat5.5¡£ÏîÄ¿´ò³Éwar²¿ÊðÔÚtomcatÉÏÖ®ºó£¬Í¨¹ýÓ¦ÓýøÐвéѯ²Ù×÷£¬Èç¹û²Ù×÷¹ýÓÚÆµ·±£¬ºǫ́»áÅ×ÈçÏÂÒì³££º
javax.servlet.ServletException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [08S01]; error co ......

Mysql ¹Ø¼ü×Ö ±£Áô×Ö

Mysql ¹Ø¼ü×Ö-±£Áô×Ö
ÔÚpowerdesignerÉè¼ÆµÄʱºòÓÃÁ˹ؼü×Ö£¬Éú³É³ö´í£¬ºÜ囧¡£¡£¡£
 
 
 
 
 
ADD
ALL
ALTER
ANALYZE
AND
AS
ASC
ASENSITIVE
BEFORE
BETWEEN
BIGINT
BINARY
BLOB
BOTH
BY
CALL
CASCADE
CASE
CHANGE
CHAR
CHARACTER
CHECK
COLLATE
COLUMN
CON ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ