MariaDB/SQL/CREATE/DATABASE: Difference between revisions

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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>]..."
 
No edit summary
 
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

{{#set: page title="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>