Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 |
+---------+----------------+


Ïà¹ØÎĵµ£º

mysqlÖÐÎÄÅÅÐò¼°javaÖÐÎÄÅÅÐò


Ö®ËùÒÔдÕâÆª²©¿Í£¬ÊÇÒòΪǰ¼¸Ìì²ÅÅöµ½ÁËÕâôһ¸öÎÊÌ⣬ÒÔǰ»¹²»ÖªµÀmysqlÓÐÕâôһ¸öÎÊÌâ¡£
ÎÒÃǵÄϵͳʹÓÃÁËstruts+hibernate£¬Êý¾Ý¿âʹÓõÄÊÇmysql£¬×Ö·û¼¯Í³Ò»Îªutf-8¡£
±¾À´ÒѾ­Íê³ÉÁË£¬µ«ÊÇϵͳʹÓõÄʱºò£¬·¢ÏÖ²é³öÀ´µÄÈËÃûûÓÐ˳Ðò£¬±¾À´ÒÔΪºÜ¼òµ¥£¬ÔÚ²éѯµÄʱºò£¬Ö¸¶¨°´ÕÕnameÅÅÐò¾Í¿ÉÒÔÁË£¬Æñ֪ʵ¼ÊÒ»×ö²Å·¢Ï ......

mysql°²×°Í¼½â½Ì³Ì 5.1(ת)

mysql°²×°Í¼½â½Ì³Ì 5.1
2009Äê03ÔÂ01ÈÕ ÐÇÆÚÈÕ 23:51
×ªÔØÇë×¢Ã÷³ö´¦:http://hi.baidu.com/herdff/blog/item/6e6b4bcf6132f90b93457e14.html
±¾½Ì³ÌÒÔMysql 5.1°æ±¾ÎªÀý£¬¸ü¸ß°æ±¾°²×°¹ý³ÌÓë´ËÀàËÆ¡£ÔĶÁǰ£¬ÇëÏÂÔØ5.1£¬ÏÂÔØµØÖ·£ºwww.mysql.com
°²×°¹ý³ÌÓëÆäËüWindows°²×°³ÌÐòÒ»Ñù£¬Ê×ÏȳöÏÖµÄÊǰ²×°Ïòµ¼»¶Ó­½çÃæ
Ö ......

mysql ÕÒ»ØÃÜÂë

 
1.  Í£µ½ÔËÐеÄmysql:    /etc/init.d/mysql stop
2.  ʹÓÃskip-grant-tablesÕâ¸öÑ¡ÏîÆô¶¯MySQL£º  /usr/bin/mysqld_safe --skip-grant-tables &
3.  ÏÖÔÚ¿ÉÒÔ²»ÓÃÃÜÂë½øÈëmysql ÁË¡£
     #  myql
    >   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ