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

mysqlº¯Êý»ã×Ü


Ò»¡¢
¿ØÖÆÁ÷³Ìº¯Êý
a)        
CASE WHEN THEN
º¯Êý
Óï·¨£º
CASE value WHEN [compare-value]
THEN result [WHEN [compare-value] THEN result ……] [ELSE result ] END CASE WHEN
[condition] THEN result [WHEN[condition] THEN result ……] [ELSE result] END
£»
º¯ÊýÓ÷¨ËµÃ÷£ºÔÚµÚÒ»¸ö·½°¸µÄ·µ»Ø½á¹ûÖУ¬
value
=compare-value
¡£¶øµÚ¶þ¸ö·½°¸µÄ·µ»Ø½á¹ûÊǵÚÒ»ÖÖÇé¿öµÄÕæÊµ½á¹û¡£Èç¹ûûÓÐÆ¥ÅäµÄ½á¹ûÖµ£¬Ôò·µ»Ø½á¹ûΪ
ELSE
ºóµÄ½á¹û£¬Èç¹ûûÓÐ
ELSE
²¿·Ö£¬Ôò·µ»ØÖµÎª
NULL
b)       
IF
º¯ÊýÓ÷¨
Óï·¨£º
IF(expr1,expr2,expr3)
º¯ÊýÓ÷¨ËµÃ÷£ºÈç¹û
expr1

ÊÇ
TRUE (expr1
<> 0 and expr1
<> NULL)
£¬Ôò
IF()
µÄ·µ»ØÖµÎª
expr2
;
·ñÔò·µ»ØÖµÔòΪ
expr3
¡£
IF()
µÄ·µ»ØÖµÎªÊý×ÖÖµ»ò×Ö·û´®Öµ£¬¾ßÌåÇé¿öÊÓÆäËùÔÚÓï¾³¶ø¶¨
c)       
IFNULL
º¯Êý
Óï·¨£º
IFNULL(expr1,expr2)
º¯ÊýÓ÷¨ËµÃ÷£º¼ÙÈç
expr1

²»Îª
NULL
£¬Ôò
IFNULL()
µÄ·µ»ØÖµÎª
expr1
;
·ñÔòÆä·µ»ØÖµÎª
expr2
¡£
IFNULL()
µÄ·µ»ØÖµÊÇÊý×Ö»òÊÇ×Ö·û´®£¬¾ßÌåÇé¿öÈ¡¾öÓÚÆäËùʹÓõÄÓï¾³
¶þ¡¢
×Ö·û´®±È½Ïº¯Êý
a)        
º¯Êý
ascii(str)
º¯ÊýÓ÷¨ËµÃ÷£º·µ»ØÖµÎª×Ö·û´®
str

µÄ×î×ó×Ö·ûµÄÊýÖµ¡£¼ÙÈç
str
Ϊ¿Õ×Ö·û´®£¬Ôò·µ»ØÖµÎª
0
¡£¼ÙÈç
str

Ϊ
NULL
£¬Ôò·µ»ØÖµÎª
NULL
¡£
ASCII()
ÓÃÓÚ´øÓдÓ
0
µ½
255
µÄÊýÖµµÄ×Ö·û
b)       
º¯Êý
BIN(N)
º¯ÊýÓ÷¨ËµÃ÷£º·µ»ØÖµÎª
N
µÄ¶þ½øÖÆÖµµÄ×Ö·û´®±íʾ£¬ÆäÖÐ
  N

Ϊһ¸ö
longlong (BIGINT)
Êý×Ö¡£ÕâµÈͬÓÚ
CONV(N
,10,2)
¡£¼ÙÈç
N

Ϊ
NULL
£¬Ôò·µ»ØÖµÎª
NULL
¡£
c)       
º¯ÊýCHAR(N
,...
[USING charset
])
º¯ÊýÓ÷¨ËµÃ÷£º
CHAR()
½«Ã¿¸ö²ÎÊý
N
Àí½âΪһ¸öÕûÊý£¬Æä·µ»ØÖµÎªÒ»¸ö°üº¬ÕâЩÕûÊýµÄ´úÂëÖµËù¸ø³öµÄ×Ö·ûµÄ×Ö·û´®¡£
NULL
Öµ±»Ê¡ÂÔ¡£
d)       
º¯ÊýCHAR_LENGTH(str
)
º¯ÊýʹÓÃ˵Ã÷£º·µ»ØÖµÎª×Ö·û´®
str

µÄ³¤¶È£¬³¤¶ÈµÄµ¥Î»Îª×Ö·û¡£Ò»¸ö¶à×Ö½Ú×Ö·ûËã×÷


Ïà¹ØÎĵµ£º

¿ªÆô MySQL query cache£¬¼Ó¿ìÊý¾Ý¿â¶ÁÈ¡ËÙ¶È

 
ÔÚÍøÕ¾½¨Éè»òÕßÔËÓªÖУ¬Èç¹û MySQL server ÊǷdz£·±Ã¦£¬¿ÉÒÔ¿ªÆô query cache ÒÔ¼ÓËÙ»ØÓ¦Ê±¼ä£¬¿ªÆô·½·¨¿ÉÒÔÔÚ my.cnf 裡Ãæ¼ÓÈëÒÔÏÂÏîÄ¿: (Redhat ÏÂÃæÊÇ /etc/my.cnf£»Debian ÊÇÔÚ etc/mysql
/my.cnf).
query_cache_size = 64M
query_cache_type = 1
query_cache_limit = 1048576
ÒÔÉÏÓï·¨µÄÉ趨ÀïÃæ£¬ ......

ÖØÐ°²×°mysqlµÄÐĵÃ

Ôø¾­Ê§°Ü¹ýn´Î£¬ÈÃÎÒÏ൱ÎÞÄÎ×îºóÖÕÓÚÕÒµ½ÁËÒ»¸ö½â¾ö·½°¸£¬¹©´ó¼Ò·ÖÏí
ɾµô×¢²á±íµÄ·½·¨£¬ÎÒÒ²Ôø¾­Óùý£¬µ«×ÜÊÇʧ°Ü£¬½¨ÒéÈçÏÂ
Ò»£ºÏÈÐ¶ÔØÈí¼þmysql
¶þ£ºÏÈɾע²á±íµÄ¶«Î÷£»
Èý£º×îºóÔÚÄãµÄµ±Ç°Óû§ÀïcÅÌÏÂC:\Documents and Settings\All Users\Application Data\ÕÒµ½mysqlµÄĿ¼£¬É¾µô£¬ÍüÁ˸æËßÒ»¾ä£»
ÄÇÊÇÒþ²ØÎļþ£ ......

MySQL Migration ToolkitµÄʹÓÃ

 MySQL Migration ToolkitÊÇMySQL³öµÄÊý¾ÝÇ¨ÒÆ¹¤¾ß(ÊÊÓÃÓÚMySQL5.0»òÒÔÉÏ)£¬Ê¹Óò¢²»¸´ÔÓ£¬Ö§³ÖOracle,Microsoft SQL Server,Microsoft Access,Sybase,MaxDBµ½MySQLÖ®¼äµÄת»»¡£ÒÔÏÂʵÀýÊÇOracleµ½MySQLµÄ¡£
1. °²×°jdk1.6
×°ÍêMySQL Migration Toolkit»¹Ðè°²×°jdk1.6£¬ÐèÒªjre1.5.0.8ÒÔÉϵÄÖ§³Ö¡£
2. ÔËÐÐMySQL Mi ......

MySql»ù´¡ÖªÊ¶(¾­µä°æ)

 
Ò»¡¢mysql µÄ¹ÜÀí
1
¡¢Á¬½Ó
Mysql
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£º ......

mysqlÖÐÎÄÂÒÂë²úÉúÔ­ÒòºÍ½â¾ö°ì·¨

Ò»¡¢ÂÒÂë²úÉúÔ­Òò
mysql×Ö·û±àÂëÊǰ汾4.1ÒýÈëµÄ,Ö§³Ö¶à¹úÓïÑÔ,¶øÇÒÒ»Ð©ÌØÐÔÒѾ­³¬¹ýÁËÆäËûµÄÊý¾Ý¿âϵͳ¡£¿ÉÒÔÔÚMySQL Command Line Client ÏÂÊäÈëÈçÏÂÃüÁî²é¿´mysqlµÄ×Ö·û¼¯
mysql> SHOW CHARACTER SET;
+----------+-----------------------------+---------------------+--------+
| Charset   | Descr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ