Mysql/CheatSheet: Difference between revisions
< Mysql
(Leere Seite erstellt) |
No edit summary |
||
| Line 1: | Line 1: | ||
== Databases == | |||
* Create | |||
<blockquote> | |||
<pre> | |||
CREATE DATABASE [IF NOT EXISTS] database_name; | |||
</pre> | |||
</blockquote> | |||
* Use | |||
<blockquote> | |||
<pre> | |||
USE database_name; | |||
</pre> | |||
</blockquote> | |||
* Delete | |||
<blockquote> | |||
<pre> | |||
DROP DATABASE [IF EXISTS] database_name; | |||
</pre> | |||
</blockquote> | |||
* List all | |||
<blockquote> | |||
<pre> | |||
SHOW DATABASE; | |||
</pre> | |||
</blockquote> | |||
== other == | |||
<blockquote> | |||
<pre> | |||
</pre> | |||
</blockquote> | |||
<blockquote> | |||
<pre> | |||
</pre> | |||
</blockquote> | |||
<blockquote> | |||
<pre> | |||
</pre> | |||
</blockquote> | |||
Revision as of 12:51, 10 June 2020
Databases
- Create
CREATE DATABASE [IF NOT EXISTS] database_name;
- Use
USE database_name;
- Delete
DROP DATABASE [IF EXISTS] database_name;
- List all
SHOW DATABASE;