Difference Between Schema / Database in MySQL

by

As defined in the MySQL Glossary:

In MySQL, physically, a schema is synonymous with a database. You can substitute the keyword SCHEMA instead of DATABASE in MySQL SQL syntax, for example using CREATE SCHEMA instead of CREATE DATABASE.

Some other database products draw a distinction. For example, in the Oracle Database product, a schema represents only a part of a database: the tables and other objects owned by a single user.

More Related Contents:

  1. How do I show the schema of a table in a MySQL database?
  2. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  3. When to use MyISAM and InnoDB? [duplicate]
  4. Inventory management with stock options
  5. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. Do different databases use different name quote?
  8. Is there a MySQL option/feature to track history of changes to records?
  9. Adding a leading zero to some values in column in MySQL
  10. Auto Generate Database Diagram MySQL [closed]
  11. MySQL InnoDB foreign key between different databases
  12. View’s SELECT contains a subquery in the FROM clause
  13. MySQL : Multiple row as comma separated single row
  14. How to insert data to MySQL with auto-incremented column(field)?
  15. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  16. Case statement in MySQL
  17. Export a MySQL Database to SQLite Database
  18. Replace Into Query Syntax
  19. How to find out the MySQL root password
  20. Remote connect to clearDB heroku database
  21. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  22. How to display open transactions in MySQL
  23. MySQL query, MAX() + GROUP BY
  24. How to schedule a stored procedure in MySQL
  25. What’s the best way to migrate a Django DB from SQLite to MySQL?
  26. Easiest way to copy a table from one database to another?
  27. How to Get True Size of MySQL Database?
  28. Put MySQL database under version control?
  29. MySQL: Computed Column
  30. How to recover just deleted rows in mysql?

Leave a Comment