AI 助理
备案控制台
开发者社区 数据库 文章 正文

[翻译]ADO.NET Entity Framework Beta2(六)/快速入门（实体框架）（1）/创建学校演示数据库

2016-11-28 2024
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
本文涉及的产品
RDS SQL Server Serverless，2-4RCU 50GB 3个月
推荐场景：
云数据库 RDS SQL Server，基础系列 2核4GB
推荐场景：
SQL Server性能诊断案例分析
简介：

In this task, you will create the schema for the School database and load data into the database. To do this, you use SQL Server Management Studio or SQL Server Management Studio Express to execute a Transact-SQL script. The resulting School database is used as the relational data store in the rest of the tasks in this quickstart.

在本任务中，你将创建学校数据库架构并填充数据。你要使用SQL Server 管理中心或 SQL Server Express管理中心来执行一个TSQL脚本。生成的数据库将在剩下的快速入门任务中作为关系型数据库被使用。

To create the School database and schema/创建数据库及架构

  1. On the File menu, point to New, and then click Database Engine Query. 在文件菜单，点击新建，然后单击数据库引擎查询。

  2. In the Connect to Database Engine dialog box, type either localhost or the name of the local SQL Server instance, and then click Connect.在连接到数据库引擎对话框，输入Loccalhost或者本地SQL Server的实例名，然后单击连接

  3. Paste the following Transact-SQL script in the query window and then click Execute.粘贴以下TSQL脚本到查询窗口并单击工具栏上的执行按钮。


    		 
    SET ANSI_NULLS ON
    
GO
    
SET QUOTED_IDENTIFIER ON
    
GO
    

    
USE [master];
    
GO
    

    
IF EXISTS (SELECT * FROM sys.databases WHERE name = 'School')
    
DROP DATABASE School;
    
GO
    

    
-- Create the School database.
    
CREATE DATABASE School;
    
GO
    

    
USE School;
    
GO
    

    
-- Create the Course table.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = 
    
OBJECT_ID(N'[dbo].[Course]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
BEGIN
    
CREATE TABLE [dbo].[Course](
    
[CourseID] [int] NOT NULL,
    
[Title] [nvarchar](100) NOT NULL,
    
[StartDate] [datetime] NULL,
    
[EndDate] [datetime] NULL,
    
[Credits] [int] NULL,
    
CONSTRAINT [PK_School.Course] PRIMARY KEY CLUSTERED 
    
(
    
[CourseID] ASC
    
) ON [PRIMARY]
    
) ON [PRIMARY]
    
END
    
GO
    

    
-- Create the Person table.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = 
    
OBJECT_ID(N'[dbo].[Person]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
BEGIN
    
CREATE TABLE [dbo].[Person](
    
[PersonID] [int] IDENTITY(1,1) NOT NULL,
    
[LastName] [nvarchar](50) NOT NULL,
    
[FirstName] [nvarchar](50) NOT NULL,
    
[HireDate] [datetime] NULL,
    
[EnrollmentDate] [datetime] NULL,
    
CONSTRAINT [PK_School.Student] PRIMARY KEY CLUSTERED 
    
(
    
[PersonID] ASC
    
) ON [PRIMARY]
    
) ON [PRIMARY]
    
END
    
GO
    

    
-- Create the Enrollment table.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = 
    
OBJECT_ID(N'[dbo].[Enrollment]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
BEGIN
    
CREATE TABLE [dbo].[Enrollment](
    
[EnrollmentID] [int] IDENTITY(1,1) NOT NULL,
    
[CourseID] [int] NOT NULL,
    
[StudentPersonID] [int] NOT NULL,
    
[Grade] [decimal](3, 2) NULL,
    
CONSTRAINT [PK_Enrollment] PRIMARY KEY CLUSTERED 
    
(
    
[EnrollmentID] ASC
    
) ON [PRIMARY]
    
) ON [PRIMARY]
    
END
    
GO
    

    
-- Create the CourseInstructor table.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CourseInstructor]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
BEGIN
    
CREATE TABLE [dbo].[CourseInstructor](
    
[CourseInstructorID] [int] IDENTITY(1,1) NOT NULL,
    
[CourseID] [int] NOT NULL,
    
[PersonID] [int] NOT NULL,
    
CONSTRAINT [PK_CourseInstructor] PRIMARY KEY CLUSTERED 
    
(
    
[CourseInstructorID] ASC
    
) ON [PRIMARY]
    
) ON [PRIMARY]
    
END
    
GO
    

    
-- Define the relationship between Enrollment and Course.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Enrollment_Course]') AND type = 'F')
    
ALTER TABLE [dbo].[Enrollment]  WITH CHECK ADD  CONSTRAINT [FK_Enrollment_Course] FOREIGN KEY([CourseID])
    
REFERENCES [dbo].[Course] ([CourseID])
    
GO
    

    
ALTER TABLE [dbo].[Enrollment] CHECK CONSTRAINT [FK_Enrollment_Course]
    
GO
    

    
-- Define the relationship between Enrollment and Person.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Enrollment_Student]') AND type = 'F')
    
ALTER TABLE [dbo].[Enrollment]  WITH CHECK ADD  CONSTRAINT [FK_Enrollment_Student] FOREIGN KEY([StudentPersonID])
    
REFERENCES [dbo].[Person] ([PersonID])
    
GO
    

    
ALTER TABLE [dbo].[Enrollment] CHECK CONSTRAINT [FK_Enrollment_Student]
    
GO
    

    
-- Define the relationship between CourseInstructor and Course.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_CourseInstructor_Course]') AND type = 'F')
    
ALTER TABLE [dbo].[CourseInstructor]  WITH CHECK ADD  CONSTRAINT [FK_CourseInstructor_Course] FOREIGN KEY([CourseID])
    
REFERENCES [dbo].[Course] ([CourseID])
    
GO
    

    
ALTER TABLE [dbo].[CourseInstructor] CHECK CONSTRAINT [FK_CourseInstructor_Course]
    
GO
    

    
-- Define the relationship between CourseInstructor and Person.
    
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_CourseInstructor_Person]') AND type = 'F')
    
ALTER TABLE [dbo].[CourseInstructor]  WITH CHECK ADD  CONSTRAINT [FK_CourseInstructor_Person] FOREIGN KEY([PersonID])
    
REFERENCES [dbo].[Person] ([PersonID])
    
GO
    

    
ALTER TABLE [dbo].[CourseInstructor] CHECK CONSTRAINT [FK_CourseInstructor_Person]
    
GO
    

    
-- Insert data into the Person table.
    
USE School
    
GO
    
SET IDENTITY_INSERT dbo.Person ON
    
GO
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (1, 'Abercrombie', 'Kim', '1995-03-11', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (2, 'Barzdukas', 'Gytis', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (3, 'Justice', 'Peggy', null, '2001-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (4, 'Fakhouri', 'Fadi', '2002-08-06', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (5, 'Harui', 'Roger', '1998-07-01', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (6, 'Li', 'Yan', null, '2002-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (7, 'Norman', 'Laura', null, '2003-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (8, 'Olivotto', 'Nino', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (9, 'Tang', 'Wayne', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (10, 'Alonso', 'Meredith', null, '2002-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (11, 'Lopez', 'Sophia', null, '2004-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (12, 'Browning', 'Meredith', null, '2000-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (13, 'Anand', 'Arturo', null, '2003-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (14, 'Walker', 'Alexandra', null, '2000-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (15, 'Powell', 'Carson', null, '2004-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (16, 'Jai', 'Damien', null, '2001-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (17, 'Carlson', 'Robyn', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (18, 'Zheng', 'Roger', '2004-02-12', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (19, 'Bryant', 'Carson', null, '2001-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (20, 'Suarez', 'Robyn', null, '2004-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (21, 'Holt', 'Roger', null, '2004-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (22, 'Alexander', 'Carson', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (23, 'Morgan', 'Isaiah', null, '2001-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (24, 'Martin', 'Randall', null, '2005-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (25, 'Kapoor', 'Candace', '2001-01-15', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (26, 'Rogers', 'Cody', null, '2002-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (27, 'Serrano', 'Stacy', '1999-06-01', null);
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (28, 'White', 'Anthony', null, '2001-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (29, 'Griffin', 'Rachel', null, '2004-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (30, 'Shan', 'Alicia', null, '2003-09-01');
    
INSERT INTO dbo.Person (PersonID, LastName, FirstName, HireDate, EnrollmentDate)
    
VALUES (31, 'Stewart', 'Jasmine', '2000-02-12', null);
    
GO
    
SET IDENTITY_INSERT dbo.Person OFF
    
GO
    

    
-- Insert data into the Course table.
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (4050, 'Math', '2007-09-01', '2007-09-01', 4);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (4051, 'Science', '2007-09-01', '2007-09-01', 4);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (3030, 'Art', '2007-09-01', '2007-09-01', 3);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (2021, 'Woodshop', '2007-09-01', '2007-09-01', 2);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (2022, 'Cooking', '2007-09-01', '2007-09-01', 2);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (4041, 'History', '2007-09-01', '2007-09-01', 4);
    
INSERT INTO dbo.Course (CourseID, Title, StartDate, EndDate, Credits)
    
VALUES (4042, 'Literature', '2007-09-01', '2007-09-01', 4);
    
GO
    

    
-- Insert data into the CourseInstructor table.
    
SET IDENTITY_INSERT dbo.CourseInstructor ON
    
GO
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (1, 4051, 1);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (2, 2021, 31);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (3, 2022, 5);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (4, 3030, 4);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (5, 4041, 27);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (6, 4042, 25);
    
INSERT INTO dbo.CourseInstructor(CourseInstructorID, CourseID, PersonID)
    
VALUES (7, 4050, 18);
    
GO
    
SET IDENTITY_INSERT dbo.CourseInstructor OFF
    
GO
    

    
-- Insert data into the Enrollment table.
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2021, 2, 4);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2021, 3, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2022, 6, 2.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2022, 7, 3.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2022, 8, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 9, 3.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 10, null);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 11, 2.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 12, null);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 13, 4);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4042, 14, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 15, 2.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 16, 2);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 17, null);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 19, 3.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 20, 4);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 21, 2);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4050, 22, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4041, 22, 3.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (2022, 22, 2.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 22, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 23, 1.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 24, 4);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 26, 3.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 28, 2.5);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (4051, 29, 3);
    
INSERT INTO dbo.Enrollment (CourseID, StudentPersonID, Grade)
    
VALUES (3030, 30, 3.5);
    
GO

Next Steps/下一H

You have successfully created the School database. Next, you will create the class scheduling application:

你已经成功创建了学校数据库，下面你将创建ClassScheduling用程序。

Creating the Class Schedule Application/创建ClassSchedule应用程序.

See Also/请参考

作者： 徐少侠
出处： http://www.cnblogs.com/Chinese-xu/

本文版权归作者和博客园共有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接。
如有问题，可以通过 Chinese_Xu@126.com 联系我，非常感谢。

分享家:Addthis中文版

本文转自徐少侠博客园博客，原文链接：http://www.cnblogs.com/Chinese-xu/archive/2007/09/21/901232.html，如需转载请自行联系原作者
文章标签：
云数据库 RDS SQL Server 版
Go
数据库
SQL
关键词：
.NET框架
.NET实体
ado.net数据库
ado.net entityframework数据库
.NET entityframework
相关实践学习
使用SQL语句管理索引
本次实验主要介绍如何在RDS-SQLServer数据库中，使用SQL语句管理索引。
SQL Server on Linux入门教程
SQL Server数据库一直只提供Windows下的版本。2016年微软宣布推出可运行在Linux系统下的SQL Server数据库，该版本目前还是早期预览版本。本课程主要介绍SQLServer On Linux的基本知识。 相关的阿里云产品：云数据库RDS SQL Server版 RDS SQL Server不仅拥有高可用架构和任意时间点的数据恢复功能，强力支撑各种企业应用，同时也包含了微软的License费用，减少额外支出。 了解产品详情: https://www.aliyun.com/product/rds/sqlserver
长征6号
目录
相关文章
土木林森
|
23天前
|
XML JSON API
ServiceStack：不仅仅是一个高性能Web API和微服务框架，更是一站式解决方案——深入解析其多协议支持及简便开发流程，带您体验前所未有的.NET开发效率革命
【10月更文挑战第9天】ServiceStack 是一个高性能的 Web API 和微服务框架，支持 JSON、XML、CSV 等多种数据格式。它简化了 .NET 应用的开发流程，提供了直观的 RESTful 服务构建方式。ServiceStack 支持高并发请求和复杂业务逻辑，安装简单，通过 NuGet 包管理器即可快速集成。示例代码展示了如何创建一个返回当前日期的简单服务，包括定义请求和响应 DTO、实现服务逻辑、配置路由和宿主。ServiceStack 还支持 WebSocket、SignalR 等实时通信协议，具备自动验证、自动过滤器等丰富功能，适合快速搭建高性能、可扩展的服务端应用。
土木林森
82 3
追逐时光者
|
23天前
|
开发框架 前端开发 API
C#/.NET/.NET Core优秀项目和框架2024年9月简报
C#/.NET/.NET Core优秀项目和框架2024年9月简报
追逐时光者
38 1
追逐时光者
|
23天前
|
Linux C# Android开发
.NET开源跨平台桌面和移动应用的统一框架 - Eto.Forms
.NET开源跨平台桌面和移动应用的统一框架 - Eto.Forms
追逐时光者
109 1
追逐时光者
|
23天前
|
开发框架 JavaScript 前端开发
一个适用于 ASP.NET Core 的轻量级插件框架
一个适用于 ASP.NET Core 的轻量级插件框架
追逐时光者
52 0
追逐时光者
|
23天前
|
存储 NoSQL API
.NET NoSQL 嵌入式数据库 LiteDB 使用教程
.NET NoSQL 嵌入式数据库 LiteDB 使用教程~
追逐时光者
34 0
m1a6
|
21天前
|
存储 关系型数据库 MySQL
Mysql(4)—数据库索引
数据库索引是用于提高数据检索效率的数据结构，类似于书籍中的索引。它允许用户快速找到数据，而无需扫描整个表。MySQL中的索引可以显著提升查询速度，使数据库操作更加高效。索引的发展经历了从无索引、简单索引到B-树、哈希索引、位图索引、全文索引等多个阶段。
m1a6
55 3
Mysql(4)—数据库索引
众所周知
|
7天前
|
关系型数据库 MySQL Linux
在 CentOS 7 中通过编译源码方式安装 MySQL 数据库的详细步骤，包括准备工作、下载源码、编译安装、配置 MySQL 服务、登录设置等。
本文介绍了在 CentOS 7 中通过编译源码方式安装 MySQL 数据库的详细步骤，包括准备工作、下载源码、编译安装、配置 MySQL 服务、登录设置等。同时，文章还对比了编译源码安装与使用 RPM 包安装的优缺点，帮助读者根据需求选择最合适的方法。通过具体案例，展示了编译源码安装的灵活性和定制性。
众所周知
41 2
众所周知
|
10天前
|
存储 关系型数据库 MySQL
MySQL vs. PostgreSQL：选择适合你的开源数据库
在众多开源数据库中，MySQL和PostgreSQL无疑是最受欢迎的两个。它们都有着强大的功能、广泛的社区支持和丰富的生态系统。然而，它们在设计理念、性能特点、功能特性等方面存在着显著的差异。本文将从这三个方面对MySQL和PostgreSQL进行比较，以帮助您选择更适合您需求的开源数据库。
众所周知
46 4
代码bug生产队
|
15天前
|
存储 关系型数据库 MySQL
如何在MySQL中创建数据库？
【10月更文挑战第16天】如何在MySQL中创建数据库？
代码bug生产队
21 1
小Tomkk
|
19天前
|
SQL Oracle 关系型数据库
安装最新 MySQL 8.0 数据库（教学用）
安装最新 MySQL 8.0 数据库（教学用）
小Tomkk
88 4

热门文章

最新文章

  • 1
    RDS入门——Excel文件转存到RDS数据库实践
  • 2
    基于SQL Server的打车系统数据库分析与设计
  • 3
    NSPredicate用法总结(Cocoa框架中的NSPredicate用于查询，原理和用法都类似于SQL中的where，作用相当于数据库的过滤取)
  • 4
    【译】使用 PHP 和 SQL 构建可搜索的加密数据库
  • 5
    数据库厂商提供的 Providers for ASP.NET
  • 6
    数据库改名系列（数据库名，逻辑名，物理文件名）
  • 7
    最全MySQL面试60题（含答案）：存储引擎+数据库锁+索引+SQL优化等
  • 8
    值得收藏:当向数据库导入大量数据时,mysql主键唯一键重复插入,如何丝滑操作并不导入重复数据呢
  • 9
    干货分享 ｜ 揭秘下一代云数据库引擎MyBase for MySQL
  • 10
    数据库只读时无法更新的解决方法
  • 1
    MQTT常见问题之调用.net sdk 报“不知道这样的主机”如何解决
    183
  • 2
    .NET智慧手术室管理平台源码
    114
  • 3
    .NET从入门到精通，零基础也能搞定的基础知识教程
    134
  • 4
    三款.NET 代码混淆工具比较分析：ConfuserEx、Obfuscar 和 Ipa Guard
    284
  • 5
    asp.net中条件查询+分页
    61
  • 6
    你不知道ADo.Net中操作数据库的步骤【超详细整理】
    48
  • 7
    使用ADO.NET查询和操作数据
    43
  • 8
    使用ADO.NET访问数据库
    43
  • 9
    .net三层架构开发步骤
    46
  • 10
    深入.net平台的分层开发
    101

    • 相关课程

    更多
  • 数据库的前世今生
  • 数据库核心概念
  • 从传统数据库到云数据库演进
  • 数据库常见问题排查
  • 数据库及SQL/MySQL基础
  • 高校精品课-西安交通大学 -数据库理论与技术

    • 相关电子书

    更多
  • DTCC 2022大会集锦《云原生一站式数据库技术与实践》
  • 阿里云瑶池数据库精要2022版
  • 2022 DTCC-阿里云一站式数据库上云最佳实践

    • 相关实验场景

    更多
  • 数据库实验室挑战任务-高级任务
  • 数据库实验室挑战任务-中级任务
  • 数据库实验室挑战任务-初级任务
  • 阿里云数据库产品实验室
  • MongoDB数据库入门
  • 使用DAS实现数据库自动扩容和回缩
    • 下一篇
    阿里云无影云电脑免费试用，最长可试用3个月