<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[X231_的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/X231_</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; X231_]]></copyright><item><title><![CDATA[MySQL报错Error Code：1175--删除/更新数据报错]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/131140235</link><guid>https://blog.youkuaiyun.com/X231_/article/details/131140235</guid><author>X231_</author><pubDate>Sat, 10 Jun 2023 11:40:57 +0800</pubDate><description><![CDATA[因为MySQL运行在safe-updates模式下，该模式会导致非主键条件下无法执行update或者delete命令。2、执行命令SET SQL_SAFE_UPDATES = 0;]]></description><category></category></item><item><title><![CDATA[MYSQL触发器和事件]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/131139031</link><guid>https://blog.youkuaiyun.com/X231_/article/details/131139031</guid><author>X231_</author><pubDate>Sat, 10 Jun 2023 10:32:09 +0800</pubDate><description><![CDATA[【例11.5】 在stusys 数据库的student表创建一个触发器T_deleteStudentScore，当删除表student中某个学生的记录时，同时将score表中与该学生有关的数据全部删除。#【例11.3】 在stusys 数据库的student表创建触发器T_inserStudentRecord，当向student表插入一条记录时，显示插入记录的学生的姓名。#【例11.8】创建事件E_startDays，从第2天起，每天清空表tb，在2021年12月31日结束。]]></description><category></category></item><item><title><![CDATA[mysql内容管理]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/131138824</link><guid>https://blog.youkuaiyun.com/X231_/article/details/131138824</guid><author>X231_</author><pubDate>Sat, 10 Jun 2023 10:15:04 +0800</pubDate><description><![CDATA[【例12.12】授予已存在用户qiao在数据库stusys的student表上的SELECT和UPDATE权限，并允许将自身的权限授予其他用户。#【例12.6】先创建新用户hong和liu，然后授予它们在数据库stusys的student表上的SELECT和INSERT权限。#【例12.5】 授予用户lee在数据库stusys的student表上对学号列和姓名列的SELECT权限。#【例12.9】授予已存在用户zhou对所有数据库中所有表的SELECT和UPDATE的权限。]]></description><category></category></item><item><title><![CDATA[MySQL的10.5 ，10.6 ，10.7 ，10.8]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/130735789</link><guid>https://blog.youkuaiyun.com/X231_/article/details/130735789</guid><author>X231_</author><pubDate>Wed, 17 May 2023 21:58:45 +0800</pubDate><description><![CDATA[when '副教授' then set v_type='高级职称';when '教授' then set v_type='高级职称';when '讲师' then set v_type='中级职称';when '助教'then set v_type='初级职称';]]></description><category></category></item><item><title><![CDATA[MySQL的设计性实验，视图]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/130485540</link><guid>https://blog.youkuaiyun.com/X231_/article/details/130485540</guid><author>X231_</author><pubDate>Thu, 04 May 2023 14:19:16 +0800</pubDate><description><![CDATA[1，创建视图（3）（4）（5）（6）]]></description><category></category></item><item><title><![CDATA[MySQL的设计性实验，信息查询]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/130484531</link><guid>https://blog.youkuaiyun.com/X231_/article/details/130484531</guid><author>X231_</author><pubDate>Thu, 04 May 2023 13:47:49 +0800</pubDate><description><![CDATA[6，查询选修了8001课程且为计算机专业学生的姓名及成绩，查出的成绩按降序排列。7,查询地址为上海市浦东区的学生的姓名，专业，课程号和成绩。4，查询课程不同，成绩相同的学生的学号，课程号和成绩。8，查询8001课程的成绩高于4002课程成绩的学生。（2）where 子句定义连接条件的隐式语法结构。5，查询选修1004课程的学生姓名，性别和成绩。（2）where 子句定义连接条件的语法结构。3，采用自然链接查询每个学生选修课程的情况。（1），inner in的显示语法结构。2，查询每个学生选修课程的情况。]]></description><category></category></item><item><title><![CDATA[MySQl视图和索引]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/130309948</link><guid>https://blog.youkuaiyun.com/X231_/article/details/130309948</guid><author>X231_</author><pubDate>Sat, 22 Apr 2023 20:36:26 +0800</pubDate><description><![CDATA[1,2,3,4,5,6,7,8,9,]]></description><category></category></item><item><title><![CDATA[MySQl数据查询]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/130240407</link><guid>https://blog.youkuaiyun.com/X231_/article/details/130240407</guid><author>X231_</author><pubDate>Wed, 19 Apr 2023 11:38:03 +0800</pubDate><description><![CDATA[应用题1，2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,]]></description><category></category></item><item><title><![CDATA[MySQL数据查询]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/129877186</link><guid>https://blog.youkuaiyun.com/X231_/article/details/129877186</guid><author>X231_</author><pubDate>Fri, 31 Mar 2023 12:22:40 +0800</pubDate><description><![CDATA[1，2，3，]]></description><category></category></item><item><title><![CDATA[表的插入，insert实验后续]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/129756940</link><guid>https://blog.youkuaiyun.com/X231_/article/details/129756940</guid><author>X231_</author><pubDate>Fri, 24 Mar 2023 19:55:39 +0800</pubDate><description><![CDATA[1， #将一个表中的记录快速插入另一个表中。4,#采用两种不同的方法删除表中的全部数据。2，#用三种不同方法,向一个表插入数据。3，#将一个表中的数据更新和修改。]]></description><category></category></item><item><title><![CDATA[MYSQL，表的创建和插入]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/129706685</link><guid>https://blog.youkuaiyun.com/X231_/article/details/129706685</guid><author>X231_</author><pubDate>Wed, 22 Mar 2023 12:01:22 +0800</pubDate><description><![CDATA[对MYSQL的表的简单总结叙述]]></description><category></category></item><item><title><![CDATA[MYSQL数据库和表]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/129532786</link><guid>https://blog.youkuaiyun.com/X231_/article/details/129532786</guid><author>X231_</author><pubDate>Tue, 14 Mar 2023 17:31:50 +0800</pubDate><description><![CDATA[表（TABLE）是数据库中用来存储数据的对象，是有结构的数据的集合，是整个数据库系统的基础。表是包含数据库中所有数据的数据库对象。| ssex       | char(2)    | NO   |     | 男      |                || ssex       | char(2)    | NO   |     | 男      |                || ssex       | char(2)    | NO   |     | 男      |       |]]></description><category></category></item><item><title><![CDATA[设计E-R图]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/129284508</link><guid>https://blog.youkuaiyun.com/X231_/article/details/129284508</guid><author>X231_</author><pubDate>Wed, 01 Mar 2023 16:32:16 +0800</pubDate><description><![CDATA[简单E-R图]]></description><category></category></item><item><title><![CDATA[MySQL的安装文案]]></title><link>https://blog.youkuaiyun.com/X231_/article/details/129278855</link><guid>https://blog.youkuaiyun.com/X231_/article/details/129278855</guid><author>X231_</author><pubDate>Wed, 01 Mar 2023 16:11:10 +0800</pubDate><description><![CDATA[保姆级一步步安装]]></description><category></category></item></channel></rss>