cmd ÃüÁîÐÐÏÂmysqlµÄ֪ʶ
*************************×Ö·û´®º¯Êý***********************************
mysql> select concat('aa','bb');//×Ö·û´®µÄÁ¬½Ó
mysql> select insert ('beijing2008you',12,3,'me');//×Ö·û´®µÄ²åÈë
+-------------------------------------+
| insert ('beijing2008you',12,3,'me') |
+-------------------------------------+
| beijing2008me |
+-------------------------------------+
mysql> select lower('ABC');//´óдת»»³ÉСд
mysql> select upper('abc');//Сдת»»³É´óд
mysql> select left('abcd',2);//×óÈ¡×Ö·û´®
+----------------+
| left('abcd',2) |
+----------------+
| ab |
+----------------+
mysql> select right('abcd',2);//ÓÒÈ¡×Ö·û´®
mysql> select lpad('2008',20,'beijing');//³¤¶ÈΪ20£¬ÓÃbeijing´Ó×ó±ßÌî³ä¡£
+---------------------------+
| lpad('2008',20,'beijing') |
+---------------------------+
| beijingbeijingbe2008 |
+---------------------------+
mysql> select rpad('2008',20,'beijing');//³¤¶ÈΪ20£¬ÓÃbeijing´ÓÓÒ±ßÌî³ä¡£
mysql> select ltrim(' beijing');//È¥µô×ó±ßµÄ¿Õ¸ñ
mysql> select rtrim('beijing ');//È¥µôÓұߵĿոñ
mysql> select trim(' beijing ');//È¥µôÁ½±ßµÄ¿Õ¸ñ
mysql> select repeat('ab',3);//ÖØ¸´'ab'Èý´Î
mysql> select replace('beijing2010','2010','2008');//×Ö·û´®µÄÌæ»»
mysql> select strcmp('a','b');//×Ö·û´®µÄ±È½Ï£¬·µ»ØÖµÎª-1,0,1.
mysql> select substring('beijing2008',8,4);//È¡×Ó´®¡£·µ»Ø2008
*******************************ÊýÖµº¯Êý********************************
mysql> select abs(-23);//È¡¾ø¶ÔÖµ
mysql> select ceil(4.5);//·µ»Ø´óÓÚËüµÄÕûÊý
mysql> select floor(4.5);//·µ»ØÐ¡ÓÚËüµÄÕûÊý
mysql> select mod(3,2);//ȡģ
mysql&
Ïà¹ØÎĵµ£º
»·¾³£º
²Ù×÷ϵͳ£ºWIN2003
MySql£ºmysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)
˼Ï룺
ΪÁ˰²È«¼ÓÃÜÐèÒªÉèÖÃmysqlÊý¾Ý¿âÏà¹ØÓû§µÄÃÜÂ룻
MySqlÊý¾Ý¿âµÄÃÜÂë¶¼ÊDZ£´æÔÚmysqlÊý¾Ý¿âʵÀýµÄuser±íÖеÄpassword×Ö¶ÎÀͨ¹ýPASSWORD("")µÄº¯Êý¶ÔÃÜÂë¼ÓÃܺ󱣴æÔÚ±íÖУ»
ËùÒÔÒªÐÞ¸ÄÓû§µÄÃÜÂëÖ ......
[MySQLÓÅ»¯] -- ÈçºÎ¶¨Î»Ð§Âʽϵ͵ÄSQL
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:zhenpao
Ò»°ãͨ¹ýÒÔÏÂÁ½ÖÖ·½Ê½¶¨Î»Ö´ÐÐЧÂÊ½ÏµÍµÄ SQL Óï¾ä¡£ Âý²éѯÈÕÖ¾ÔÚ²éѯ½áÊøÒÔºó²Å¼Í¼£¬ËùÒÔÔÚÓ¦Ó÷´Ó³Ö´ÐÐЧÂʳöÏÖÎÊÌâµÄʱºò²éѯÂý²éѯÈÕÖ¾²¢²»Äܶ¨Î»ÎÊÌ⣬¿ÉÒÔʹÓà show processlist ÃüÁî²é¿´µ±Ç° MySQL ÔÚ½øÐеÄỊ̈߳¬° ......
ת×Ôhttp://www.phpvim.net/windows/build-mysql-client-on-cygwin.html
MinTTY ÊÇÒ»¸öСÇɵ«È´ºÜʵÓÃµÄ Cygwin ÖÕ¶Ë»ú£¬µ«ÓиöÑÏÖØµÄÎÊÌâ¾ÍÊÇÎÞ·¨µ÷Óý»»¥Ð﵀ Windows ÔÉú³ÌÐò£¬±ÈÈç˵
mysql.exe£¬µ±ÄãÔÚ MinTTY ÖÐÊäÈëÈçϵÄÃüÁ
1
$ mysql -uroot
-p
±¾À´ mysql.exe »áÌáʾÊäÈëÃÜÂ룬µ«ÔÚ MinTTY ÖгÌÐò»áÖ± ......
¹ýÈ¥µÄÒ»¸öÔ£¬ÎҵŤ×÷ÖØÐͼÔںϷþÄ£¿éµÄ²âÊÔ¡£ÆÄÓÐһЩÊÕ»ñ¡£
´Ë´Î´óÁ¿ºÍmysql´ò½»µÀ£¬¶Ô²úÆ·µÄÊý¾Ý´æ´¢ÓÐÁ˱ȽÏÈ«ÃæµÄÕÆÎÕ¡£²¢´ÙʹºÍÖ´ÐÐÁËdbµÄ±í½á¹¹ºÍÊôÐԵļì²é¡£ºÏ·þͶ·Åºó£¬ÔÝδ·¢ÏÖÒò´íÎóÊý¾Ýµ¼ÖµÄbug»òʹʡ£
²¢ÔÚ²âÊÔ³õÆÚ¾Í¹Ø×¢ºÍ¼ì²âÐÔÄÜÖ¸±ê£¬´Ùʹ³ÌÐò×öÁËÒ»´ÎÐÔÄܲâÊÔ£»¶ÔͶ·ÅʱµÄ·çÏÕÔöÇ¿ÁËÔ¤·ÀºÍ¿ØÖÆ¡£ ......