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

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


Ïà¹ØÎĵµ£º

java ²åÈëÊý¾Ýµ½ mysql ÂÒÂë ×î¼Ñ½â¾ö

 ÊÖ¶¯½¨±í£º
CREATE TABLE `excel` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `passwd` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;  ×¢ÒâÊÇgb2312
È»ºóÔÚÁ¬½ÓÊý¾Ý¿âʱ¼ÓÉÏ:
useUnicode=true&characterEncoding=gb2312.
¾ÍokÀ²£¡ ......

MySql³£ÓÃÃüÁî

  Æô¶¯£ºnet start mySql;
  ½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
  ÁгöÊý¾Ý¿â£ºshow databases;
  Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
  Áгö±í¸ñ£ºshow tables£»
  ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
  ½¨Á¢Êý¾Ý¿â£ºsource fileNa ......

·ÖÏíÒ»¸ömysqlÀà~

 
<?php
/**
* ²Ù×÷mysql
µÄ»ù´¡À࣬ÆäËüÓëmysqlÓйصÄÀà¶¼¼Ì³ÐÓÚ´Ë»ùÀà
*
* ´ËclassÖеÄ$table¶¼ÊÇÒѾ­°üº¬±íǰ׺µÄÍêÕû±íÃû
*
* ver 20090717
* ʹÓ÷¶Àý
* $db = new DB('localhost','root','password','database','utf8');
* $db->debug = true;
* $db->primaryKeys = array (
* 'table_1 ......

mysql±¸·ÝÊý¾Ý¿âÒÔ¼°¿½±´Êý¾Ý¿âµ½Áíһ̨·þÎñÆ÷ÉÏ

 ÏîĿҪ½áÊøÁË...ÖÁÉÙ¿ª·¢Òª½áÊøÁË...
»ØÍ·¿´¿´×Ô¼º¾ÍÕâôһ¸öÈËÂñÍ·¿ª·¢ÁË4¸öÔ£¬ÒÔ¼°ÊÖÉÏÄõ½µÄÓë×Ô¼º¸¶³öÍêÈ«²»³ÉÕý±ÈµÄ΢±¡¹¤×Ê£¬¾õµÃ×Ô¼ºÕætmdµÄ±¯¾ç£¡
»òÐíÕâ¾ÍÊÇÓ¦½ì±ÏÒµÉúµÄÃü°É...¶÷£¬ÏÖÔÚÎÒÒѾ­²»ÊÇÓ¦½ì±ÏÒµÉúÁË...
ÏÖÔÚÏîÄ¿×öÍêÁË£¬ÎÒÒ²¾¡µ½ÁËÉÆÊ¼ÉÆÖÕµÄÒåÎñÁË...
¿àË®¾Íµ¹µ½ÕâÀ»¹ÊǻعéÕýÌâ¡£
ÓÉÓ ......

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

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