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

mysql´æ´¢¹ý³Ì»ù±¾º¯Êý


Ò».×Ö·û´®Àà 
CHARSET(str) //·µ»Ø×Ö´®×Ö·û¼¯
CONCAT (string2  [,... ]) //Á¬½Ó×Ö´®
INSTR (string ,substring ) //·µ»ØsubstringÊ×´ÎÔÚstringÖгöÏÖµÄλÖÃ,²»´æÔÚ·µ»Ø0
LCASE (string2 ) //ת»»³ÉСд
LEFT (string2 ,length ) //´Óstring2ÖеÄ×ó±ßÆðÈ¡length¸ö×Ö·û
LENGTH (string ) //string³¤¶È
LOAD_FILE (file_name ) //´ÓÎļþ¶ÁÈ¡ÄÚÈÝ
LOCATE (substring , string  [,start_position ] ) ͬINSTR,µ«¿ÉÖ¸¶¨¿ªÊ¼Î»ÖÃ
LPAD (string2 ,length ,pad ) //ÖØ¸´ÓÃpad¼ÓÔÚstring¿ªÍ·,Ö±µ½×Ö´®³¤¶ÈΪlength
LTRIM (string2 ) //È¥³ýǰ¶Ë¿Õ¸ñ
REPEAT (string2 ,count ) //ÖØ¸´count´Î
REPLACE (str ,search_str ,replace_str ) //ÔÚstrÖÐÓÃreplace_strÌæ»»search_str
RPAD (string2 ,length ,pad) //ÔÚstrºóÓÃpad²¹³ä,Ö±µ½³¤¶ÈΪlength
RTRIM (string2 ) //È¥³ýºó¶Ë¿Õ¸ñ
STRCMP (string1 ,string2 ) //Öð×Ö·û±È½ÏÁ½×Ö´®´óС,
SUBSTRING (str , position  [,length ]) //´ÓstrµÄposition¿ªÊ¼,È¡length¸ö×Ö·û,
×¢£ºmysqlÖд¦Àí×Ö·û´®Ê±£¬Ä¬ÈϵÚÒ»¸ö×Ö·ûϱêΪ1£¬¼´²ÎÊýposition±ØÐë´óÓÚµÈÓÚ1
mysql> select substring(’abcd’,0,2);
+———————–+
| substring(’abcd’,0,2) |
+———————–+
|                       |
+———————–+
1 row in set (0.00 sec)
mysql> select substring(’abcd’,1,2);
+———————–+
| substring(’abcd’,1,2) |
+———————–+
| ab                    |
+———————–+
1 row in set (0.02 sec)
TRIM([[BOTH|LEADING|TRAILING] [padding] from]string2) //È¥³ýÖ¸¶¨Î»ÖõÄÖ¸¶¨×Ö·û
UCASE (string2 ) //ת»»³É´óд
RIGHT(string2,length) //È¡string2×îºólength¸ö×Ö·û
SPACE(count) //Éú³Écount¸ö¿Õ¸ñ 
¶þ.ÊýѧÀà
ABS (number2 ) //¾ø¶ÔÖµ
BIN (decimal_number ) //Ê®½øÖÆ×ª¶þ½øÖÆ
CEILING (numbe


Ïà¹ØÎĵµ£º

windows°²×°apache+php+mysqlµÄһЩ¼Ç¼

apache°²×°£¬mysql°²×°£¬php5Ö±½Ó½âѹ£¬¾ù·ÅÔÚD:\wwwÏ¡£
Ŀ¼½á¹¹Îª£º
D:\www\apache2
D:\www\mysql
D:\www\php5
½«php5\php.ini-dist¸´ÖÆÎªphp.ini£¬°ÑÐèÒªÓõ½µÄ×é¼þ½«Ç°ÃæµÄ;È¥µô¡£
Èç
extension=php_mysql.dll
extension=php_gd2.dll
ÔÚapache2µÄconf/httpd.confÎļþÖмÓ
LoadFile D:/www/php5/php5ts.dll
......

MySQL²é¿´ºÍµ¼Èëµ¼³öÃüÁî

1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í£º
   show databases;
   ¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐвÙ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
   use mysql£» //´ò¿ª¿â
   show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£ ......

java mysql ºº×Ö´æÈëʱÂÒÂë


´ÓÍøÂçÕª³­µ½µÄ½â¾ö·½·¨——
½â¾ö·½·¨¶þ£º
      Á¬½Ómysqlʱ(ÎÞÂÛÔÚ´Ómysql¶Á»¹ÊÇÈ¡Êý¾ÝµÄÇé¿ö)£¬Ö¸¶¨Ê¹ÓõıàÂ뷽ʽΪutf-8£¬¾ßÌå´úÂëÈçÏÂ
      //×°ÔØmysql-jdbcÇý¶¯
       Class.forName("com.mysql.jdbc.Driver" ......

MYSQL °²×°È«½â


Red Hat Linux ϰ²×°mysql°æ±¾³åÍ»ÎÊÌâ½â¾ö
¸ÕÅöµ½Ò»¸öÎÊÌ⣬ÓÉÓÚÔÚʹÓõÄlinux·þÎñÆ÷ÉÏÒѾ­°²×°ÁËÒ»¸ö½ÏµÍ°æ±¾µÄMySql server£¬Ê¹ÓÃrpm°ü½øÐа²×°Ê±£¬Ìáʾ°æ±¾³åÍ»£¬°²×°²»ÄܼÌÐø½øÐС£
ÓÉÓھɵÄÊý¾Ý²»ÏëÒªÁË£¬½â¾ö°ì·¨ÊÇÕâÑùµÄ£º
[b]1¡¢ÏȰÑϵͳÀï°²×°µÄËùÓÐmysqlÕÒ³öÀ´[/b]
#rpm -qa | grep -i mysql ÔËÐдËÃüÁîº ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ