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×÷ΪҵÎñÓ¦ÓõÄÊý¾Ý¿â£¬ÓÉÓÚ¾Ñé²»¹»·á¸»£¬ÔÚ°²×°Êý¾Ý¿âµÄʱºòÑ¡ÔñÁËGB2312±àÂë¡£
ÆðÏÈÓõÄÒ²ËãµÃÐÄÓ¦ÊÖ£¬È»¶øºóÐø·¢ÏÖÁËÉúƧ×Ö²»ÄÜÏÔʾµÄÇé¿ö£¬°ÑÎÒ¸ãµÃ½¹Í·Àö¾¹ýºÃ¼¸ÌìµÄÃþË÷¡¢
ѧϰ£¬ÖÕÓÚ°ÑÎÊÌâ½â¾öÁË¡£¼ÇϽâ¾ö²½Ö裬Óë¸úÎÒÒ»ÑùµÄÐÂÊÖ·ÖÏí¡£
²½ÖèÒ»£º ·ÖÎö³öÏÖÂÒÂëµÄÔÒò
ÓÉÓÚGB2312×Ö·û¼¯Ö»ÊÕ ......
delimiter // ¸Ä±ä½ç¶¨·û Ϊ//
ÁгöËùÓÐÊý¾Ý¿â show databases;
ÁгöËùÓÐÊý¾Ý±í show tables;
¸Ä±äÁ¬½ÓÊý¾Ý¿â use databaes
²åÈë¼Ç¼ insert into users(UserName,Password) values('ivwshjj','123456');
ɾ³ý¼Ç¼ delete from users  ......
mssql,oracleÖÐ
test񡜧
1 5 abc
2 6 bcd
1 7 ade
2 8 adc
select a,b,c
from(
select a,b,c
,row_number()over(partition by a order by b desc) rn
from test
) &nb ......
LUA°æ±¾£ºlua-5.1.4.tar.gz
MySql_proxy°æ±¾£ºmysql-proxy-0.6.1-linux-rhel4-x86-32bit.tar.gz
´úÀí»ú£ºLinuxºìñ £¨222.31.76.229£©
Êý¾Ý¿â·þÎñÆ÷£ºAÖ÷£º£¨222.31.76.99£©£¬B´Ó£º£¨222.31.76.102£©
AºÍB°²×°Mysql
5.1 £»
´úÀí»ú°²×°LUA£¬MYSQL_PROXY£»
1¡¢ LUAµÄ°²×°
[root@localh ......
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Êý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖ ......