snipt

Ctrl+h for KB shortcuts
#18525

SQL

Alter Oracle Schema

ALTER SESSION SET CURRENT_SCHEMA=schema_chosen;
https://snipt.net/embed/e702e0b02c032b9f5e0865ada9d9266d/
https://snipt.net/raw/e702e0b02c032b9f5e0865ada9d9266d/
e702e0b02c032b9f5e0865ada9d9266d
sql
SQL
1
2014-04-15T18:43:22
True
False
/api/public/snipt/18525/
alter-oracle-schema
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a><span class="k">ALTER</span> <span class="k">SESSION</span> <span class="k">SET</span> <span class="n">CURRENT_SCHEMA</span><span class="o">=</span><span class="n">schema_chosen</span><span class="p">;</span> </span></pre></div> </td></tr></table>
oracle, schema
#6419

Bash

delete mysql schema

mysqladmin -u root -p drop <schema_name>
https://snipt.net/embed/09b508817215f659596df4ee26bedd31/
https://snipt.net/raw/09b508817215f659596df4ee26bedd31/
09b508817215f659596df4ee26bedd31
bash
Bash
1
2014-04-17T10:17:32
True
False
/api/public/snipt/6419/
delete-mysql-schema
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a>mysqladmin -u root -p drop &lt;schema_name&gt; </span></pre></div> </td></tr></table>
bash, delete, drop, mysql, schema
#6417

Bash

create mysql schema

mysqladmin -h <hostname> -u root -p create <schema_name>
https://snipt.net/embed/1d27c30542d8a4e037dae0d2c09c18e8/
https://snipt.net/raw/1d27c30542d8a4e037dae0d2c09c18e8/
1d27c30542d8a4e037dae0d2c09c18e8
bash
Bash
1
2014-04-13T14:31:06
True
False
/api/public/snipt/6417/
create-mysql-schema
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a>mysqladmin -h &lt;hostname&gt; -u root -p create &lt;schema_name&gt; </span></pre></div> </td></tr></table>
bash, create, database, mysql, schema