MySql´´½¨´æ´¢¹ý³ÌÎÊÌâ ¼±£¡
drop procedure if exists pr_add;
create procedure pr_add()
begin
select *from tbA
end
ÕâÑù´´½¨Óдíô£¿
ÓеÄÈÏΪӦ¸ÃÊÇÕâÑù£º
drop procedure if exists pr_add;
create procedure pr_add()
begin
select *from tbA£»
end
ÕâÑùµÄ»°¸ÕÊäÈëµ½select *from tbA£»°´»Ø³µ£¬ÃüÁî¾ÍĬÈϽáÊø£¬¾Í³ö´íÁË
¸ÃÔõô´´½¨ÄØ£¬ÊÇÎÒ×°µÄMySQL²»Ö§³Ö´æ´¢¹ý³Ìô£¿ÎÒ×°µÄÊÇMySQL5.0µÄ
Íû¸ßÊÖÖ¸µã¹þ
Ç°Ãæ¼ÓÉÏdelimiter //
×îºó¼ÓÉÏ //
SQL code:
mysql> delimiter //
mysql> drop procedure if exists pr_add//
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> create procedure pr_add()
-> begin
-> select * from test;
-> end
-> //
Query OK, 0 rows affected (0.03 sec)
mysql> call pr_add()//
+------+------+------+---------------------+
| id | name | num | rtime |
+------+------+------+---------------------+
| 1 | nike | 600 | 2009-04-21 12:45:12 |
| 2 | nike | 200 | 2009-06-04 20:03:42 |
| 3 | nike | 200 | 2009-03-30 14:00:00 |
| 3 | nike | 400 | 2009-03-20 14:00:00 |
| 4 | nike | 100 | 2009-03-15 10:30:20 |
| 5 | nike | 200 | 2009-03-12 12:23:30 |
+------+------+------+---------------------+
6 rows in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
ÓÃSQLyogÀ´´´½¨º
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......