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 |
+---------+----------------+
Ïà¹ØÎĵµ£º
½ñÌìС±àÒªºÍ´ó¼Ò˵µÄÊÇ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 } ......
¶¨ÒåÓαê
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 ......
ÏÈ¿´ÏÂÃæ×¢ÒâÄÚÈÝ
ÕûÕûŪÁËÒ»Ì죬ÖÕÓÚ½â¾öÁËjdbc(mysql-connector-java-5.0.30)ºÍmysqͨÐÅÖÐÎÄÂÒÂëµÄÎÊÌ⣡ÎÒµÄϵͳÊÇ
linux£¨ubuntu£©¡£ÔÚjavaÖУ¨Myeclipse»·¾³£©Ê¹ÓÃhibernateÁ¬½Ómysql¡£´æ´¢Ó¢ÎÄûÎÊÌ⣬д£¨insert
into£©ºÍ¶Á£¨select£©¶¼ÄÜÕýÈ·ÏÔʾ£¬µ«ÊÇÈôÆäÖдøÓÐÖÐÎÄ×Ö·û¾Í³ÉÂÒÂëÁË¡£µ½ÍøÉϲéÕÒÁ˰ëÌì×ÊÁ ......
ÓÐÁ½ÖÖ·½·¨¡£
·½·¨Ò»£ºÔÚ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µÄ²¢·¢²âÊÔ¾Àú
Ò»¡¢Ó²¼þ»·¾³
CPU:4ºËIntel(R) Xeon(R) CPU E5504 @ 2.00GHz
6GÄڴ棬120GÓ²ÅÌ
¶þ¡¢Èí¼þ»·¾³
L ......