Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

mysql×Ö¶ÎÌáÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......

mysqlÇøÃ»¸ßÊÖ - MS-SQL Server / »ù´¡Àà

ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......

MysqlÎÊÌâ - MS-SQL Server / ·Ç¼¼Êõ°æ

ÎÒÒѾ­°²×°mysqlÁË£¬ÉèÖõĿª»ú²»Æô¶¯£¬µ«ÔÚÎҵĵçÄÔ'->'¹ÜÀí'->'·þÎñºÍÓ¦ÓóÌÐò'->·þÎñÖÐÕÒ²»µ½mysql£¬ÕâÑù¾Íû·¨Æô¶¯ÁË£¬ÎÒÏëѯÎÊÒ»ÏÂÕâµ½µ×ÊÇÔõô»ØÊ£¬ÏÈллÁË
ÓÐºÃ¶àµØ·½ÄØ
×¢²á±í
Æô¶¯Îļþ¼ÐµÈ
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ