<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[to_date的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/to_date</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; to_date]]></copyright><item><title><![CDATA[Excel 重复格式检验高亮为空不展示，15位不生效问题，手机号格式]]></title><link>https://blog.youkuaiyun.com/to_date/article/details/125810105</link><guid>https://blog.youkuaiyun.com/to_date/article/details/125810105</guid><author>to_date</author><pubDate>Fri, 15 Jul 2022 18:15:42 +0800</pubDate><description><![CDATA[Excel 重复格式检验高亮为空不展示，15位不生效问题]]></description><category></category></item><item><title><![CDATA[oracle/mysql 一次增加或删除多个字段sql]]></title><link>https://blog.youkuaiyun.com/to_date/article/details/119819974</link><guid>https://blog.youkuaiyun.com/to_date/article/details/119819974</guid><author>to_date</author><pubDate>Fri, 20 Aug 2021 12:02:27 +0800</pubDate><description><![CDATA[-- 由于当时表数据多，加字段时间长所以有单个增加字段合并成一次增加字段-- oracle
-- 一次增加多个字段
ALTER TABLE TABLE_NAME ADD (
COLUMN_NAME1 NUMBER(20,2) DEFAULT 0,
COLUMN_NAME2 VARCHAR2(20));
-- 删除多个字段
ALTER TABLE TABLE_NAME DROP (COLUMN_NAME1, COLUMN_NAME2);

-- mysql
-- 一次增加多个字段
ALTER TABLE ..]]></description><category></category></item></channel></rss>