declare 
@i int,
@max int,
@SkillID smallint,
@SkillLevel tinyint,
@SkillName varchar,
@Country tinyint,
@Attackfighter tinyint,
@Defensefighter tinyint,
@Patrolrogue tinyint,
@Shootrogue tinyint,
@Attackmage tinyint,
@Defensemage tinyint,
@PrevSkillID smallint,
@ReqLevel smallint,
@Grow tinyint,
@SkillPoint tinyint,
@TypeShow tinyint,
@TypeAttack tinyint,
@TypeEffect tinyint,
@TypeDetail smallint,
@NeedWeapon1 tinyint,
@NeedWeapon2 tinyint,
@NeedWeapon3 tinyint,
@NeedWeapon4 tinyint,
@NeedWeapon5 tinyint,
@NeedWeapon6 tinyint,
@NeedWeapon7 tinyint,
@NeedWeapon8 tinyint,
@NeedWeapon9 tinyint,
@NeedWeapon10 tinyint,
@NeedWeapon11 tinyint,
@NeedWeapon12 tinyint,
@NeedWeapon13 tinyint,
@NeedWeapon14 tinyint,
@NeedWeapon15 tinyint,
@Shield tinyint,
@SP smallint,
@MP smallint,
@ReadyTime tinyint,
@ResetTime smallint,
@AttackRange tinyint,
@StateType tinyint,
@AttrType tinyint,
@Disable smallint,
@SuccessType tinyint,
@SuccessValue tinyint,
@TargetType tinyint,
@ApplyRange tinyint,
@MultiAttack tinyint,
@KeepTime smallint,
@Weapon1 tinyint,
@Weapon2 tinyint,
@Weaponvalue tinyint,
@Bag tinyint,
@Arrow smallint,
@DamageType tinyint,
@DamageHP smallint,
@DamageSP smallint,
@DamageMP smallint,
@TimeDamageType tinyint,
@TimeDamageHP smallint,
@TimeDamageSP smallint,
@TimeDamageMP smallint,
@AddDamageHP smallint,
@AddDamageSP smallint,
@AddDamageMP smallint,
@AbilityType1 tinyint,
@AbilityValue1 smallint,
@AbilityType2 tinyint,
@AbilityValue2 smallint,
@AbilityType3 tinyint,
@AbilityValue3 smallint,
@HealHP smallint,
@HealSP smallint,
@HealMP smallint,
@TimeHealHP smallint,
@TimeHealSP smallint,
@TimeHealMP smallint,
@DefenceType tinyint,
@DefenceValue tinyint,
@LimitHP tinyint,
@FixRange smallint,
@ChangeType smallint,
@ChangeLevel smallint,
@UpdateDate datetime
select
@SkillID=SkillID,@SkillName=SkillName,@Country=Country,@Attackfighter=Attackfighter,@Defensefighter=Defensefighter,@Patrolrogue=Patrolrogue,@Shootrogue=Shootrogue,@Attackmage=Attackmage,@Defensemage=Defensemage,@PrevSkillID=PrevSkillID,@ReqLevel=ReqLevel,@Grow=Grow,@SkillPoint=SkillPoint,@TypeShow=TypeShow,@TypeAttack=TypeAttack,@TypeEffect=TypeEffect,
@TypeDetail=TypeDetail,@NeedWeapon1=NeedWeapon1,@NeedWeapon2=NeedWeapon2,@NeedWeapon3=NeedWeapon3,@NeedWeapon4=NeedWeapon4,@NeedWeapon5=NeedWeapon5,@NeedWeapon6=NeedWeapon6,@NeedWeapon7=NeedWeapon7,@NeedWeapon8=NeedWeapon8,@NeedWeapon9=NeedWeapon9,@NeedWeapon10=NeedWeapon10,@NeedWeapon11=NeedWeapon11,@NeedWeapon12=NeedWeapon12,@NeedWeapon13=NeedWeapon13,@NeedWeapon14=NeedWeapon14,@NeedWeapon15=NeedWeapon15,
@Shield=Shield,@SP=SP,@MP=MP,@ReadyTime=ReadyTime,@ResetTime=ResetTime,@AttackRange=AttackRange,@StateType=StateType,@AttrType=AttrType,@Disable=Disable,@SuccessType=SuccessType,@SuccessValue=SuccessValue,@TargetType=TargetType,@ApplyRange=ApplyRange,@MultiAttack=MultiAttack,@KeepTime=KeepTime,@Weapon1=Weapon1,@Weapon2=Weapon2,@Weaponvalue=Weaponvalue,@Bag=Bag,@Arrow=Arrow,@DamageType=DamageType,@DamageHP=DamageHP,@DamageSP=DamageSP,@DamageMP=DamageMP,
@TimeDamageType=TimeDamageType,@TimeDamageHP=TimeDamageHP,@TimeDamageSP=TimeDamageSP,@TimeDamageMP=TimeDamageMP,@AddDamageHP=AddDamageHP,@AddDamageSP=AddDamageSP,@AddDamageMP=AddDamageMP,@AbilityType1=AbilityType1,@AbilityValue1=AbilityValue1,@AbilityType2=AbilityType2,@AbilityValue2=AbilityValue2,@AbilityType3=AbilityType3,@AbilityValue3=AbilityValue3,@HealHP=HealHP,@HealSP=HealSP,@HealMP=HealMP,@TimeHealHP=TimeHealHP,@TimeHealSP=TimeHealSP,@TimeHealMP=TimeHealMP,
@DefenceType=DefenceType,@DefenceValue=DefenceValue,@LimitHP=LimitHP,@FixRange=FixRange,@ChangeType=ChangeType,@ChangeLevel=ChangeLevel,@UpdateDate=UpdateDate
from skills where skilllevel=3
set @i=1
set @max=326
while @i<=@max
begin
insert into skills
values (@i,4,@SkillName,@Country,@Attackfighter,@Defensefighter,@Patrolrogue,@Shootrogue,@Attackmage,@Defensemage,@PrevSkillID,@ReqLevel,@Grow,@SkillPoint,@TypeShow,@TypeAttack,@TypeEffect,@TypeDetail,@NeedWeapon1,@NeedWeapon2,@NeedWeapon3,@NeedWeapon4,@NeedWeapon5,@NeedWeapon6,@NeedWeapon7,@NeedWeapon8,@NeedWeapon9,@NeedWeapon10,@NeedWeapon11,@NeedWeapon12,@NeedWeapon13,@NeedWeapon14,@NeedWeapon15,@Shield,@SP,@MP,@ReadyTime,@ResetTime,@AttackRange,@StateType,@AttrType,@Disable,@SuccessType,@SuccessValue,@TargetType,@ApplyRange,@MultiAttack,@KeepTime,@Weapon1,@Weapon2,@Weaponvalue,@Bag,@Arrow,@DamageType,@DamageHP,@DamageSP,@DamageMP,@TimeDamageType,@TimeDamageHP,@TimeDamageSP,@TimeDamageMP,@AddDamageHP,@AddDamageSP,@AddDamageMP,@AbilityType1,@AbilityValue1,@AbilityType2,@AbilityValue2,@AbilityType3,@AbilityValue3,@HealHP,@HealSP,@HealMP,@TimeHealHP,@TimeHealSP,@TimeHealMP,@DefenceType,@DefenceValue,@LimitHP,@FixRange,@ChangeType,@ChangeLevel,@UpdateDate)
set @i=@i+1
end
上面是执行语句
下面是修改技能等级
update skills
set reqlevel=90
where skillevel>3