Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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
<            СÓ


Ïà¹ØÎĵµ£º

¸ü¸ÄMySQLĿ¼µÄ·½·¨

   ÀýÈ磬MySQLĬÈϵÄÊý¾ÝÎļþ´æ´¢Ä¿Â¼Îª/var/lib/mysql¡£¼ÙÈçÒª°ÑÄ¿Â¼ÒÆµ½/home/dataÏÂÐèÒª½øÐÐÏÂÃæ¼¸²½£º
1¡¢homeĿ¼Ï½¨Á¢dataĿ¼
       cd /home
       mkdir data
2¡¢°ÑMySQL·þÎñ½ø³ÌÍ£µô£º
       ......

»ùÓÚmysqlµÄweb³ÌÐòµÄÒ»¸öÐÔÄÜÌáÉýµÄ·½°¸

½ñÌìºÍһλ¼Ü¹¹Ê¦ÁÄÁËһЩÎÊÌ⣬ºÜżȻµÄ˵³öÁËÒ»¸öÊÂÇ飬ÎұȽϸÐÐËȤÓÚÊǼǼһÏ£º
1£ºÎÒÃǶ¼ÖªµÀmysqlÏ µÄINNODBºÍMYISAMÁ½ÖÖÒýÇæ£¬ÆäÖÐINNODB¾ßÓÐÊÂÎï¹ÜÀí¡£ËùÒÔINNODBϲÙ×÷ºÍMYISAMϲÙ×÷£¬µ¥´¿µÄ´Ó²åÈëÊý¾Ý¿âÉÏ˵£¬INNDODBµÄ¿É¿¿£¬²éѯÉÏ˵MYISAMµÄÒª¿ì¡£
2£º»ùÓÚÉÏÃæµÄÌØÐÔ£¬ÒÔ¼°MYSQLjuyouµÄÖ÷´Ó»úÖÆ£¬ÎÒÃÇ¿ÉÒ ......

mysqlÊý¾Ý¿âµÄµ¼³öµ¼Èë

ÎÊÌ⣺һ¿ªÊ¼ÎÒÓÃNavicat Lite for mysql ½«Êý¾Ý¿âת´æ´¢Î»sqlÎļþ¡£´ò¿ªÖ®ºó·¢ÏÖ£¬ÖÐÎͼ±ä³ÉÁËÂÒÂë¡£
ËùÒÔ ÔÚÍøÉÏËÑË÷ÁËЩ×ÊÁÏ¿´¿´¡£·¢¾õ´ó¼Ò¶¼ÊÇÓÃÃüÁîµ¼³öµÄ¡£ÓÃÁËÖ®ºó£¬ÖÐÎľͲ»ÂÒÂëÁË¡£½â¾öÁËÎÒµÄÒ»¸öÄÑÌâ¡£ÌØ´Ë¼ÇÏ¡£
·½·¨:
Ê×ÏÈÈ·ÈÏ mysql·þÎñÊÇ¿ªÆôµÄ¡£
È»ºóµã“¿ªÊ¼”ÔËÐÐÊäÈëcmd£¬½øÈëDOS»·¾³¡£cd ......

MySQL µÄ×Ö¶ÎÀàÐÍÒÔ¼°½¨¿â²ßÂÔ


Ò»¡¢Êý×ÖÀàÐÍ
ËùνµÄ“Êý×ÖÀà”£¬¾ÍÊÇÖ¸ DECIMAL ºÍ
NUMERIC£¬ËüÃÇÊÇͬһÖÖÀàÐÍ¡£ËüÑϸñµÄ˵²»ÊÇÒ»ÖÖÊý×ÖÀàÐÍ£¬ÒòΪËûÃÇʵ¼ÊÉÏÊǽ«Êý×ÖÒÔ×Ö·û´®ÐÎʽ±£´æµÄ£»ËûµÄÖµµÄÿһ루°üÀ¨Ð¡Êýµã£©Õ¼Ò»¸ö×ֽڵĴ洢¿Õ¼ä£¬Òò´ËÕâÖÖÀàÐͺķѿռä±È½Ï´ó¡£µ«ÊÇËüµÄÒ»¸öÍ»³öµÄÓŵãÊÇСÊýµÄλÊý¹Ì¶¨£¬ÔÚÔËËãÖв»»á“ʧ ......

ÆäËûÊý¾Ý¿âÄ£ÄâʵÏÖmysqlµÄlimitÓï·¨

¼ÙÈçÎÒÓиöuser±í,ÎÒÏë²éѯ·ûºÏijЩÌõ¼þµÄµÚ50¸öÓû§¿ªÊ¼µÄ10¸öÓû§,ÇÒ²»ÄÜʹÓÃidºÅbetween andÄÇÑù²éѯ,Ó¦¸ÃÔõôдSQLÓï¾ä?
¡¡¡¡ÔÚmysqlÊý¾Ý¿âÖÐÓÐlimit,offsetÓï¾ä¿ÉÒÔ·½±ãµÄʵÏÖ,ÄÇôÔÚSQL serverÖÐÄØ?SQL ServerÊÇ·ñÖ§³ÖlimitºÍoffsetÓï¾äÄØ?
select top 10 * from
(select top 60 * from [user] order by userid) a ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ