MariaDB/SQL/CREATE - Revision history

Woozle at 22:19, 18 February 2025

2025-02-18T22:19:00Z

← Older revision		Revision as of 22:19, 18 February 2025
Line 5:		Line 5:
	* [https://mariadb.com/kb/en/create/ MariaDB Knowledge Base]		* [https://mariadb.com/kb/en/create/ MariaDB Knowledge Base]
	==Syntax==		==Syntax==
	* CREATE {{l/sub\|DATABASE}}		* <code>CREATE {{l/sub\|DATABASE}}</code> (or <code>SCHEMA</code>)
	* CREATE {{l/sub\|TABLE}}		* <code>CREATE {{l/sub\|TABLE}}</code>
	* CREATE {{l/sub\|VIEW}} (create or replace)		* <code>CREATE {{l/sub\|VIEW}}</code> (create or replace)
	* CREATE {{l/sub\|CATALOG}}		* <code>CREATE {{l/sub\|CATALOG}}</code>
	* CREATE {{l/sub\|USER}}		* <code>CREATE {{l/sub\|USER}}</code>
	* CREATE {{l/sub\|TRIGGER}}		* <code>CREATE {{l/sub\|TRIGGER}}</code>
	* CREATE {{l/sub\|EVENT}}		* <code>CREATE {{l/sub\|EVENT}}</code>
	* CREATE {{l/sub\|FUNCTION}}		* <code>CREATE {{l/sub\|FUNCTION}}</code>
	* CREATE {{l/sub\|FUNCTION UDF}} - user-defined function		* <code>CREATE {{l/sub\|FUNCTION UDF}}</code> - user-defined function
	* CREATE {{l/sub\|INDEX}}		* <code>CREATE {{l/sub\|INDEX}}</code>
	* CREATE {{l/sub\|PACKAGE}}		* <code>CREATE {{l/sub\|PACKAGE}}</code>
	* CREATE {{l/sub\|PACKAGE BODY}}		* <code>CREATE {{l/sub\|PACKAGE BODY}}</code>
	* CREATE {{l/sub\|PROCEDURE}}		* <code>CREATE {{l/sub\|PROCEDURE}}</code>
	* CREATE {{l/sub\|ROLE}}		* <code>CREATE {{l/sub\|ROLE}}</code>
	* CREATE {{l/sub\|SEQUENCE}}		* <code>CREATE {{l/sub\|SEQUENCE}}</code>
	* CREATE {{l/sub\|SERVER}}		* <code>CREATE {{l/sub\|SERVER}}</code>

Woozle at 22:11, 18 February 2025

2025-02-18T22:11:59Z

@@ 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''': <code>'roundcube@localhost'</code> is not the same user as <code>'roundcube'@localhost</code>. The latter creates user 'roundcube' with '@localhost' stored in another field, from what I can tell.
+* [https://mariadb.com/kb/en/create/ MariaDB Knowledge Base]
-** '''Note''': 'password' and "password" are not necessarily identical. At least once, I got an error with 'password' but "password" was fine. The password in question ended with a '^' character, so maybe that was escaping the end-quote-mark or something?
+==Syntax==

Woozle at 19:11, 16 February 2025

2025-02-16T19:11:54Z

← Older revision		Revision as of 19:11, 16 February 2025
Line 3:		Line 3:
	==Example==		==Example==
	* <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>		* <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>
	** '''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.~~		** '''Note''': <code>'roundcube@localhost'</code> is not the same user as <code>'roundcube'@localhost</code>. The latter creates user 'roundcube' with '@localhost' stored in another field, from what I can tell.
			** '''Note''': 'password' and "password" are not necessarily identical. At least once, I got an error with 'password' but "password" was fine. The password in question ended with a '^' character, so maybe that was escaping the end-quote-mark or something?

Woozle at 18:45, 16 February 2025

2025-02-16T18:45:47Z

← Older revision		Revision as of 18:45, 16 February 2025
Line 3:		Line 3:
	==Example==		==Example==
	* <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>		* <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>
			** '''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.

Woozle at 18:38, 16 February 2025

2025-02-16T18:38:40Z

← Older revision		Revision as of 18:38, 16 February 2025
Line 1:		Line 1:
			==Related==
			* <code>{{l/same\|DROP}}</code> deletes existing users
	==Example==		==Example==
	* <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>		* <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>

Woozle: Created page with "==Example== * CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';"

2025-02-16T18:30:56Z

Created page with "==Example== * <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>"

New page

==Example==
* <syntaxhighlight inline lang=SQL>CREATE USER 'roundcube'@localhost IDENTIFIED BY 'yourPasswordHere!';</syntaxhighlight>

← Older revision		Revision as of 22:19, 18 February 2025
Line 5:		Line 5:
	* [https://mariadb.com/kb/en/create/ MariaDB Knowledge Base]		* [https://mariadb.com/kb/en/create/ MariaDB Knowledge Base]
	==Syntax==		==Syntax==
	* CREATE {{l/sub\|DATABASE}}		* <code>CREATE {{l/sub\|DATABASE}}</code> (or <code>SCHEMA</code>)
	* CREATE {{l/sub\|TABLE}}		* <code>CREATE {{l/sub\|TABLE}}</code>
	* CREATE {{l/sub\|VIEW}} (create or replace)		* <code>CREATE {{l/sub\|VIEW}}</code> (create or replace)
	* CREATE {{l/sub\|CATALOG}}		* <code>CREATE {{l/sub\|CATALOG}}</code>
	* CREATE {{l/sub\|USER}}		* <code>CREATE {{l/sub\|USER}}</code>
	* CREATE {{l/sub\|TRIGGER}}		* <code>CREATE {{l/sub\|TRIGGER}}</code>
	* CREATE {{l/sub\|EVENT}}		* <code>CREATE {{l/sub\|EVENT}}</code>
	* CREATE {{l/sub\|FUNCTION}}		* <code>CREATE {{l/sub\|FUNCTION}}</code>
	* CREATE {{l/sub\|FUNCTION UDF}} - user-defined function		* <code>CREATE {{l/sub\|FUNCTION UDF}}</code> - user-defined function
	* CREATE {{l/sub\|INDEX}}		* <code>CREATE {{l/sub\|INDEX}}</code>
	* CREATE {{l/sub\|PACKAGE}}		* <code>CREATE {{l/sub\|PACKAGE}}</code>
	* CREATE {{l/sub\|PACKAGE BODY}}		* <code>CREATE {{l/sub\|PACKAGE BODY}}</code>
	* CREATE {{l/sub\|PROCEDURE}}		* <code>CREATE {{l/sub\|PROCEDURE}}</code>
	* CREATE {{l/sub\|ROLE}}		* <code>CREATE {{l/sub\|ROLE}}</code>
	* CREATE {{l/sub\|SEQUENCE}}		* <code>CREATE {{l/sub\|SEQUENCE}}</code>
	* CREATE {{l/sub\|SERVER}}		* <code>CREATE {{l/sub\|SERVER}}</code>