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

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
<=       


Ïà¹ØÎĵµ£º

PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö

PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö
ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕ߶¼Í³Ò»²ÅÐУ ......

pbÁ¬½ÓmySqlÊý¾Ý¿â

PBÁ¬½ÓMySQLÊý¾Ý¿â
 
È¥mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØodbc connector(http://dev.mysql.com/downloads/connector/odbc/)
ÏÂÔصÄÊÇmysql-connector-odbc-noinstall-5.1.6-win32.zip
½âѹºóÖ±½ÓÔËÐÐÎļþ¼ÐÖÐµÄ Install.bat Åú´¦ÀíÎļþ
mysql-connectorÓкü¸ÖÖ£¬Ñ¡ÔñÒ»¸ö×Ô¼ºÏ²»¶µÄ¼´¿É¡£
ÔÚxpÖдò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖ ......

mysql gui tools ʹÓÃ

¸Õ¿ªÊ¼²Ù×÷Êý¾Ý¿âʱÎÒÒ»°ãÊDz»Ê¹ÓÃʲôgui¹¤¾ßµÄ£¬ÎÒÊÇÖ±½ÓʹÓÃcmdϲÙ×÷µÄ£¬¸Ð¾õÓÃÆðÀ´Ò²Í¦²»´íµÄ¡£
×î½ü¿´µ½ÓÐgui¹¤¾ßÄÇÒ²²»´í°¡£¬¾ÍÏÂÀ´Ê¹ÓÃһϣ¬ÎÒϲ»¶ÏµÄÊÇѹËõ°üÃâ°²×°µÄ£¬ÕâÑù¸Ð¾õ±È½ÏÊæ·þ°¡
´ò¿ª²éѯ¹¤¾ßÊǾ¹È»³ö´íÁË£¬²»¹ýÄÜÕý³£Ê¹Óõģ¬µ±Ê±Ò²Ã»ÓÐ×¢Ò⣬½ñÌìÌØÒâµÄ¿´ÁËÒ»ÏÂ
Ó¦¸ÃÊÇmysqlqb_functions.xml¼ÓÔØ ......

MySQL³£Óú¯Êý

Ò»¡¢Êýѧº¯Êý
ABS(x)                    ·µ»ØxµÄ¾ø¶ÔÖµ
BIN(x)¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡·µ»ØxµÄ¶þ½øÖÆ£¨OCT·µ»Ø°Ë½øÖÆ£¬HEX·µ»ØÊ®Áù½øÖÆ£©
CEILING(x)            ......

MySQL±íÀàÐͼòµ¥¶Ô±È

MySQLΪÎÒÃÇÌṩÁ˺ܶà±íÀàÐ͹©Ñ¡Ôñ£¬ÓÐMyISAM¡¢ISAM¡¢HEAP¡¢BerkeleyDB¡¢InnoDB£¬MERGE±íÀàÐÍÿһÖÖ±íÀàÐͶ¼ÓÐÆä×Ô¼ºµÄÊôÐÔºÍÓŵ㡣ÏÂÃæÎÒÃÇÀ´¼òµ¥µÄÌÖÂÛһϡ£
MyISAM±íÀàÐÍ£º
MyISAM
±í(TYPE=MYISAM)ÊÇISAMÀàÐ͵ÄÒ»ÖÖÑÓÉ죬¾ßÓкܶàÓÅ»¯ºÍÔöÇ¿µÄÌØÐÔ¡£ÊÇMySQLµÄĬÈϱíÀàÐÍ¡£MyISAMÓÅ»¯ÁËѹËõ±ÈÀýºÍËٶȣ¬²¢ÇÒ
¿ÉÒ& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ