mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
mysql´æ´¢¹ý³ÌµÄ´´½¨£¬É¾³ý£¬µ÷Óü°ÆäËû³£ÓÃÃüÁî
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
< СÓ
Ïà¹ØÎĵµ£º
ÔËÐгÌÐò¿ÉÄܻᱨ´í£ºCan’t connect to local MySQL Server through socket ‘/tmp/mysql.sock’
Õâ¸ö´íÎóµÄÌáʾÊÇ˵£¬²»ÄÜͨ¹ý’/tmp/mysql.sock’Á¬½Óµ½·þÎñÆ÷¡£Mysql.sockÊÇ´´½¨Óëmysqld·þÎñÆ÷Ïà¹ØµÄMySQLͨÐŶ˵ãËùʹÓõÄÌ×½Ó×Ö¡£¶øPHP±ê×¼ÅäÖÃÕýÊÇͨ¹ý’/tmp/mysql.sock’À´Á¬½Ó ......
ÀýÈ磬MySQLĬÈϵÄÊý¾ÝÎļþ´æ´¢Ä¿Â¼Îª/var/lib/mysql¡£¼ÙÈçÒª°ÑÄ¿Â¼ÒÆµ½/home/dataÏÂÐèÒª½øÐÐÏÂÃæ¼¸²½£º
1¡¢homeĿ¼Ï½¨Á¢dataĿ¼
cd /home
mkdir data
2¡¢°ÑMySQL·þÎñ½ø³ÌÍ£µô£º
......
http://www.ej38.com/showinfo/mysql-130795.html
CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½
Ò»¡¢»·¾³
¡¡¡¡A·þÎñÆ÷£º 192.168.10.42 Ö÷·þÎñÆ÷master¡¡¡¡CentOS 5¡¡¡¡Mysql 5.1.34
¡¡¡¡B·þÎñÆ÷£º 192.168.10.68 ¸±·þÎñÆ÷slave¡¡¡¡¡¡CentOS 5¡¡¡¡Mysql 5.0.56
¶þ¡¢ÉèÖÃMas ......
ÎÊÌ⣺һ¿ªÊ¼ÎÒÓÃNavicat Lite for mysql ½«Êý¾Ý¿âת´æ´¢Î»sqlÎļþ¡£´ò¿ªÖ®ºó·¢ÏÖ£¬ÖÐÎͼ±ä³ÉÁËÂÒÂë¡£
ËùÒÔ ÔÚÍøÉÏËÑË÷ÁËЩ×ÊÁÏ¿´¿´¡£·¢¾õ´ó¼Ò¶¼ÊÇÓÃÃüÁîµ¼³öµÄ¡£ÓÃÁËÖ®ºó£¬ÖÐÎľͲ»ÂÒÂëÁË¡£½â¾öÁËÎÒµÄÒ»¸öÄÑÌâ¡£ÌØ´Ë¼ÇÏ¡£
·½·¨:
Ê×ÏÈÈ·ÈÏ mysql·þÎñÊÇ¿ªÆôµÄ¡£
È»ºóµã“¿ªÊ¼”ÔËÐÐÊäÈëcmd£¬½øÈëDOS»·¾³¡£cd ......
ÔÚÍøÉÏÕÒÁ˺ܾã¬ÎÄÕ¶¼ÊÇÄ㳡¢ÎÒ³Äã¡£¿´À´¿´È¥¶¼Ò»ÑùµÄ£¬googleÍùºó·NÒ³ ½øÈ¥Ò»¿´¶¼ÊÇÒ»ÑùµÄ¡£ÓôÃÆÖÁ¼«¡£ ÓÚÉÏÊÇCSDNÂÛ̳ÇóÖú£¬»¹ÊÇjava\web̳×ÓÀïµÄÅóÓÑÈÈÇéЩ£¬ÖÕÓÚËãÊǸãºÃÁË£¬×Ô¼ºÔÙÊÔÁËÏ£¬°ÑÐĵ÷¢³öÀ´´ó¼ÒÖ¸µãÖ¸µã¡£ 1¡¢mysql-connector-java-5.0.8-bin.jarÎļþ£¬Ò²¾ÍÊÇmysqlÇý¶¯°ü¡£×¢Ò⣺Ҫ·Åµ½tomcat ......