<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qq_54046847的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_54046847</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_54046847]]></copyright><item><title><![CDATA[Linux安装配置MySQL]]></title><link>https://blog.youkuaiyun.com/qq_54046847/article/details/132534423</link><guid>https://blog.youkuaiyun.com/qq_54046847/article/details/132534423</guid><author>qq_54046847</author><pubDate>Mon, 28 Aug 2023 11:07:46 +0800</pubDate><description><![CDATA[命令：./mysqld --initialize --user=mysql --datadir=/opt/mysql-5.7.18/data --basedir=/opt/mysql-5.7.18。启动MySQL服务，mysql-5.7.18/bin目录下执行命令：./mysqld_safe &（其中&符号表示后台启动）,输入命令后按Enter。切换到mysql-5.7.18/bin目录下执行。登录进入mysql，mysql-5.7.18/bin目录下执行命令：./mysql -uroot -p。]]></description><category></category></item><item><title><![CDATA[用AOP和注解实现添加日志]]></title><link>https://blog.youkuaiyun.com/qq_54046847/article/details/131210658</link><guid>https://blog.youkuaiyun.com/qq_54046847/article/details/131210658</guid><author>qq_54046847</author><pubDate>Wed, 14 Jun 2023 16:37:38 +0800</pubDate><description><![CDATA[【代码】用AOP和注解实现添加日志。]]></description><category></category></item><item><title><![CDATA[Oracle数据库分页遇到的问题]]></title><link>https://blog.youkuaiyun.com/qq_54046847/article/details/131165058</link><guid>https://blog.youkuaiyun.com/qq_54046847/article/details/131165058</guid><author>qq_54046847</author><pubDate>Mon, 12 Jun 2023 11:34:23 +0800</pubDate><description><![CDATA[SQL语句执行顺序：FROM、ON 、JOIN、WHERE、GROUP BY、AGG_FUNC、WITH、HAVING、SELECT、UNION、DISTINCT 、ORDER BY、LIMIT。多条件分页查询时，要将条件先查，在进行分页（分页最后进行）。2、where子句基于指定的条件对记录行进行筛选；3、group by子句将数据划分为多个分组；1、from子句组装来自不同数据源的数据；7、使用order by对结果集进行排序。5、使用having子句筛选分组；4、使用聚集函数进行计算；]]></description><category></category></item><item><title><![CDATA[SprigBoot Oracle和MySQL的配置文件和驱动依赖]]></title><link>https://blog.youkuaiyun.com/qq_54046847/article/details/131123966</link><guid>https://blog.youkuaiyun.com/qq_54046847/article/details/131123966</guid><author>qq_54046847</author><pubDate>Fri, 09 Jun 2023 11:50:31 +0800</pubDate><description><![CDATA[SprigBoot Oracle和MySQL的配置文件和驱动依赖]]></description><category></category></item><item><title><![CDATA[Java获取IP和Mac地址]]></title><link>https://blog.youkuaiyun.com/qq_54046847/article/details/131122651</link><guid>https://blog.youkuaiyun.com/qq_54046847/article/details/131122651</guid><author>qq_54046847</author><pubDate>Fri, 09 Jun 2023 10:43:36 +0800</pubDate><description><![CDATA[【代码】Java获取IP和Mac地址。]]></description><category></category></item><item><title><![CDATA[Oracle数据库的几个注意事项和主键自增设置]]></title><link>https://blog.youkuaiyun.com/qq_54046847/article/details/131121295</link><guid>https://blog.youkuaiyun.com/qq_54046847/article/details/131121295</guid><author>qq_54046847</author><pubDate>Fri, 09 Jun 2023 10:13:15 +0800</pubDate><description><![CDATA[2.Oracle数据库不支持limit关键字，但是Oracle有ROWNUM可以用来分页；保存后回到触发器界面，选中刚创建的触发器，反键在维护中选择编译，下图为编译成功。1.数据库表的字段不能大小写混用，只能单一选择（最好都大写）；3.给表起别名不能加as关键字。点击保存即可，名称最好为大写字母。这个ID是表的主键需要用户自己写。表模式就是数据库名称。]]></description><category></category></item><item><title><![CDATA[Java实现导出Oracle数据库]]></title><link>https://blog.youkuaiyun.com/qq_54046847/article/details/131119749</link><guid>https://blog.youkuaiyun.com/qq_54046847/article/details/131119749</guid><author>qq_54046847</author><pubDate>Fri, 09 Jun 2023 09:11:32 +0800</pubDate><description><![CDATA[【代码】Java实现导出Oracle数据库。]]></description><category></category></item></channel></rss>