weixin_43726316的博客

1.MySQL默认的监听端口是多少？如何修改？默认端口3306.（1）修改配置文件Vi /etc/my.cnfPort=’3307’（2）重启MySQL/etc/init.d/mysql.server restart2.如果企业由于扩容问题需要将数据文件夹data移动到另外的磁盘，该怎么做？假设将数据data转移到/home/data目录下（1）停掉MySQL的服务（2）拷贝d...

表ID Birth1 1900/2/122 1898/2/3语句select SUBSTRING(Birth,1,CHARINDEX('/',Birth)-1),SUBSTRING(Birth,CHARINDEX('/',Birth)+1,CHARINDEX('/',Birth,CHARINDEX('/',Birth)+1)-(CHARINDEX('/',Birth)+1)),SU...

create FUNCTION [dbo].[f_splitlianxi](@str NVARCHAR(500),--要分割的字符串@fengefu NVARCHAR(20)--进行分割的符号)RETURNS @table TABLE(id INT,val NVARCHAR(50))ASBEGIN DECLARE @index INT,@startsplit INT,@id ...

CentOS安装MySQL–常规安装1.建立用户组groupadd mysqluseradd mysql -g mysqlchown mysql:mysql data2.初始化安装yum install -y libaiobin/mysqld --initialize --user=mysql --datadir /usr/local/mysql/data3.CP文件cp m...

SQL多行分录合并一行select t1.finterid ,min(t1.fentryid) fentryid, fname =(stuff( (select ' '+fname from (select t.FinterID finterid, fname=(stuff( (select ' '+fname from t_SubMessage where FinterI...

Linux重启之后，startup命令后显示SQL> startupLRM-00109: could not openparameterfile '/opt/oracle10g/product/10.2/db_1/dbs/initVDEDU.ora'查找文件，果然不存在。估计是非法关机造成的。这是因为在oracle9i和oracle10g中，oracle默认将使用spfile启动数...

CREATE TABLE Employee( UserID INT, ManagerID INT, Name NVARCHAR(10)) INSERT INTO dbo.Employee SELECT 1,-1,N'Boss' UNION ALL SELECT 11,1,N'A1' UNION ALL SELECT 12,1,N'A2' UNION ALL SELECT 13,1,N'A3' UNION ALL SELECT 111,11,N'B1

目录1、创建2、给表添加注释3、字段添加注释4、自增列自增列使用5、游标，存储过程返回结果集6、存储过程返回结果集1、创建create table T_YH_HUIPANFILEENTRY(FID INTEGER,FENTRYID INTEGER,FFILENAME VARCHAR(50),FSHOUDANWEINO VARCHAR(50),FSHOUDANWEINAME VARCHAR(200),FORDERNO VARCHAR(50),FZHIFUFS varchar(50),FJI