Creating a MySQL View directly in phpMyAdmin

It's simple really; create, run, and verify the SQL SELECT statement that generates the results of the view you're looking to create, and then use that to create the view.

After executing the query in SQL :

In the very bottom right corner of the result is a link for creating the view!

You will have to supply:

VIEW name
Column names - a comma delimited list of the names to use for each column in the view

Once you're done, click the Go button to create the view!

OR in sqlyog type :

create view as test select * from categories