MYSQLÓÐûÓа취»ñÈ¡µ±Ç°´ÅÅ̿ռäµÄ´óС£¬ºÍÊ£Óà¿Õ¼ä´óС£¬
ÄÜ»ñµÃÊ£Óà°Ù·Ö±ÈÒ²ÐУ¬Ð»Ð»
LinuxÏÂͨ¹ýdfÃüÁî¾Í¿ÉÒԲ鿴´ÅÅ̿ռä
ÒýÓÃMYSQLÓÐûÓа취»ñÈ¡µ±Ç°´ÅÅ̿ռäµÄ´óС£¬ºÍÊ£Óà¿Õ¼ä´óС£¬
ûÓУ¬ÄãÖ»ÄÜÀûÓòÙ×÷ϵͳµÄÃüÁî¡£
ÔÚMYSQLÖÐûÓд˹¦ÄÜ
[coolwind@localhost ~]$ mysql -uroot -S /usr/loc ......
±í
sid pid
1 0
2 0
3 1
4 2
5 1
6 2
7 3
8 3
9 3
10 4
Äܲ»Äܸ ......
BEGIN
select * from operator;
END
Õâ¾ÍÊÇÎÒ´æ´¢¹ý³ÌµÄÄÚÈÝ£¬ÔÚPHPÀïÔõô¿ÉÒԵõ½·µ»ØµÄ½á¹û¼¯£¿
¼ÙÉèÉÏÃæÊ¾ÀýµÄMySQL´æ´¢¹ý³ÌΪ:
SQL code:
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`proc_test` $$
CREATE PROCEDURE `test`.`proc_test` ()
BEGIN
select * from tbl_name;
......
ÎÒÏÖÔÚÓÐÁ½ÖÖÊý¾Ý¿â£¬Ò»¸öΪoracle 11g£¬°æ±¾Îª£º11.1.0.6.0 - 64bit£¬°²×°ÔÚHP-IA64µÄ·þÎñÆ÷ÉÏ£¬Ò»¸öΪmysql 5.1£¬°²×°ÔÚͬһ̨·þÎñÆ÷ÖС£
ÏÖÔÚҪʵÏÖoracleµÄÊý¾Ý¿âÄܹ»²éѯmysqlÊý¾Ý¿âµÄ±í£¬ÏëҪͨ¹ýoracleµÄÒì¹¹¹¦ÄÜÀ´ÊµÏÖ£¬µ«ÓÉÓÚСµÜ¶ÔÊý¾Ý¿âÁ˽ⲻÉ»¹Çë¸÷λ°ïæ¡£
ÒÔÏÂΪÎҵĸ ......
ÈçÌ⣬ÊDz»ÊÇÐèÒª·þÎñÆ÷µÄIP,Óû§ÃûºÍÃÜÂ룿
»¹ÊÇ˵±¸·Ý·þÎñÆ÷ÀïµÄMYSQLÊý¾Ý¿âÎļþ£¬È»ºó´Ó·þÎñÆ÷ÀïÏÂÔØÏÂÀ´£¬È»ºóµ¼Èëµ½±¾µØÊý¾Ý¿âÀÔõô±¸·Ý£¿
ÈçÌ⣬ÊDz»ÊÇÐèÒª·þÎñÆ÷µÄIP,Óû§ÃûºÍÃÜÂ룿
————————————————& ......
mysqlÖÐbigint£¬longtext£¬text£¬tinyint£¬smallintµÈ¶ÔÓ¦NhibernateÀïµÄʲôÀàÐÍÄØ
nhibernateÂäºóÁË£¬»¹ÊÇȥѧϰlinq£¬ÄǸö²ÅÊÇÕý¹æµÄhibernate¼¼Êõ
ÒýÓÃ
nhibernateÂäºóÁË£¬»¹ÊÇȥѧϰlinq£¬ÄǸö²ÅÊÇÕý¹æµÄhibernate¼¼Êõ
dblinqÂäºóÁË£¬ÏÖÔÚÊÇentityÁË¡£
......