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

sqlserverºÍmysqlµÄÐÐתÁÐͨÓô洢¹ý³Ì

sqlserverÖУº
  1 /*
  2 1 * Description:¶ÔÊý¾Ý±í½øÐÐÐÐÁÐת»»
  3 2 * Author:llf
  4 3 * µ÷ÓÃ˵Ã÷£ºexec SP_RowChangeCol 'ѧÉú³É¼¨±í','ÐÕÃû','¿Î³Ì','·ÖÊý','desc',0,0,'where Äê¼¶=''Ò»Äê¼¶'''
  5 4 * ¸Ã´æ´¢¹ý³Ìµ÷ÓõÄÏà¹Øº¯Êý£ºdbo.Get_StrArrayLength(@groupCol,',')£»dbo.dbo.Get_StrArrayStrOfIndex(@groupCol,',',1)
  6 */
  7  
  8 Alter proc SP_RowChangeCol
  9  @tableName varchar(100),    --Ҫת»»µÄÊý¾Ý±íÃû(ѧÉú³É¼¨±í)
 10  @groupCol varchar(100),     --·Ö×éÁÐ(ѧÉúÐÕÃû)
 11  @changeCol varchar(100),    --Ҫת»»µÄÁÐ(¿¼ÊÔ¿ÆÄ¿)
 12  @countCol varchar(100),     --ͳ¼ÆÁÐ(³É¼¨)
 13  @orderby varchar(4),        --ת»»ÁеÄÅÅÐò¹æÔò(ÉýÐòasc,½µÐòdesc)
 14  @isColSum int,              --ÊÇ·ñͳ¼ÆÁУ¨1ÊÇ£»0·ñ£©
 15  @isRowSum int,              --ÊÇ·ñͳ¼ÆÐУ¨1ÊÇ£»0·ñ£©
 16  @strWhere varchar(max)         --²éѯÌõ¼þ('where Äê¼¶=''Ò»Äê¼¶''')
 17  as
 18  begin
 19      declare @sqlhead varchar(8000),@sqlend varchar(8000)
 20       ,@sql1 varchar(8000),@sql2 varchar(8000),@sql3 varchar(8000),@sql4 varchar(8000)
 21       ,@i int,@ic varchar(20),@sql varchar(1000)
 22 
 23 
 24  


Ïà¹ØÎĵµ£º

mysql °²×°

½ñÌì°²×°mysqlÓöµ½ºÜ¶àÂé·³£¬ÏëÏóÔ­Òò£¬×Ô¼º»¹ÊÇlinuxµÄ³õѧÕߣ¬Í¬Ê±ÊÜ´ìʱ×ÜÊÇÒª°ÑÎÊÌâµÄ¸´ÔÓϵÊý·Å´ó¡£
1 °²×°³åÍ»
¸ù¾Ý¡¶linux³ÌÐòÉè¼Æ¡·ÉϵÄÖ¸µ¼£¬´Ó¹ÙÍøÏÂÔØÁËmysql-server-xx£¬mysql-devel-xx£¬mysql-client-xx£¬mysql-share-xx£¬È»ºóÖ´ÐÐ
rpm -i *.rpm
½á¹û¶þÊ®¼¸ÐÐconflictÌáʾ£¬ËµÓÐÎļþÓëmysql-server-xxµÄ°² ......

mysqlËæ»úÊý¾ÝÉú³É²¢²åÈë

      dblpÊý¾Ý¿âÖÐÒýÓÃÐÅÏ¢ºÜÉÙ£¬Æ½¾ùһƪÂÛÎÄÒýÓÃ0.2ƪ¡£Ê¹ÓÃdblp×öʵÑéÊý¾Ý¼¯µÄijƪÂÛÎÄÌáµ½£¬¿ÉÒÔËæ»úÌí¼ÓÒýÓÃÐÅÏ¢¡£ÊÜ´ËÆô·¢£¬ÎÒ´òËãΪÿһƪÂÛÎͼÌí¼Ó20ÆªËæ»úÒýÓã¬ÓÚÊǾÍд³öÁËÈçϵÄsqlÓï¾ä£º
     String sql = "insert into citation(pId1,pId2) values( (selec ......

windows7ϰ²×°apache+php+mysqlÎÊÌâ¼Ç¼

×î½üÐÂÂòÁ˸öµçÄÔ£¬ÏµÍ³ÊÇwindows7£¬window7ÔÚ½çÃæ£¬¹¦ÄÜ·½Ã涼ͦÈÃÈËÂúÒâµÄ£¬¸Ð¾õºÜˬ£¬²»Ë¬µÄÊÇÓÖÒªÖØÐ°²×°»·¾³ÁË¡£
ËùÓÐÈí¼þ¾ù°²×°ÔÚF:\server\ÏÂ
apacheĿ¼£ºF:\server\apache2.2
phpĿ¼£ºF:\server\php
msyqlĿ¼£ºF:\server\mysql
Ò»¡¢°²×°apache
°²×°apacheµÄ°æ±¾ÊÇ£ºhttpd-2.2.15-win32-x86-no_ssl.msi
° ......

MySQLÉúƧ×ÖÎÞ·¨ÏÔʾ½â¾ö·½·¨

µÚÒ»´Î²ÉÓÃMySQL×÷ΪҵÎñÓ¦ÓõÄÊý¾Ý¿â£¬ÓÉÓÚ¾­Ñé²»¹»·á¸»£¬ÔÚ°²×°Êý¾Ý¿âµÄʱºòÑ¡ÔñÁËGB2312±àÂë¡£
ÆðÏÈÓõÄÒ²ËãµÃÐÄÓ¦ÊÖ£¬È»¶øºóÐø·¢ÏÖÁËÉúƧ×Ö²»ÄÜÏÔʾµÄÇé¿ö£¬°ÑÎÒ¸ãµÃ½¹Í·Àö¾­¹ýºÃ¼¸ÌìµÄÃþË÷¡¢
ѧϰ£¬ÖÕÓÚ°ÑÎÊÌâ½â¾öÁË¡£¼ÇϽâ¾ö²½Ö裬Óë¸úÎÒÒ»ÑùµÄÐÂÊÖ·ÖÏí¡£
²½ÖèÒ»£º ·ÖÎö³öÏÖÂÒÂëµÄÔ­Òò
ÓÉÓÚGB2312×Ö·û¼¯Ö»ÊÕ ......

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

PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö
ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕß¶¼Í³Ò»²ÅÐУ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ