Difference between revisions of "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
Jump to navigation Jump to search
(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>]...")
 
 
Line 1: Line 1:
 
{{fmt/title|"CREATE DATABASE" SQL command}}
 
{{fmt/title|"CREATE DATABASE" SQL command}}
 
==Syntax==
 
==Syntax==
<code>CREATE</code> [<code>OR REPLACE</code>] {<code>DATABASE</code> | <code>SCHEMA</code>} [<code>IF NOT EXISTS</code>] {{fmt/arg|db name}} [{{fmt/arg|create_specification}}] [''repeat...'']
+
<code>CREATE</code> [<code>OR REPLACE</code>] {<code>DATABASE</code> | <code>SCHEMA</code>} [<code>IF NOT EXISTS</code>] `{{fmt/arg|db name}}` [{{fmt/arg|create_specification}}] [''repeat...'']
  
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"

Latest revision as of 22:11, 18 February 2025

"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>