MariaDB/SQL/CREATE/DATABASE

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< MariaDB‎ | SQL‎ | CREATE
Revision as of 22:08, 18 February 2025 by Woozle (talk | contribs) (Created page with "{{fmt/title|"CREATE DATABASE" SQL command}} ==Syntax== <code>CREATE</code> [<code>OR REPLACE</code>] {<code>DATABASE</code> | <code>SCHEMA</code>} [<code>IF NOT EXISTS</code>]...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
"CREATE DATABASE" SQL command

Syntax

CREATE [OR REPLACE] {DATABASE | SCHEMA} [IF NOT EXISTS] <db name> [<create_specification>] [repeat...]

argument name value(s)
<create_specification> one of –
  • [DEFAULT] CHARACTER SET [=] <charset name>
  • [DEFAULT] COLLATE [=] <collation name>
  • COMMENT [=] '<comment>'
<charset name>
<collation name>