mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ý³ÌûÓвÎÊý´«µÝ
Èý.ɾ³ý´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
drop procedure sp_name//
2.×¢ÒâÊÂÏî
(1)²»ÄÜÔÚÒ»¸ö´æ´¢¹ý³ÌÖÐɾ³ýÁíÒ»¸ö´æ´¢¹ý³Ì£¬Ö»Äܵ÷ÓÃÁíÒ»¸ö´æ´¢¹ý³Ì
ËÄ.Çø¿é£¬Ìõ¼þ£¬Ñ»·
1.Çø¿é¶¨Ò壬³£ÓÃ
begin
……
end;
Ò²¿ÉÒÔ¸øÇø¿éÆð±ðÃû£¬È磺
lable:begin
………..
end lable;
¿ÉÒÔÓÃleave lable;Ìø³öÇø¿é£¬Ö´ÐÐÇø¿éÒÔºóµÄ´úÂë
2.Ìõ¼þÓï¾ä
if Ìõ¼þ then
statement
else
statement
end if;
3.Ñ»·Óï¾ä
(1).whileÑ»·
[label:] WHILE expression DO
statements
END WHILE [label] ;
(2).loopÑ»·
[label:] LOOP
statements
END LOOP [label];
(3).repeat untilÑ»·
[label:] REPEAT
statements
UNTIL expression
END REPEAT [label] ;
Îå.ÆäËû³£ÓÃÃüÁî
1.show procedure status
ÏÔʾÊý¾Ý¿âÖÐËùÓд洢µÄ´æ´¢¹ý³Ì»ù±¾ÐÅÏ¢£¬°üÀ¨ËùÊôÊý¾Ý¿â£¬´æ´¢¹ý³ÌÃû³Æ£¬´´½¨Ê±¼äµÈ
2.show create procedure sp_name
ÏÔʾijһ¸ö´æ´¢¹ý³ÌµÄÏêϸÐÅÏ¢
mysql´æ´¢¹ý³ÌÖÐÒªÓõ½µÄÔËËã·û
mysql´æ´¢¹ý³Ìѧϰ×ܽᣲÙ×÷·û
ËãÊõÔËËã·û
+ ¼Ó SET var1=2+2; 4
- ¼õ SET var2=3-2; 1
* ³Ë SET var3=3*2; 6
/ ³ý SET var4=10/3; 3.3333
DIV Õû³ý SET var5=10 DIV 3; 3
% È¡Ä£ SET var6=10%3 ; 1
±È½ÏÔËËã·û
> ´óÓÚ 1>2 False
< СÓÚ 2<1 False
<=  
Ïà¹ØÎĵµ£º
×òÌìΪһ¸öÏîÄ¿×öÊý¾Ý¿â£¬ÏîÄ¿Éæ¼°µ½¶©µ¥£¬ÔÚÉè¼ÆÊý¾Ý¿â×ÖµäµÄʱºò ¾Í°ÑÕâ¸ö±íÃû¶¨ÎªÁËorder£¬½¨±íµÄʱºòÔõô½¨¶¼²»¶Ô£¬ÌáʾÊDZíÃû¸½½ü³öÏÖÎÊÌ⣬µ±Ê±¾õµÃ²»¿ÉÄÜ°¡ Ò²ÐíÊÇ×Ö¶ÎÀàÐÍÄĶù³öÁËÎÊÌ⣬²éÁ˺þã¬ÊÔÁ˺ü¸´Î£¬»¹ÊDz»ÐУ¬ºóÀ´Í»È»»ÐÈ»´óÎò£¬order byÊÇÅÅÐòÓï¾ä£¬order¿Ï¶¨ÊDZ£Áô×Ö£¬Ôõô¿ÉÄÜ×ö±íÃûÄØ¡£¡£¡£Á¢¼´°Ñ±í ......
ËäÈ»ºÜ¶àÈËÓÃmysql front£¬ µ«ÊǸöÈ˾õµÃmysql»¹ÊÇÃüÁîÐÐϱȽϺÃÓ㬱Ͼ¹Êý¾Ý¿âÔÚÃüÁîÐÐϲÙ×÷±È½ÏÍõµÀ¶øÇÒmysqlÍêÈ«Ãâ·Ñ¡£¡£
ÏÂÃæ½éÉÜһЩmysqlÃüÁîÐÐϳ£ÓõÄÃüÁÓÐһЩÊý¾Ý¿â»ù´¡µÄ£¬¼´Ê¹ÊǵÚÒ»´ÎÓÃmysql¶ÔÕÕÏÂÃæµÄÃüÁî²Ù×÷Ò²ÍêÈ«¿ÉÒÔ£¬Èç¹ûÎÒ·¢ÏÖ»¹ÓÐÆäËüÃüÁîÒ²ÊǾ³£Óõ½µÄÎÒ»á½Ðø¸üС£¡£¡£
·þÎñÆ÷£º
1. Æô¶¯m ......
delimiter // ¸Ä±ä½ç¶¨·û Ϊ//
ÁгöËùÓÐÊý¾Ý¿â show databases;
ÁгöËùÓÐÊý¾Ý±í show tables;
¸Ä±äÁ¬½ÓÊý¾Ý¿â use databaes
²åÈë¼Ç¼ insert into users(UserName,Password) values('ivwshjj','123456');
ɾ³ý¼Ç¼ delete from users  ......
ÔÚ×ÀÃæÉÏн¨Ò»¸ö¿ÕµÄÎı¾Îļþmysql.txt,ÖØÃüÃûΪmysql.udl,Ë«»÷Õâ¸ömysql.udlÎļþ£¬´ò¿ª“Êý¾Ý¿âÁ¬½ÓÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ìṩ³ÌÐò”ҳѡÔñ”Micrsoft Ole DB Provider for ODBC Drivers“£¬ µã»÷ÏÂÒ»²½£¬ÔÚ“Á¬½Ó”Ò³µÄ,"Ö¸¶¨Êý¾ÝÔ´"Ñ¡Ôñ"ʹÓÃÁ¬½Ó×Ö·û´®",µã» ......
create database testdb; /* ´´½¨Êý¾Ý¿â */
use testdb; /* ´ò¿ªÊý¾Ý¿â */
/*grant ÆÕͨÊý¾ÝÓû§£¬²éѯ¡¢²åÈë¡¢¸üС¢É¾³ý Êý¾Ý¿âÖÐËùÓбíÊý¾ÝµÄȨÀû*/
grant select,insert,update,delete on testdb.* to common_user@'%';
grant select,insert,update,delete on testdb.* to common_user@'localhost'; ......