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

MySql ´æ´¢¹ý³Ì

MySQL ´æ´¢¹ý³ÌÊÇ´Ó MySQL 5.0 ¿ªÊ¼Ôö¼ÓµÄй¦ÄÜ¡£´æ´¢¹ý³ÌµÄÓŵãÓÐÒ»Âá¿ð¡£²»¹ý×îÖ÷ÒªµÄ»¹ÊÇÖ´ÐÐЧÂʺÍSQL ´úÂë·â×°¡£ÌرðÊÇ SQL ´úÂë·â×°¹¦ÄÜ£¬Èç¹ûûÓд洢¹ý³Ì£¬ÔÚÍⲿ³ÌÐò·ÃÎÊÊý¾Ý¿âʱ£¨ÀýÈç PHP£©£¬Òª×éÖ¯ºÜ¶à SQL Óï¾ä¡£ÌرðÊÇÒµÎñÂß¼­¸´ÔÓµÄʱºò£¬Ò»´ó¶ÑµÄ SQL ºÍÌõ¼þ¼ÐÔÓÔÚ PHP ´úÂëÖУ¬ÈÃÈ˲»º®¶øÀõ¡£ÏÖÔÚÓÐÁË MySQL ´æ´¢¹ý³Ì£¬ÒµÎñÂß¼­¿ÉÒÔ·â×°´æ´¢¹ý³ÌÖУ¬ÕâÑù²»½öÈÝÒ×ά»¤£¬¶øÇÒÖ´ÐÐЧÂÊÒ²¸ß¡£
Ò»¡¢MySQL ´´½¨´æ´¢¹ý³Ì
“pr_add” ÊǸö¼òµ¥µÄ MySQL ´æ´¢¹ý³Ì£¬Õâ¸ö´æ´¢¹ý³ÌÓÐÁ½¸ö int ÀàÐ͵ÄÊäÈë²ÎÊý “a”¡¢“b”£¬·µ»ØÕâÁ½¸ö²ÎÊýµÄºÍ¡£
drop procedure if exists pr_add;
-- ¼ÆËãÁ½¸öÊýÖ®ºÍ
create procedure pr_add
(
   a int,
   b int
)
begin
   declare c int;
   if a is null then
      set a = 0;
   end if;
   if b is null then
      set b = 0;
   end if;
   set c = a + b;
   select c as sum;
   /*
   return c;- ²»ÄÜÔÚ MySQL ´æ´¢¹ý³ÌÖÐʹÓá£return Ö»ÄܳöÏÖÔÚº¯ÊýÖС£
  /
end;
¶þ¡¢µ÷Óà MySQL ´æ´¢¹ý³Ì
call pr_add(10, 20);
Ö´ÐÐ MySQL ´æ´¢¹ý³Ì£¬´æ´¢¹ý³Ì²ÎÊýΪ MySQL Óû§±äÁ¿¡£
set @a = 10;
set @b = 20;
call pr_add(@a, @b);
Èý¡¢MySQL ´æ´¢¹ý³ÌÌØµã
´´½¨ MySQL ´æ´¢¹ý³ÌµÄ¼òµ¥Ó﷨Ϊ£º
create procedure ´æ´¢¹ý³ÌÃû×Ö()
(
   [in|out|inout] ²ÎÊý datatype
)
begin
   MySQL Óï¾ä;
end;
MySQL ´æ´¢¹ý³Ì²ÎÊýÈç¹û²»ÏÔʽָ¶¨“in”¡¢“out”¡¢“inout”£¬ÔòĬÈÏΪ“in”¡£Ï°¹ßÉÏ£¬¶ÔÓÚÊÇ“in” µÄ²ÎÊý£¬ÎÒÃǶ¼²»»áÏÔʽָ¶¨¡£
1. MySQL ´æ´¢¹ý³ÌÃû×ÖºóÃæµÄ“()”ÊDZØÐëµÄ£¬¼´Ê¹Ã»ÓÐÒ»¸ö²ÎÊý£¬Ò²ÐèÒª“()”
2. MySQL ´æ´¢¹ý³Ì²ÎÊý£¬²»ÄÜÔÚ²ÎÊýÃû³ÆÇ°¼Ó“@”£¬È磺“@a int”¡£ÏÂÃæµÄ´´½¨´æ´¢¹ý³ÌÓï·¨ÔÚ MySQL ÖÐÊÇ´íÎóµÄ£¨ÔÚ SQL Server ÖÐÊÇÕýÈ·µÄ£©¡£ MySQL ´æ´¢¹ý³ÌÖеıäÁ¿£¬²»ÐèÒªÔÚ±äÁ¿Ãû×Öǰ¼Ó“@”£¬ËäÈ» MySQL ¿Í»§¶ËÓû§±äÁ¿Òª¼Ó¸ö“@”¡£
create procedure pr_add
(
   @a int,


Ïà¹ØÎĵµ£º

MySQL Storage Engine

http://www.javaeye.com/topic/211951
Õâ¶Îʱ¼äÔÚ¿´¡¶High Performance MySQL¡·£¬¿´µ½´æ´¢ÒýÇæÕâ¸öµØ·½¸Ðµ½ºÜ¶àϸ½Ú±È½ÏİÉú£¬ËùÒÔ×ܽáС¼ÇһЩ
ΪÁËÊÊÓ¦¸÷ÖÖ²»Í¬µÄÔËÐл·¾³£¬MYSQLÌṩÁ˶àÖÖ²»Í¬µÄ´æ´¢ÒýÇæ£¨Storage Engine £©,ÔÚÓ¦ÓóÌÐò¿ª·¢Õâ¸ö²ãÃæÉÏ£¬¿ª·¢Õß¿ÉÒÔ¸ù¾Ý²»Í¬µÄÐèÇóÑ¡ÔñÊʺϵÄStorage Engine ·½°¸£¬¸üΪÁ ......

¹ØÓÚmysql plugin ×Ô¶¨Òåϵͳ±äÁ¿

1. ¶¨Òå
/*
  Plugin system variables.
*/
static long     sysvar_one_value;
static char     *sysvar_two_value;
static MYSQL_SYSVAR_LONG(simple_sysvar_one, sysvar_one_value,
  PLUGIN_VAR_RQCMDARG,
  "Simple fulltext parser example system variab ......

mysql±íµÄ¸´ÖÆ

1.¸´ÖƱí½á¹¹¼°Êý¾Ýµ½Ð±í
CREATE TABLE бí SELECT * from ¾É±í
2.Ö»¸´ÖƱí½á¹¹µ½Ð±í
CREATE TABLE бí SELECT * from ¾É±í WHERE 1=2
»òCREATE TABLE ÐÂ±í  LIKE ¾É±í
3.¸´ÖƾɱíµÄÊý¾Ýµ½Ð±í(¼ÙÉèÁ½¸ö±í½á¹¹Ò»Ñù)
INSERT INTO бí SELECT * from ¾É±í
4.¸´ÖƾɱíµÄÊý¾Ýµ½Ð±í(¼ÙÉèÁ½¸ö±í½á¹¹²»Ò»Ñù)
IN ......

MySQL¿É¿¿ÐÔ·½°¸·ÖÎöÓë±È½Ï

ÒýÓÃhttp://bbs.yahunet.com/thread-9946-1-1.html
´Ó»ù±¾Çé¿ö¡¢³É±¾¡¢ÓÅȱµãºÍÓ¦Óó¡ºÏµÈ·½Ãæ¶Ô5ÖÖMySQLµÄ¿É¿¿ÐÔ·½°¸
½øÐÐÁË·ÖÎö
ºÍ±È½Ï£¬¶ÔMySQLµÄ¿ª·¢ºÍ¹ÜÀí
ÓÐÒ»¶¨µÄ½è¼ø×÷Óá£
1£®MySQL Clustering(ndb-cluster stogare)
¼ò½é£º
MySQL¹«Ë¾ÒÔ´æ´¢ÒýÇæ·½Ê½ÌṩµÄ¸ß¿É¿¿ÐÔ·½°¸£¬ÊÇÊÂÎñ°²È«µÄ£¬ÊµÊ±¸´ÖÆÊý¾Ý
£¬¿ÉÓ ......

mysql»ù±¾ÃüÁî

 Æô¶¯£ºnet start mySql;
  ½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
  ÁгöÊý¾Ý¿â£ºshow databases;
  Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
  Áгö±í¸ñ£ºshow tables£»
  ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
  ½¨Á¢Êý¾Ý¿â£ºsource fileNam ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ