MySql´´½¨º¯Êý
Ê×ÏÈÐèÒª²é¿´Ò»Ï´´½¨º¯ÊýµÄ¹¦ÄÜÊÇ·ñ¿ªÆô£º
X:\proper\mysql\bin>mysql -h localhost -u root -p
Enter password: **********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 5.0.22-community-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show variables like '%func%';
+-----------------------------------------+-------+
| Variable_name | Value |
+-----------------------------------------+-------+
| log_bin_trust_function_creators | ON |
+-----------------------------------------+-------+
1 row in set (0.02 sec)
Èç¹ûValue´¦ÖµÎªOFF£¬ÔòÐ轫Æä¿ªÆô¡£
mysql> set global log_bin_trust_function_creators=1;
´´½¨º¯Êýʱ£¬ÏÈÑ¡ÔñÊý¾Ý¿â£¬
mysql> use xxx;
Database changed
delimiter $$ÊÇÉèÖà $$ΪÃüÁîÖÕÖ¹·ûºÅ£¬´úÌæ·ÖºÅ£¬ÒòΪ·ÖºÅÔÚbegin...endÖлáÓõ½£»
mysql> delimiter $$
mysql> create function test(t varchar(255))
-> returns varchar(255)
-> begin
-> return left(t,1);
-> end
-> $$
Query OK, 0 rows affected (0.13 sec)
º¯Êý´´½¨³É¹¦ºóÐè»Ö¸´·ÖºÅΪÃüÁîÖÕÖ¹·ûºÅ¡£
mysql> delimiter ;
²âÊÔ£º
mysql> select test('alpha');
+----------------+
| test('alpha') |
+---------------+
| a |
+---------------+
1 row in set (0.02 sec)
ɾ³ýº¯Êý£º
mysql> drop function test;
Query OK, 0 rows affected (0.11 sec)
Ïà¹ØÎĵµ£º
Ò»¡¢ ·ÖÇøµÄ¸ÅÄî
¶þ¡¢ ΪʲôʹÓ÷ÖÇø£¿£¨Óŵ㣩
Èý¡¢ ·ÖÇøÀàÐÍ
ËÄ¡¢ ×Ó·ÖÇø
Îå¡¢ ¶Ô·ÖÇø½øÐÐÐ޸ģ¨Ôö¼Ó¡¢É¾³ý¡¢·Ö½â¡¢ ......
ÓÐһЩûÓÐʹÓÃÊý¾Ý¿âÖмä¼þµÄÈí¼þ¿ÉÄÜ»áÅöµ½ÔÚ²»Í¬µÄÓ¦Óó¡¾°ÐèÒªÓò»Í¬µÄÊý¾Ý¿â£¬ÕâÑù¿ÉÄܾÍÐèÒª½«Êý¾Ý¿â´úÂë×öÒÆÖ²£¬ÎÒÕâÀïÕûÀíÁËһЩ´Óoracleµ½mysqlµÄÒÆÖ²¹ý³ÌÖеÄ×¢ÒâÊÂÏ
1¡£sequenceÉú³É
¿ÉÒÔÓÃÀàËÆµÄ¶«Î÷À´×ö,ÈçÏ£º
create table myseq ( &nb ......
Ò»¡¢³£ÓÃ×Ö·û´®º¯Êý
1.CONCAT(str1,str2,...)
mysql> ? concat;
mysql> SELECT CONCAT('My', 'S', 'QL');
+-------------------------+
| CONCAT('My', 'S', 'QL') |
+-------------------------+
| MySQL ......
MSSQL ÈçºÎʵÏÖ MySQL µÄ limit ²éѯ·½Ê½
²»ÖªÎªºÎ£¬MSSQL ÖÐûÓÐ limit Õâ¸ö¼«ÎªÖØÒªµÄ²éѯ·½Ê½£¬ÊìϤ MySQL µÄÅóÓѶ¼ÖªµÀ£¬MySQL µÄ limit ¶ÔÓÚʵÏÖ·ÖÒ³ºÍһЩÏÞÖÆ½á¹û¼¯µÄÓ¦ÓÃÖзdz£·½±ã¡£Ã»Óв»Òª½ô£¬ÎÒÃÇ¿ÉÒÔÓÃÆäËû·½·¨´ïµ½Í¬ÑùµÄÄ¿µÄ£¬×Ô¼º¶¯ÊÖ£¬·áÒÂ×ãʳ£¡
Óï·¨£º
Code:
SELECT * from
(
......
ÐÞ¸Ä /etc/mysql/my.cnf Îļþ£¬
ÔÚ £Ûclient£Ý ϼÓÈë default-character-set=utf8,
ÔÚ [mysqld] ϼÓÈë default-character-set=utf8,
ÔòÔÚviÀï¿ÉÒÔÕýÈ·µÄÏÔʾÖÐÎÄÁË£¨Ç°ÌáÊÇviҲʹÓÃutf8£©¡£
²»¹ýÔÚ²éѯµÄʱºò£¬½á¹ûÀïµÄÖÐÎÄÈ´»áÏÔʾ³É "?"£¬Õâ¸öÎÊÌâ±È½Ï¼òµ¥µÄ·½·¨Óм¸ÖÖ£¬·Ö±ðÊÇ£º
1.ÔÚ´´½¨Ê ......