MYSQL示例数据库：employees

基于Labview的BS系统web的项目示例——数据库读写功能 实现目标： 在上次笔记的基础上，添加数据库的读写功能 浏览器端通过：写入数据按钮，将数据传入后端，后端接收数据并写入数据库 浏览器端通过：读取数据按钮，传输数据ID，后端将根据数据ID读取数据库的数据，并传回浏览器端，显示在浏览器上 数据库使用的是MySQL

此版本2012年，为SQL Server 2008 R2和2008版本AdventureWorks数据库整合到一个页面上。 每个zip文件包含一个mdf数据库文件和ldf日志文件。 这应该很容易地找到和下载AdventureWorks数据库，因为所有OLTP版本的是在一个页面上。 有没有数据库架构更改。 对于每个版本的产品，有一个重量轻，完整版本的AdventureWorks示例数据库。 轻量版本在文件名的缩写LT表示。 AdventureWorks数据库可以安装附加数据库，或使用CREATE DATABASE语句。

SQLSERVER2000后就不自带示例数据库了，这个是示例数据库的脚本 安装方法： 1、安装SQL2000SampleDb.msi后在C盘下有目录SQL Server 2000 Sample Databases，该目录下有instnwnd.sql、instpubs.sql脚本 2、打开SSMS，“文件---打开---文件”选择上面两个脚本即可创建示例数据库

《Microsoft SQL Server入门教程》专栏使用的示例数据库和表，包含两个模式和 9 个数据表。

金蝶 KIS 示例数据库 结合文档看看

AdventureWorks2016,2017示例数据库，AdventureWorksDW2016,2017数据仓库（bak文件）

sql server 2005中基于示例数据库AdventureworksDB的数据仓库（OLAP）

微软SQL Server示例数据库AdventureWorks2019，下载自https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=tsql

mysql示例数据库 employee,这个大家也可以到github官网下载。 https://github.com/datacharmer/test_db test_db A sample database with an integrated test suite, used to test your applications and database servers This repository was migrated from Launchpad. See usage in the MySQL docs Where it comes from The original data was created by Fusheng Wang and Carlo Zaniolo at Siemens Corporate Research. The data is in XML format. http://timecenter.cs.aau.dk/software.htm Giuseppe Maxia made the relational schema and Patrick Crews exported the data in relational format. The database contains about 300,000 employee records with 2.8 million salary entries. The export data is 167 MB, which is not huge, but heavy enough to be non-trivial for testing. The data was generated, and as such there are inconsistencies and subtle problems. Rather than removing them, we decided to leave the contents untouched, and use these issues as data cleaning exercises. Prerequisites You need a MySQL database server (5.0+) and run the commands below through a user that has the following privileges: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW Installation: Download the repository Change directory to the repository Then run mysql < employees.sql If you want to install with two large partitioned tables, run mysql < employees_partitioned.sql Testing the installation After installing, you can run one of the following mysql -t < test_employees_md5.sql # OR mysql -t < test_employees_sha.sql For example: mysql -t < test_employees_md5.sql +----------------------+ | INFO | +----------------------+ | TESTING INSTALLATION | +----------------------+ +--------------+------------------+----------------------------------+ | table_name | expected_records | expected_crc | +--------------+------------------+----------------------------------+ | employees | 300024 |