Your Title - phpmyadmin2019-03-20T23:09:17-03:00http://example.com/tag/phpmyadmin.htmlAuthor HereCreating Views on MySQL - Some Examples2014-03-22T07:13:14-03:00http://example.com/entries/creating-views-on-mysql-some-examples<h3 id="phpmyadmin">PHPMyAdmin</h3>
<p>To create a view on PHPMyAdmin, you must click the Create view button <strong>after you run a query</strong> you want to create a view of:</p>
<p><img src="http://queirozf.com/images/contents/J721O98.png" alt="phpmyadmin-create-view"></p>
<h3 id="mysql-console-command-line">MySQL console (command-line)</h3>
<p>After you log into mysql and use the <code>use</code> command to select your database, you can create a new view using the <code>CREATE VIEW</code> syntax. Here&#39;s an example:</p>
<div class="highlight"><pre><code class="language-" data-lang="">mysql&gt; CREATE VIEW my_view AS SELECT * FROM posts ;
</code></pre></div>
<p>Notice the semi-colon (<strong>;</strong>) at the end. Just run it as you would a normal SQL statement.</p>