MySQL 数据库示例

各种复杂度级别的MySQL数据库脚本示例,从简单表到企业ERP系统

📄 简单学生数据库

🟢 simple

基础学生信息表,包含AUTO_INCREMENT和基本数据类型

⏱️ 2 min 🏷️ students, basic, education, simple, auto-increment
📄

Basic student information table with AUTO_INCREMENT and simple data types

Download File

File size: 810 B

📄 产品库存管理系统

🟢 simple

产品目录与分类,包含外键关联和基础关系数据库概念

⏱️ 3 min 🏷️ products, inventory, categories, foreign-keys, relationships
📄

Product catalog with categories, foreign keys, and basic relational database concepts

Download File

File size: 1.5 KB

📄 博客系统

🟡 intermediate ⭐⭐

多表博客系统,包含用户、文章、评论、索引和时间戳

⏱️ 5 min 🏷️ blog, users, posts, comments, indexes, timestamps
📄

Multi-table blog system with users, posts, comments, indexes, and timestamps

Download File

File size: 3.2 KB

📄 电商订单系统

🟡 intermediate ⭐⭐

完整电商系统,包含客户、产品、订单和订单项

⏱️ 8 min 🏷️ ecommerce, orders, customers, products, order-items, aggregates
📄

Complete e-commerce system with customers, products, orders, and order items

Download File

File size: 4.7 KB

📄 图书馆管理系统

🟡 intermediate ⭐⭐⭐

完整图书馆系统,包含图书、读者、借阅记录和罚金

⏱️ 10 min 🏷️ library, books, readers, borrowing, fines, date-calculations
📄

Complete library system with books, readers, borrowing records, and fines

Download File

File size: 6.5 KB

📄 银行账户系统

🟡 intermediate ⭐⭐⭐

金融银行系统,包含账户、交易、贷款和风险分析

⏱️ 12 min 🏷️ banking, accounts, transactions, loans, financial, risk-analysis
📄

Financial banking system with accounts, transactions, loans, and risk analysis

Download File

File size: 8.7 KB

📄 医院管理系统

🔴 complex ⭐⭐⭐

医疗系统,包含科室、医生、患者、预约和病历

⏱️ 15 min 🏷️ hospital, healthcare, doctors, patients, appointments, medical-records
📄

Healthcare system with departments, doctors, patients, appointments, and medical records

Download File

File size: 8.2 KB

📄 在线学习平台

🔴 complex ⭐⭐⭐⭐

教育平台,包含用户、课程、章节、作业和学习进度跟踪

⏱️ 20 min 🏷️ education, learning, courses, users, progress, assignments, grading
📄

Educational platform with users, courses, lessons, assignments, and progress tracking

Download File

File size: 11.7 KB

📄 企业ERP系统

🔴 complex ⭐⭐⭐⭐⭐

完整企业资源规划系统,包含人事、财务、采购、销售和库存

⏱️ 30 min 🏷️ erp, enterprise, hr, finance, procurement, sales, inventory, accounting
📄

Complete enterprise resource planning system with HR, finance, procurement, sales, and inventory

Download File

File size: 16.2 KB