Difference between revisions of "MariaDB/SQL/CREATE"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< MariaDB‎ | SQL
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Related==
+
{{fmt/title|"CREATE" SQL command}}
* <code>{{l/same|DROP}}</code> deletes existing users
+
==About==
==Example==
+
The <code>CREATE</code> command is how you create various different objects in a database.
* <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>
+
==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

About

The CREATE command is how you create various different objects in a database.

Reference

Syntax