MySql
cg_program
AutoBots Transform,Roll out!
展开
-
绿色版MySQL 的配置办法
转:http://www.cnblogs.com/zeroone/archive/2010/03/31/1701062.html本人下载的MySQL是5.1版的下载地址:http://dev.mysql.com/downloads/mysql/下载 免安装包(mysql-noinstall-5.1.45-win32.zip)解压该压缩文件到E:\mysql-5.转载 2013-03-19 17:18:55 · 2601 阅读 · 0 评论 -
SQL 语句中按照in语句原有的顺序进行排序
Access: select * From 表 Where id in(1,5,3) order by instr(',1,5,3,',','&;id&;',')MSSQL: select * From 表 Where id in(1,5,3) order by charindex(','+rtrim(cast(id as varchar(10)))+',',',1,5,3转载 2013-07-19 00:03:33 · 3177 阅读 · 0 评论