Ò».×Ö·û´®Àà
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
Ó¦¸Ã˵һ°ãµÄÊý¾Ý¿â¶¼ÓÐBackUpµÄÐèÇó, MySql±¸·ÝÊý¾Ý¿âµÄ·½Ê½ºÜ¼òµ¥, µ«ÊÇÔÚÍøÉÏ˵µÃÔÆÀïÎíÀï, Ò²Ó¦¸ÃÊÇÎÒ¶ÔMySqlÊý¾Ý¿â²»ÊìϤ.
Ä¿±ê(Target) : ½«±¾»úÖеÄmysqlÊý¾Ý¿â±¸·Ýµ½±¾»úÖеÄmydatabaseÊý¾Ý¿âÖÐ - Ò²¾ÍÊÇÍêÈ«µÄCopyÒ»¸öÊý¾Ý¿â.
#1. C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u ......