MySQL: Schema & Model Explained - Self-Learning Guide

  • Thread starter Thread starter chingkui
  • Start date Start date
  • Tags Tags
    Model Mysql
Click For Summary
SUMMARY

This discussion clarifies the distinction between "schema" and "model" in MySQL. A "model" refers to a feature in MySQL Workbench used for designing databases visually, while "schemas" are equivalent to databases in other database management systems. Users can create schemas through SQL queries generated by MySQL Workbench after modeling. The contributor expresses a preference for manual query writing over using the Workbench tool due to its complexity.

PREREQUISITES
  • Understanding of MySQL Workbench 8.0 features
  • Familiarity with SQL query execution
  • Basic knowledge of database design principles
  • Concept of database schemas in relational databases
NEXT STEPS
  • Explore MySQL Workbench modeling techniques
  • Learn how to generate SQL queries from models in MySQL Workbench
  • Study the differences between schemas and databases in various RDBMS
  • Practice writing SQL queries for database creation and management
USEFUL FOR

Self-learners of MySQL, database designers, and developers looking to understand database modeling and schema management in MySQL.

chingkui
Messages
178
Reaction score
2
Hi, I am self learning MySQL, I am a bit confuse with the terminology, can someone explain a little bit what is schema and model? And how they are usually used? Thanks.
 
Technology news on Phys.org
Short answer:

"Model" is a feature of MySQL Workbench, not really the database software itself. You use it to model out a database like you would on pen and paper. Once you've modeled a database, there's a menu option somewhere (I haven't used Workbench in a while :)) that automatically creates and executes the SQL queries to actually create the database/schema on the database server. Personally, I find Workbench to be confusing and clunky, and just model on pen and paper then write the queries myself.

"Schemas" are what most other database software calls "databases." It's the database that's actually running on the server that you query. One MySQL server can run multiple databases if you wish.
 

Similar threads

What does it mean that MySQL is a server application?
  • · Replies 16 ·
Replies
16
Views
3K
Is MySQL or PostgreSQL more ACID compliant for database projects?
  • · Replies 1 ·
Replies
1
Views
2K
Locating MySQL .ini File from the Command Line - Dave's Search
  • · Replies 3 ·
Replies
3
Views
2K
Can we Draw Dependency Diagrams in MySqL?
  • · Replies 1 ·
Replies
1
Views
3K
Is MySQL a programming language for databases?
  • · Replies 2 ·
Replies
2
Views
25K
Good website to ask coding questions?
  • · Replies 21 ·
Replies
21
Views
3K
Where should I try for learning programming?
  • · Replies 10 ·
Replies
10
Views
2K
Learning Database Concepts & Applications
  • · Replies 16 ·
Replies
16
Views
3K
PHP Learning Web Programming: MySQL & PHP for Complex Websites
  • · Replies 16 ·
Replies
16
Views
2K
Python Most efficient way to randomly choose a word from a file with a list of words
  • · Replies 35 ·
2
Replies
35
Views
7K