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

mysqlµÄ´óСдÎÊÌâ

 
´óСдÃô¸ÐÐÔ
1¡¢Êý¾Ý¿âºÍ±íÃû
ÔÚMySQLÖУ¬Êý¾Ý¿âºÍ±í¶ÔÓ¦ÓÚÔÚÄÇЩĿ¼ÏµÄĿ¼ºÍÎļþ£¬Òò¶ø£¬ÄÚÔڵIJÙ×÷ϵͳµÄÃô¸ÐÐÔ¾ö¶¨Êý¾Ý¿âºÍ±íÃüÃûµÄ´óСдÃô¸ÐÐÔ¡£ÕâÒâζ×ÅÊý¾Ý¿âºÍ±íÃûÔÚUnixÉÏÊÇÇø·Ö´óСдµÄ£¬¶øÔÚWin32ÉϺöÂÔ´óСд¡£
×¢Ò⣺ÔÚWin32ÉÏ£¬¾¡¹ÜÊý¾Ý¿âºÍ±íÃûÊǺöÂÔ´óСдµÄ£¬Äã²»Ó¦¸ÃÔÚͬһ¸ö²éѯÖÐʹÓò»Í¬µÄ´óСдÀ´ÒýÓÃÒ»¸ö¸ø¶¨µÄÊý¾Ý¿âºÍ±í¡£ÏÂÁвéѯ½«²»¹¤×÷£¬ÒòΪËü×÷Ϊmy_tableºÍ×÷ΪMY_TABLEÒýÓÃÒ»¸ö±í£º
mysql> SELECT * from my_table WHERE
MY_TABLE.col=1;
2¡¢ÁÐÃû
ÁÐÃûÔÚËùÓÐÇé¿ö϶¼ÊǺöÂÔ´óСдµÄ¡£
3¡¢±íµÄ±ðÃû
±íµÄ±ðÃûÊÇÇø·Ö´óСдµÄ¡£ÏÂÁвéѯ½«²»¹¤×÷£¬: ÒòΪËüÓÃaºÍAÒýÓñðÃû£º
mysql> SELECT col_name from tbl_name AS a
          
WHERE a.col_name = 1 OR A.col_name = 2;
4¡¢ÁеıðÃû
ÁеıðÃûÊǺöÂÔ´óСдµÄ¡£
5¡¢×Ö·û´®±È½ÏºÍģʽƥÅä
ȱʡµØ£¬MySQLËÑË÷ÊÇ´óСд²»Ãô¸ÐµÄ(¾¡¹ÜÓÐһЩ×Ö·û¼¯´ÓÀ´²»ÊǺöÂÔ´óСдµÄ£¬ÀýÈç½Ý¿ËÓï)¡£ÕâÒâζ×Å£¬Èç¹ûÄãÓÃcol_name LIKE 'a%'ËÑѰ£¬Ä㽫µÃµ½ËùÓÐÒÔA»òa¿ªÊ¼µÄÁÐÖµ¡£Èç¹ûÄãÏëҪʹÕâ¸öËÑË÷´óСдÃô¸Ð£¬Ê¹ÓÃÏóINDEX(col_name, "A")=0¼ì²éÒ»¸öǰ׺¡£»òÈç¹ûÁÐÖµ±ØÐëÈ·ÇÐÊÇ"A"£¬Ê¹ÓÃSTRCMP(col_name, "A") = 0¡£
¼òµ¥µÄ±È½Ï²Ù×÷(>=¡¢>¡¢= ¡¢< ¡¢<=¡¢ÅÅÐòºÍ¾ÛºÏ)ÊÇ»ùÓÚÿ¸ö×Ö·ûµÄ“ÅÅÐòÖµ”¡£ÓÐͬÑùÅÅÐòÖµµÄ×Ö·û(ÏóE£¬e)±»ÊÓΪÏàͬµÄ×Ö·û£¡
LIKE±È½ÏÔÚÿ¸ö×Ö·ûµÄ´óдֵÉϽøÐÐ(“E”=”e”)¡£
Èç¹ûÄãÏëÒªÒ»¸öÁÐ×ÜÊDZ»µ±×÷´óСдÃô¸ÐµÄ·½Ê½£¬ÉùÃ÷ËüΪBINARY¡£
ÀýÈ磺
mysql> SELECT
"E"="e","E"=BINARY "e";
+---------+----------------+
| "E"="e" | "E"=BINARY "e" |
+---------+----------------+
|       1 |              0 |
+---------+----------------+


Ïà¹ØÎĵµ£º

dz̸MysQLÖÐHANDLERÓï·¨½éÉܼ°Ê¹ÓÃ

½ñÌìС±àÒªºÍ´ó¼Ò˵µÄÊÇhandlerµÄÓ÷¨£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
HANDLER tbl_name OPEN [ AS alias ]
HANDLER tbl_name READ index_name { = | >= | <= | < } (value1,value2,...)
    [ WHERE where_condition ] [LIMIT ... ]
HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST } ......

mysql Óαê

¶¨ÒåÓαê 
DECLARE cur_Ãû³Æ CURSOR
FOR
SELECT ×Ö¶Î1,×Ö¶Î2,...×Ö¶În from ±í where ×Ö¶Î1=±äÁ¿;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET ±äÁ¿1=null,±äÁ¿2=null;
OPEN cur_Ãû³Æ;
FETCH cur_Ãû³Æ INTO ±äÁ¿1,±äÁ¿2...;
WHILE ( ±äÁ¿1  IS NOT NULL) DO
 &nbs ......

ubuntuÖÐmysqlÂÒÂëÎÊÌâ

 ÏÈ¿´ÏÂÃæ×¢ÒâÄÚÈÝ
ÕûÕûŪÁËÒ»Ì죬ÖÕÓÚ½â¾öÁËjdbc(mysql-connector-java-5.0.30)ºÍmysqͨÐÅÖÐÎÄÂÒÂëµÄÎÊÌ⣡ÎÒµÄϵͳÊÇ
linux£¨ubuntu£©¡£ÔÚjavaÖУ¨Myeclipse»·¾³£©Ê¹ÓÃhibernateÁ¬½Ómysql¡£´æ´¢Ó¢ÎÄûÎÊÌ⣬д£¨insert
into£©ºÍ¶Á£¨select£©¶¼ÄÜÕýÈ·ÏÔʾ£¬µ«ÊÇÈôÆäÖдøÓÐÖÐÎÄ×Ö·û¾Í³ÉÂÒÂëÁË¡£µ½ÍøÉϲéÕÒÁ˰ëÌì×ÊÁ ......

½«MySQLÖÐsqlÔËÐнá¹û±£´æµ½Îļþ

 ÓÐÁ½ÖÖ·½·¨¡£
·½·¨Ò»£ºÔÚmysql>Ìáʾ·ûÖÐʹÓÃtee
mysql> tee output.txt
Logging to file 'output.txt'
mysql> notee
Outfile disabled.
»òÕß
mysql> \T output.txt
Logging to file 'output.txt'
mysql> \t
Outfile disabled.
Õâ¸öÀàËÆÓÚsqlplusµÄspool¹¦ÄÜ£¬¿ÉÒÔ½«ÃüÁîÐÐÖеĽá¹û±£´æµ½Í ......

Ò»´ÎNginx+PHP+MysqlµÄ²¢·¢²âÊÔ¾­Àú

 Ò»´ÎNginx+PHP+MysqlµÄ²¢·¢²âÊÔ¾­Àú
  Ò»¡¢Ó²¼þ»·¾³
      CPU:4ºËIntel(R) Xeon(R) CPU           E5504  @ 2.00GHz
      6GÄڴ棬120GÓ²ÅÌ
  ¶þ¡¢Èí¼þ»·¾³
     L ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ