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&
Ïà¹ØÎĵµ£º
MySql°æ±¾ÐÅÏ¢µÄ²éѯ£º
1¡¢Í¨¹ýmysql -VÃüÁî²éѯ
C:\mysql\bin>mysql -V
mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)
2¡¢Í¨¹ýmysqlģʽϵÄstatusÃüÁî²é¿´×´Ì¬
mysql> status
--------------
mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)
Connection id: &nbs ......
[MySQLÓÅ»¯] -- ÈçºÎʹÓÃSQL Profiler ÐÔÄÜ·ÖÎöÆ÷
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:diesou
mysql µÄ sql ÐÔÄÜ·ÖÎöÆ÷Ö÷ÒªÓÃ;ÊÇÏÔʾ sql Ö´ÐеÄÕû¸ö¹ý³ÌÖи÷Ïî×ÊÔ´µÄʹÓÃÇé¿ö¡£·ÖÎöÆ÷¿ÉÒÔ¸üºÃµÄչʾ³ö²»Á¼ SQL µÄÐÔÄÜÎÊÌâËùÔÚ¡£ ÏÂÃæÎÒÃǾÙÀý½éÉÜһϠMySQL SQL Profiler µÄʹÓ÷½·¨£º Ê×ÏÈ£¬¿ªÆô MySQL SQL ......
ת×Ô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ÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£MySQLÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqldºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£ÓÉÓÚÆäÔ´ÂëµÄ¿ª·ÅÐÔ¼°Îȶ¨ÐÔ£¬ÇÒÓëÍøÕ¾Á÷ÐÐ±à »ÓïÑ PHPµÄÍêÃÀ½áºÏ£¬ÏÖÔںܶàÕ¾µã¶¼ÀûÓÃÆäµ±×÷ºó¶ËÊý¾Ý¿â£¬Ê¹Æä»ñµÃÁ˹㷺ӦÓᣴ¦ÓÚ°²È«·½ÃæµÄ¿¼ÂÇ£¬ÐèҪΪÿһÓû§¸ ......
gNBpPFgyOw9Rwt/ozsnjgM7tJNo2 bhaaAThangemMkaz2tQhq3/f7dZ7 Vj29WeGHjuupj/AhYqymjAuokhYi X1T/fG+q1yR22PdcEP39dxU3ovEo lLLzwIZlQr9oJYwUf5eG4x5e1bMP nfIaIl8reszQPHFNbrxBjCVrBEXL TyBLehxzUpVI672t3LjX8q4ytCRC ezcoZQfMAc0DulJzNREbwlcf0Rco N0zW3ojBUxGsplBBZZPrD7/bPhkM rjtS8Bxym+HeV1TJDTXuiL8QLg== ......