mysql ÀÛ¼ÓÔËËã - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
sp ³ÌÐò
delimiter //
create procedure ma()
begin
declare i int default 0;
while i<11 do
set i=i+1;
select i;
end while;
end //
delimiter ;
1+2+...+9+10
ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û
//Çë˵Ã÷Õâ¸ö³ÌÐòµÄȱÏݺ͸Ľø·½·¨¡£¡£Ð»Ð»¸÷λ´ó¸ç
SQL code:
mysql> call ma();
+------+
| j |
+------+
| 55 |
+------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
˳±ãÎÊÒ»ÏÂ
SQL code:
delimiter //
create procedure test07()
begin
declare i int ;
set i=1; --Õâ¸öµØ·½ÉèÖóÉi=1 ¿ÉÒÔÊäÈëµã¶«Î÷¡£¡£µ«ÊÇi=0ΪʲôÊÇÎÞÏÞÑ»·£¿
while i<10 do
set i=i+1;
select i;
end while;
end //
delimiter ;
º¹£¬Äã±¾ÉíµÄ³ÌÐòÊÇÍù±äÁ¿IÒ»Ö±ÀÛ¼Ó1¡£ ×Ðϸ¿´Ï¾ÍÃ÷°×ÁË¡£
Ïà¹ØÎÊ´ð£º
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
SQL code:
create procedure proc_batchUpdate(in categoryId integer , in artIds varchar(50))
begin
set @dsql = count('update article set type=' , categoryId , ' where id in (' , artIds , ' ......
½ñÌìÏëµ½¸öÎÊÌ⣬mysql¿ÉÒÔµ¼³ö±í£¬Êý¾Ý¿â£¬Ôõôµ¼³öij¸ö×ֶεÄÊý¾ÝÄØ£¿²»ÖªµÀ´ó¼ÒÓÐûÓÐÕâôÊÔ¹ýµÄ£¿ÊDz»Êǵ¼³öÊý¾ÝµÄ×îСµ¥Î»¾ÍÊÇ±í£¿
Óù¤¾ß¿ÉÒÔÑ¡ÔñÁеģ¬±ÈÈçsqlyog
лл£¬ÒѾ½â¾ö£¬ÎÒÓõÄÊÇÃüÁºÇºÇ
......
phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë
ÀýÈ磺
SELECT time, goodid from dbname1.time, dbname2.goods
ÊÇÕâ¸öÒâ˼ô£¿
SELECT time, goodid from ......