Creating Views From Query Results.

[YoLoL]

I'm not sure if this has been mentioned in another forum/thread but I haven't been able to find it.

 

Since version 5.0.1. MySQL supports views among other things (as for this writting we have 5.0.45-community), the statement can be as simple as:

 

>CREATE VIEW myTCHuser_myDB.viewname AS SELECT * FROM myTable;

 

The CREATE VIEW statement creates a new view, or replaces an existing one if the OR REPLACE clause is given; if you want the full syntax you can check here:

 

http://dev.mysql.com/doc/refman/5.0/en/create-view.html

 

Also since version 2.11.0 (August 22, 2007) phpMyAdmin supports creating VIEWS from query results (you can find more on the project page: http://www.phpmyadmin.net/home_page/index.php) so far I have only been able to create it via the SQL script tab. If someone nows how to use the GUI for creating one please post it here

 

Hope you find this short post useful.