阅读:154
评论:0
[client] port = 3306 #端口号 socket = /tmp/mysql.sock #socket所在路径 [mysqld] !include /home/mysql/etc/mysqld.cnf #包含的配置文件 ,把用户名,密码文件单独存放 port = 3306 socket = /tmp/mysql.sock pid-file = /home/mysql/var/mysql.pid#进程pid basedir = /home/mysql/#mysql的安装路径 datadir = /home/mysql/var/ #数据文件所在路径 tmpdir = /home/mysql/tmp/#临时文件保存路径 slave-...
阅读:216
评论:0
阅读:162
评论:0
/*MSSql的操作类*/ class MSSql { var $link; var $querynum = 0; /*连接MSSql数据库,参数:dbsn->数据库服务器地址,dbun->登陆用户名,dbpw->登陆密码,dbname->数据库名字*/ function Connect($dbsn, $dbun, $dbpw, $dbname) { if($this->link = @mssql_connect($dbsn, $dbun, $dbpw, true)) { $query = $this->Query('SET TEXTSIZE 2147483647'); if (@mssql_select_db($dbname, $this->link)...
阅读:249
评论:0
/* Powered By CMSDream Copyright (c) All rights reserved. 通用分页存储过程 */ CREATE proc [dbo].[cmsdream_SP_MultiPage]( @sql varchar(8000)='', @PageSize int=1, @CurrentPage int=1, @RecordCount int=0 output, @PageCount int=1 output )AS if @PageSize < 1 set @PageSize = 1 if @CurrentPage < 1 set @CurrentPage = 1 begin set nocount on declare @p1 int, @rowcount int exec...
阅读:317
评论:0