<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[micleng的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/micleng</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; micleng]]></copyright><item><title><![CDATA[Linux安装 Oracle 19C 实操]]></title><link>https://blog.youkuaiyun.com/micleng/article/details/126408726</link><guid>https://blog.youkuaiyun.com/micleng/article/details/126408726</guid><author>micleng</author><pubDate>Thu, 18 Aug 2022 16:36:21 +0800</pubDate><description><![CDATA[Linux安装 Oracle 19C 实操]]></description><category></category></item><item><title><![CDATA[数据库3NF人话版]]></title><link>https://blog.youkuaiyun.com/micleng/article/details/109121208</link><guid>https://blog.youkuaiyun.com/micleng/article/details/109121208</guid><author>micleng</author><pubDate>Fri, 16 Oct 2020 17:40:47 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[My SQL 常用语法模板]]></title><link>https://blog.youkuaiyun.com/micleng/article/details/81489999</link><guid>https://blog.youkuaiyun.com/micleng/article/details/81489999</guid><author>micleng</author><pubDate>Tue, 07 Aug 2018 22:42:16 +0800</pubDate><description><![CDATA[ 

 


1.修改表名 
create procedure product()

2.修改表注释   
alter table sys_application comment '系统信息表';

1.修改字段类型和注释
alter table sys_application  modify column app_name varchar(20) COMMENT '应用的名称';

2.修改字段...]]></description><category></category></item><item><title><![CDATA[SQL常用查询模板（个人在公司最常用的）]]></title><link>https://blog.youkuaiyun.com/micleng/article/details/79112035</link><guid>https://blog.youkuaiyun.com/micleng/article/details/79112035</guid><author>micleng</author><pubDate>Sat, 20 Jan 2018 08:41:14 +0800</pubDate><description><![CDATA[sql server t-sql高级查询

新增字段：
alter table [表名] add [字段名] nvarchar (50) null
alter table [表名]
      alter column [字段名]     varchar(100)  not null

--删除字段：
alter table [表名] drop column [字段名]

--修改字段：
alte...]]></description><category></category></item></channel></rss>