数据库学习作业源码的相关内容

阿里云文档 2023-09-03

以简化版的emp为例学习创建新表_云原生数据库PolarDB PostgreSQL版（兼容Oracle）_云原生数据库 PolarDB(PolarDB)

通过指定表名称以及所有列名称及其类型来创建新表。

文章 2022-10-02 来自：开发者社区

数据库学习-连接查询&子查询作业示例【带源码】

目录1.查询“Chisel”所在车间的车间编号、车间主任姓名、主任联系方式2.查询所有员工姓名、员工联系电话、车间地址、车间主任姓名、主任联系方式3.查询“Chisel”所在车间的所有员工姓名、员工联系电话、车间地址4.查询生产出质量达标产品的产品编号、员工姓名、员工联系电话5.查询已生产产品车间的车间号、平均工龄6.查询所有产品的产品编号、是否合格（合格返回true不合格返回fal....

文章 2022-10-02 来自：开发者社区

数据库学习-视图作业示例【带源码】

目录1.创建视图“view_info”,查询所有员工姓名、员工联系电话、车间地址、车间主任姓名、主任联系方式2.查看“view_info”视图字段信息3.创建视图“view_ chisel”,查询“Chisel”所在车间的所有员工姓名、员工联系电话、车间地址4.查看库中所有表5.创建视图“view_ standard”,查询生产出质量达标产品的产品编号、员工姓名、员工联系电话6.查看....

文章 2022-10-02 来自：开发者社区

数据库学习-视图的应用作业示例【带源码】

目录 1.创建表2.添加数据3.查看数据4.创建视图1.创建表编辑create table stu( -> s_id int(11) not null unique primary key, -> s_name varchar(20) not null, -> addr varc....

文章 2022-10-02 来自：开发者社区

数据库学习-存储过程的应用作业示例【带源码】

目录1.创建一个stu 表 2.添加stu表数据 3.创建一个存储过程 1.创建一个stu 表编辑create table zjl_stu( -> id int(10) not null, -> name varchar(50) not null, -> class varchar(50....

文章 2022-10-02 来自：开发者社区

数据库学习-事务管理作业示例【带源码】

目录一、新建数据库二、事务的提交 1.事务的隔离级别1.1脏读 1.2演示脏读 1.3设置b账户中事务的隔离级别 1.4.验证是否出现脏读 2.不可重复性 2.1演示不可重复性 2.2设置b账户中事务的隔离级别 2.3验证是否出现不可重复读 3.幻读 3.1设置b账户中事务的隔离级别 3.2演示幻读 3.3重新设置账户的隔离级别 3.4验证是否出现幻读 4.可串行化 4.1设置b账.....

文章 2022-10-02 来自：开发者社区

数据库学习-复习作业示例(电子商城项目)【带源码】

目录任务一、二安装并配置MySQL 1.打开控制台2.登录MySQL数据库、表的基本操作 1.创建电子商城数据库“mall_姓名全拼”2.使用电子商城数据库3.创建用户表“user_姓名全拼”，表中字段信息如下：4.创建卖家信息表“seller_姓名全拼”，表中字段信息如下：5.创建买家信息表“buyer_姓名全拼”，表中字段信息如下：6.创建地址表“address_姓名全拼”，表....

共有17条

< 1 2 >

跳转至： GO

更新时间 2024-02-25 10:32:34

本页面内关键词为智能算法引擎基于机器学习所生成，如有任何问题，可在页面下方点击"联系我们"与我们沟通。

数据库更多学习相关

数据库您可能感兴趣

产品推荐

{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"","iconImg":"https://img.alicdn.com/tfs/TB1nmXJn7cx_u4jSZFlXXXnUFXa-200-200.png","contentLink":"https://www.aliyun.com/product/dbaudit","title":"数据库审计","des":"满足等保2.0二级和三级 “安全审计”合规要求的同时，智能解析数据库通信流量，细粒度审计数据库访问行为，通过对数据库全量行为的审计溯源、危险攻击的实时告警、风险语句的智能预警，提供数据库资产最安全的监控保障。","link1":"https://yundun.console.aliyun.com/?p=sddp#/audit/analysis/alarm/auditFirst/cn-zhangjiakou","btn1":"产品控制台","link2":"https://common-buy.aliyun.com/?commodityCode=sddp_pre&request=%7B%22ord_time%22:%221:Month%22,%22order_num%22:1,%22region%22:%22cn-zhangjiakou%22,%22type%22:%22normal%22,%22sddp_version%22:%22version_dengbao%22,%22audit_subscription_version%22:%220%22,%22logStorage_subscription%22:%221%22,%22logStorage%22:2%7D&regionId=cn-zhangjiakou","btn2":"立即购买","btn3":"产品文档","link3":"https://help.aliyun.com/product/52432.html?spm=5176.139959.J_5253785160.5.42de77d7KNxtZZ","infoGroup":[{"infoName":"精选推荐","infoContent":{"firstContentName":"包年享85折优惠","firstContentLink":"https://common-buy.aliyun.com/?commodityCode=sddp_pre&request=%7B%22ord_time%22:%221:Month%22,%22order_num%22:1,%22region%22:%22cn-zhangjiakou%22,%22type%22:%22normal%22,%22sddp_version%22:%22version_dengbao%22,%22audit_subscription_version%22:%220%22,%22logStorage_subscription%22:%221%22,%22logStorage%22:2%7D&regionId=cn-zhangjiakou","lastContentLink":"","lastContentName":""}},{"infoName":"用户指南","infoContent":{"firstContentName":"产品快速入门","lastContentName":"不同版本功能对比","firstContentLink":"https://help.aliyun.com/zh/dsc/data-security-center/user-guide/security-audit/","lastContentLink":"https://help.aliyun.com/zh/dsc/data-security-center/product-overview/difference-between-different-dsc-editions"}}]}],"card":[],"search":[],"infoCard":[{"bannerUrl":"https://img.alicdn.com/tfs/TB1Xf81a3gP7K4jSZFqXXamhVXa-5169-974.jpg","bannerTitle":"数据库审计","bannerContent":"满足等保2.0二级和三级 “安全审计”合规要求的同时，智能解析数据库通信流量，细粒度审计数据库访问行为，通过对数据库全量行为的审计溯源、危险攻击的实时告警、风险语句的智能预警，提供数据库资产最安全的监控保障。","liveButtonName":"查看详情","liveButtonLink":"https://www.aliyun.com/product/dbaudit?spm=5176.21213303.8115314850.1.faf453c9I9EKNe&scm=20140722.S_card@@%E5%8D%A1%E7%89%87@@1796._.ID_card@@%E5%8D%A1%E7%89%87@@1796-RL_%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AE%A1%E8%AE%A1-OR_ser-V_2-P0_0","contentTitle":"满足等保2.0’安全审计‘的合规要求","homePageLink":"https://page.aliyun.com/form/act803688306/index.htm","homePageName":"7天试用","linkGroup":[{"linkContent":"发布包大小极致优化，节省流量和存储。"},{"linkContent":"服务迭代不再受发版限制，快速发布，快速迭代。"},{"linkContent":"业务开发效率更加优秀，一次开发，多端运行。"}]}],"title":{"mainTitle":"数据库审计","subtitle":"满足等保2.0二级和三级 “安全审计”合规要求的同时，智能解析数据库通信流量，细粒度审计数据库访问行为，通过对数据库全量行为的审计溯源、危险攻击的实时告警、风险语句的智能预警，提供数据库资产最安全的监控保障。","linkUrl":"https://www.aliyun.com/product/dbaudit?spm=5176.21213303.8115314850.1.faf453c9I9EKNe&scm=20140722.S_card@@%E5%8D%A1%E7%89%87@@1796._.ID_card@@%E5%8D%A1%E7%89%87@@1796-RL_%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AE%A1%E8%AE%A1-OR_ser-V_2-P0_0","btnText":"查看详情"},"visual":{"topbg":"https://img.alicdn.com/tfs/TB1bQuBIYH1gK0jSZFwXXc7aXXa-3840-740.gif","icon":"","textColor":"dark"},"dataList":[{"summary":"啦啦啦","author":"wuwu","linksUrl":"#"}],"sceneCard":[],"txt":[]}

{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"","iconImg":"https://img.alicdn.com/tfs/TB1nmXJn7cx_u4jSZFlXXXnUFXa-200-200.png","contentLink":"https://www.aliyun.com/product/dbaudit","title":"数据库审计","des":"满足等保2.0二级和三级 “安全审计”合规要求的同时，智能解析数据库通信流量，细粒度审计数据库访问行为，通过对数据库全量行为的审计溯源、危险攻击的实时告警、风险语句的智能预警，提供数据库资产最安全的监控保障。","link1":"https://yundun.console.aliyun.com/?p=sddp#/audit/analysis/alarm/auditFirst/cn-zhangjiakou","btn1":"产品控制台","link2":"https://common-buy.aliyun.com/?commodityCode=sddp_pre&request=%7B%22ord_time%22:%221:Month%22,%22order_num%22:1,%22region%22:%22cn-zhangjiakou%22,%22type%22:%22normal%22,%22sddp_version%22:%22version_dengbao%22,%22audit_subscription_version%22:%220%22,%22logStorage_subscription%22:%221%22,%22logStorage%22:2%7D&regionId=cn-zhangjiakou","btn2":"立即购买","btn3":"产品文档","link3":"https://help.aliyun.com/product/52432.html?spm=5176.139959.J_5253785160.5.42de77d7KNxtZZ","infoGroup":[{"infoName":"精选推荐","infoContent":{"firstContentName":"包年享85折优惠","firstContentLink":"https://common-buy.aliyun.com/?commodityCode=sddp_pre&request=%7B%22ord_time%22:%221:Month%22,%22order_num%22:1,%22region%22:%22cn-zhangjiakou%22,%22type%22:%22normal%22,%22sddp_version%22:%22version_dengbao%22,%22audit_subscription_version%22:%220%22,%22logStorage_subscription%22:%221%22,%22logStorage%22:2%7D&regionId=cn-zhangjiakou","lastContentLink":"","lastContentName":""}},{"infoName":"用户指南","infoContent":{"firstContentName":"产品快速入门","lastContentName":"不同版本功能对比","firstContentLink":"https://help.aliyun.com/zh/dsc/data-security-center/user-guide/security-audit/","lastContentLink":"https://help.aliyun.com/zh/dsc/data-security-center/product-overview/difference-between-different-dsc-editions"}}]}],"card":[],"search":[],"infoCard":[{"bannerUrl":"https://img.alicdn.com/tfs/TB1Xf81a3gP7K4jSZFqXXamhVXa-5169-974.jpg","bannerTitle":"数据库审计","bannerContent":"满足等保2.0二级和三级 “安全审计”合规要求的同时，智能解析数据库通信流量，细粒度审计数据库访问行为，通过对数据库全量行为的审计溯源、危险攻击的实时告警、风险语句的智能预警，提供数据库资产最安全的监控保障。","liveButtonName":"查看详情","liveButtonLink":"https://www.aliyun.com/product/dbaudit?spm=5176.21213303.8115314850.1.faf453c9I9EKNe&scm=20140722.S_card@@%E5%8D%A1%E7%89%87@@1796._.ID_card@@%E5%8D%A1%E7%89%87@@1796-RL_%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AE%A1%E8%AE%A1-OR_ser-V_2-P0_0","contentTitle":"满足等保2.0’安全审计‘的合规要求","homePageLink":"https://page.aliyun.com/form/act803688306/index.htm","homePageName":"7天试用","linkGroup":[{"linkContent":"发布包大小极致优化，节省流量和存储。"},{"linkContent":"服务迭代不再受发版限制，快速发布，快速迭代。"},{"linkContent":"业务开发效率更加优秀，一次开发，多端运行。"}]}],"title":{"mainTitle":"数据库审计","subtitle":"满足等保2.0二级和三级 “安全审计”合规要求的同时，智能解析数据库通信流量，细粒度审计数据库访问行为，通过对数据库全量行为的审计溯源、危险攻击的实时告警、风险语句的智能预警，提供数据库资产最安全的监控保障。","linkUrl":"https://www.aliyun.com/product/dbaudit?spm=5176.21213303.8115314850.1.faf453c9I9EKNe&scm=20140722.S_card@@%E5%8D%A1%E7%89%87@@1796._.ID_card@@%E5%8D%A1%E7%89%87@@1796-RL_%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AE%A1%E8%AE%A1-OR_ser-V_2-P0_0","btnText":"查看详情"},"visual":{"topbg":"https://img.alicdn.com/tfs/TB1bQuBIYH1gK0jSZFwXXc7aXXa-3840-740.gif","icon":"","textColor":"dark"},"dataList":[{"summary":"啦啦啦","author":"wuwu","linksUrl":"#"}],"sceneCard":[],"txt":[]}}

数据库审计

满足等保2.0二级和三级 “安全审计”合规要求的同时，智能解析数据库通信流量，细粒度审计数据库访问行为，通过对数据库全量行为的审计溯源、危险攻击的实时告警、风险语句的智能预警，提供数据库资产最安全的监控保障。

产品控制台

立即购买

产品文档

精选推荐

包年享85折优惠

用户指南

产品快速入门

不同版本功能对比