MariaDB/SQL/CREATE: 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 "==Example== * <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>" |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== | {{fmt/title|"CREATE" SQL command}} | ||
* < | ==About== | ||
The <code>CREATE</code> command is how you create various different objects in a database. | |||
==Reference== | |||
* [https://mariadb.com/kb/en/create/ MariaDB Knowledge Base] | |||
==Syntax== | |||
* <code>CREATE {{l/sub|DATABASE}}</code> (or <code>SCHEMA</code>) | |||
* <code>CREATE {{l/sub|TABLE}}</code> | |||
* <code>CREATE {{l/sub|VIEW}}</code> (create or replace) | |||
* <code>CREATE {{l/sub|CATALOG}}</code> | |||
* <code>CREATE {{l/sub|USER}}</code> | |||
* <code>CREATE {{l/sub|TRIGGER}}</code> | |||
* <code>CREATE {{l/sub|EVENT}}</code> | |||
* <code>CREATE {{l/sub|FUNCTION}}</code> | |||
* <code>CREATE {{l/sub|FUNCTION UDF}}</code> - user-defined function | |||
* <code>CREATE {{l/sub|INDEX}}</code> | |||
* <code>CREATE {{l/sub|PACKAGE}}</code> | |||
* <code>CREATE {{l/sub|PACKAGE BODY}}</code> | |||
* <code>CREATE {{l/sub|PROCEDURE}}</code> | |||
* <code>CREATE {{l/sub|ROLE}}</code> | |||
* <code>CREATE {{l/sub|SEQUENCE}}</code> | |||
* <code>CREATE {{l/sub|SERVER}}</code> | |||
Latest revision as of 22:19, 18 February 2025
|
"CREATE" SQL command
|
{{#set: page title="CREATE" SQL command }}
About
The CREATE command is how you create various different objects in a database.
