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 |
+---------+----------------+
Ïà¹ØÎĵµ£º
groupadd mysql
н¨Ò»¸öÃûΪmysqlµÄÓû§×é
useradd -g mysql mysql
ÔÚmysqlÓû§×éÏÂн¨Ò»¸öÃûΪmysqlµÄÓû§
gunzip ½âѹÏÂÔص½µÄ.gzÎļþ
cd mysql-VERSION
½øÈë½âѹºóµÄĿ¼
CFLAGS="-O3 -mcpu=pentium4" CXX=gcc CXXFLAGS="-O3 -march=pentium4 -felide-constructors -fno-exceptions -fno-rtti" ./configu ......
Êý¾Ý¿â²Ù×÷ÀࣺDBCommon.class.php
//---------------------------------------------------------------------
// MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
//
// ¿ª·¢×÷Õß: heiyeluren
// °æ±¾ÀúÊ·:
// 2006-09-20 »ù±¾µ¥Êý¾Ý¿â²Ù×÷¹¦ÄÜ, 25 ¸ö½Ó¿Ú
// 2007-07-30 Ö§³Öµ ......
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]
¸ÃÓï¾äÄÜ´´½¨ÐµÄÊÓͼ£¬Èç¹û¸ø¶¨ÁËOR REPLACE×Ӿ䣬¸ÃÓï¾ä»¹ÄÜÌæ»»ÒÑÓеÄÊÓͼ¡£select_st ......
½ñÌìС±àÒªºÍ´ó¼Ò˵µÄÊÇ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>Ìáʾ·ûÖÐʹÓÃ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¹¦ÄÜ£¬¿ÉÒÔ½«ÃüÁîÐÐÖеĽá¹û±£´æµ½Í ......