MariaDB/SQL/CREATE: Difference between revisions

Latest revision as of 22:19, 18 February 2025

"CREATE" SQL command

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

@@ 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==
-** '''Note''': Sometimes it only works if you quote the entire user-spec, as in <code>'roundcube@localhost'</code>. I'm trying to figure out what the rule is.
+* [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>