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
µÄ³¤¶È£¬³¤¶ÈµÄµ¥Î»Îª×Ö·û¡£Ò»¸ö¶à×Ö½Ú×Ö·ûËã×÷
Ïà¹ØÎĵµ£º
ÊÖ¶¯½¨±í£º
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À²£¡ ......
Æô¶¯£º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 ......
<?php
/**
* ²Ù×÷mysql
µÄ»ù´¡À࣬ÆäËüÓëmysqlÓйصÄÀà¶¼¼Ì³ÐÓÚ´Ë»ùÀà
*
* ´ËclassÖеÄ$table¶¼ÊÇÒѾ°üº¬±íǰ׺µÄÍêÕû±íÃû
*
* ver 20090717
* ʹÓ÷¶Àý
* $db = new DB('localhost','root','password','database','utf8');
* $db->debug = true;
* $db->primaryKeys = array (
* 'table_1 ......
ÏîĿҪ½áÊøÁË...ÖÁÉÙ¿ª·¢Òª½áÊøÁË...
»ØÍ·¿´¿´×Ô¼º¾ÍÕâôһ¸öÈËÂñÍ·¿ª·¢ÁË4¸öÔ£¬ÒÔ¼°ÊÖÉÏÄõ½µÄÓë×Ô¼º¸¶³öÍêÈ«²»³ÉÕý±ÈµÄ΢±¡¹¤×Ê£¬¾õµÃ×Ô¼ºÕætmdµÄ±¯¾ç£¡
»òÐíÕâ¾ÍÊÇÓ¦½ì±ÏÒµÉúµÄÃü°É...¶÷£¬ÏÖÔÚÎÒÒѾ²»ÊÇÓ¦½ì±ÏÒµÉúÁË...
ÏÖÔÚÏîÄ¿×öÍêÁË£¬ÎÒÒ²¾¡µ½ÁËÉÆÊ¼ÉÆÖÕµÄÒåÎñÁË...
¿àË®¾Íµ¹µ½ÕâÀ»¹ÊǻعéÕýÌâ¡£
ÓÉÓ ......
Ò»¡¢mysql µÄ¹ÜÀí
1
¡¢Á¬½Ó
Mysql
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£º ......