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

mysql ¸Ä¸öº¯Êý - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

create table treeNodes
  (
  id int primary key,
  nodename varchar(20),
  pid int
  );

CREATE FUNCTION `getChildLst`(rootId INT)
  RETURNS varchar(1000)
  BEGIN
  DECLARE sTemp VARCHAR(1000);
  DECLARE sTempChd VARCHAR(1000);
   
  SET sTemp = '$';
  SET sTempChd =cast(rootId as CHAR);
   
  WHILE sTempChd is not null DO
  SET sTemp = concat(sTemp,',',sTempChd);
  SELECT group_concat(id) INTO sTempChd from treeNodes where FIND_IN_SET(pid,sTempChd)>0;
  END WHILE;
  RETURN sTemp;
  END


Õâ¸öÊDzé³öËùÓÐ×Ó½Úµãid $,1,2,3,4,5,6,7
  ÎÒÏëÒª²é³öËùÓи¸±²½Úµãid £¬Éî¶ÈΪ10 (¾ÍÊÇÖ»²é10¸ö¸¸±²½Úµã)£¬Èç¹û³¬¹ý10¸öºóÃæµÄ¾Í²»²é²»À´
  ɾ³ý½á¹û '1','2','3','4'
 

  ½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£
  ²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓµÄÌáÎÊ·½Ê½http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html
   
  1. ÄãµÄ create table xxx .. Óï¾ä
  2. ÄãµÄ insert into xxx ... Óï¾ä
  3. ½á¹ûÊÇʲôÑù£¬£¨²¢¸øÒÔ¼òµ¥µÄËã·¨ÃèÊö£©
  4. ÄãÓõÄÊý¾Ý¿âÃû³ÆºÍ°æ±¾(¾­³£ÓÐÈËÔÚMS SQL server°æÎÊ MySQL)
  &nbs


Ïà¹ØÎÊ´ð£º

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......

mysqlµ¼³öÖ¸¶¨×ֶεÄÊý¾Ý - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌìÏëµ½¸öÎÊÌ⣬mysql¿ÉÒÔµ¼³ö±í£¬Êý¾Ý¿â£¬Ôõôµ¼³öij¸ö×ֶεÄÊý¾ÝÄØ£¿²»ÖªµÀ´ó¼ÒÓÐûÓÐÕâôÊÔ¹ýµÄ£¿ÊDz»Êǵ¼³öÊý¾ÝµÄ×îСµ¥Î»¾ÍÊÇ±í£¿
Óù¤¾ß¿ÉÒÔÑ¡ÔñÁе쬱ÈÈçsqlyog

лл£¬ÒѾ­½â¾ö£¬ÎÒÓõÄÊÇÃüÁºÇºÇ
......

MySQLÊý¾Ý¿â´æ·ÅÔÚÄİ¡£¿ - MS-SQL Server / »ù´¡Àà

ÔõôÕÒµ½Êý¾Ý¿âµÄλÖ𡣿Çë¸÷λǰ±²Ö¸½Ìһϣ¿Ð¡µÄ·Ç³£¸Ðл£¡
ÏÈÕÒµ½my.cnfÎļþ£¬´ò¿ªºó¿´[data]ϵÄdatadir


2¡¢½øÈëmysqlÖÕ¶Ë£º
mysql>show variables like '%datadir%';

ÔÙ²»ÐÐÈ«ÅÌËÑË÷£º¡¡frmÎļþ ......

mysqlÔËÓÃÎÊÌâ - PHP / »ù´¡±à³Ì

phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë
ÀýÈ磺
SELECT time, goodid from dbname1.time, dbname2.goods
ÊÇÕâ¸öÒâ˼ô£¿

SELECT time, goodid from ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ