Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

MySQL: schema, model

  1. Jan 27, 2012 #1
    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.
  2. jcsd
  3. Jan 28, 2012 #2
    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.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook