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

mysql º¯Êý

***function(/*³£Óú¯Êý*/)***
----ͳ¼Æº¯Êý----
AVG    --Ç󯽾ùÖµ
COUNT   --ͳ¼ÆÊýÄ¿
MAX    --Çó×î´óÖµ
MIN    --Çó×îСֵ
SUM    --ÇóºÍ
--AVG
use pangu
select avg(e_wage) as dept_avgWage
from employee
group by dept_id
--MAX
--Çó¹¤×Ê×î¸ßµÄÔ±¹¤ÐÕÃû
use pangu
select e_name
from employee
where e_wage =
 (select max(e_wage)
  from employee)
--STDEV()
--STDEV()º¯Êý·µ»Ø±í´ïʽÖÐËùÓÐÊý¾ÝµÄ±ê×¼²î
--STDEVP()
--STDEVP()º¯Êý·µ»Ø×ÜÌå±ê×¼²î
--VAR()
--VAR()º¯Êý·µ»Ø±í´ïʽÖÐËùÓÐÖµµÄͳ¼Æ±äÒìÊý
--VARP()
--VARP()º¯Êý·µ»Ø×ÜÌå±äÒìÊý
----ËãÊõº¯Êý----
/***Èý½Çº¯Êý***/
SIN(float_expression) --·µ»ØÒÔ»¡¶È±íʾµÄ½ÇµÄÕýÏÒ
COS(float_expression) --·µ»ØÒÔ»¡¶È±íʾµÄ½ÇµÄÓàÏÒ
TAN(float_expression) --·µ»ØÒÔ»¡¶È±íʾµÄ½ÇµÄÕýÇÐ
COT(float_expression) --·µ»ØÒÔ»¡¶È±íʾµÄ½ÇµÄÓàÇÐ
/***·´Èý½Çº¯Êý***/
ASIN(float_expression) --·µ»ØÕýÏÒÊÇFLOAT ÖµµÄÒÔ»¡¶È±íʾµÄ½Ç
ACOS(float_expression) --·µ»ØÓàÏÒÊÇFLOAT ÖµµÄÒÔ»¡¶È±íʾµÄ½Ç
ATAN(float_expression) --·µ»ØÕýÇÐÊÇFLOAT ÖµµÄÒÔ»¡¶È±íʾµÄ½Ç
ATAN2(float_expression1,float_expression2)
        --·µ»ØÕýÇÐÊÇfloat_expression1 /float_expres-sion2µÄÒÔ»¡¶È±íʾµÄ½Ç
DEGREES(numeric_expression)
                       --°Ñ»¡¶Èת»»Îª½Ç¶È·µ»ØÓë±í´ïʽÏàͬµÄÊý¾ÝÀàÐÍ¿ÉΪ
        --INTEGER/MONEY/REAL/FLOAT ÀàÐÍ
RADIANS(numeric_expression) --°Ñ½Ç¶Èת»»Îª»¡¶È·µ»ØÓë±í´ïʽÏàͬµÄÊý¾ÝÀàÐÍ¿ÉΪ
        --INTEGER/MONEY/REAL/FLOAT ÀàÐÍ
EXP(float_expression)  --·µ»Ø±í´ïʽµÄÖ¸ÊýÖµ
LOG(float_expression)  --·µ»Ø±í´ïʽµÄ×ÔÈ»¶ÔÊýÖµ
LOG10(float_expression)--·µ»Ø±í´ïʽµÄÒÔ10 Ϊµ×µÄ¶ÔÊýÖµ
SQRT(float_expression) --·µ»Ø±í´ïʽµÄƽ·½¸ù
/***È¡½üËÆÖµº¯Êý***/
CEILING(numeric_expression)  --·µ»Ø>=±í´ïʽµÄ×îСÕûÊý·µ»ØµÄÊý¾ÝÀàÐÍÓë±í´ïʽÏàͬ¿ÉΪ
    


Ïà¹ØÎĵµ£º

MySQL+PHPÂÒÂë½â¾ö ÄÏÈý·½

 MySQL+PHP²úÉúÂÒÂëÔ­Òò£º
¡ô MySQLÊý¾Ý¿âĬÈϵıàÂëÊÇutf8,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄPHPÍøÒ³²»Ò»ÖÂ,¿ÉÄܾͻáÔì³ÉMySQLÂÒÂ룻
¡ô MySQLÖд´½¨±íʱ»áÈÃÄãÑ¡ÔñÒ»ÖÖ±àÂë,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄÍøÒ³±àÂë²»Ò»ÖÂ,Ò²¿ÉÄÜÔì³ÉMySQLÂÒÂ룻
¡ô MySQL´´½¨±íʱÌí¼Ó×Ö¶ÎÊÇ¿ÉÒÔÑ¡Ôñ±àÂëµÄ,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄÍøÒ³±àÂë²»Ò»ÖÂ,Ò²¿ÉÄÜÔì³ÉMySQ ......

shell״̬ÏÂÀûÓÃmysqladmin¿ìËÙ¸ü¸ÄmysqlÏÂÓû§µÄÃÜÂë

Óï·¨:
/usr/local/mysql/bin/mysqladmin -u username -p newpassword
ϵͳ»áÌáʾÄúÊäÈë¾ÉÃÜÂë:
°´Enterºó,ϵͳ½«¾ÉµÄÃÜÂë¸Ä³Énewpassword,
×¢Òânewpassword²»ÊÇÃüÁî,ÊÇÒ»¸ö×Ö´®,¾ÍÊÇÐÂÃÜÂëµÄ×Ö´®,Äã¿ÉÒÔ¸ü¸Ä³ÉÆäËüµÄ.
-uºóÃæ¸ú×ÅÊÇÓû§Ãû,¾ÍÊÇÄãËùÒª¸ü¸ÄµÄÓû§Ãû. ......

mysql ³£ÓÃÃüÁî £¨×ª£©

µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......

Head First PHP MYSQL Ñ§Ï°Ëæ±Ê 1


1) 
°²×°Apache/2.2.14 ºÍ PHP/5.2.12 Ö®ºó£¬ÖØÐÂÆô¶¯Apache£¬Æô¶¯Ê§°Ü¡£²éÁËһЩ×ÊÁÏ£¬»ù±¾Éϸø³öµÄ½¨ÒéÊǽûµôExtension¡£ÎÒ¾Í×°ÁËÒ»¸öExtesion Mysqli¡£
ÐÞ¸Äphp.ini ×¢Ê͵ôÕâÒ»ÐУ¬¹ûÈ»ÉúЧ¡£
[PHP_MYSQLI]
;extension=php_mysqli.dll
°²×°Íêmysql£¬ÔÙÖØÐÂenableÕâ¸öÅäÖþͺÃÁË£¬¹À¼ÆÊÇÒÀÀµÄ³Ð©mysqlµÄ¿â¡£ ......

MySQLÊý¾Ý¿â¸´ÖÆMaster Master Slave¼Ü¹¹

ÎÒÃÇÓÃMaster-Slaves¼Ü¹¹½â¾öÁ˶ÁѹÁ¦±È½Ï´óµÄÓ¦Ó㬶øÎÒÃÇÓÃMaster-Master¼Ü¹¹½â¾öÁ˵¥µã·þÎñÎÊÌ⣬ÌṩÁËϵͳµÄ¿ÉÓÃÐÔ¡£µ«ÊÇÓÐʱÎÒÃÇÃæÁÙ¾Þ´óµÄ¶ÁÊý¾ÝѹÁ¦£¬ÌرðÊÇwebϵͳ£¬ÓÖÐèÒª½â¾öµ¥µã·þÎñµÄÎÊÌ⣬ΪӦÓÃÌṩ×ã¹»¸ßµÄ¿ÉÓÃÐÔ¡£ÕâʱÎÒÃǾÍÐèÒª½«ÕâÁ½Öּܹ¹½áºÏÆðÀ´¡£Õâ¾ÍÊÇMaster-Master-Slaves¼Ü¹¹¡£½á¹¹Í¼ÈçÏÂ
Maste ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ