Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Creating Tables and Manipulating Data with SQL Creating a Table

Posted by Anna Anna
Anna Anna
Courses Plus Student 254 Points

MySQL 'create schema' and 'create database' - Is there any difference

Are there any differences? What is purpose of database schema?

4 Answers

ericb2
ericb2
11,429 Points
ericb2
ericb2
11,429 Points

from the CREATE DATABASE Syntax page of MySQL Manual: "CREATE SCHEMA is a synonym for CREATE DATABASE."

Jeffrey Lego
Jeffrey Lego
9,458 Points
Jeffrey Lego
Jeffrey Lego
9,458 Points

A database is the main contaier and holds everything - schema, data files, logs, etc.

Schemas are used to group local objects together, they are like folders within the database.

Christipher Miller
Christipher Miller
1,296 Points
Christipher Miller
Christipher Miller
1,296 Points

What Jeffery said is wrong.

Erwin Paolo Yumul
Erwin Paolo Yumul
13,852 Points
Erwin Paolo Yumul
Erwin Paolo Yumul
13,852 Points

They are the same.