I’ve just lost 10 seconds of my life to find out how to create views in phpmyadmin and it was pretty simple.

Just do some query or search something from your database. You should now have some sql query. Now take a look down there bellow. You should see create view. Go for it. Enter the view name and enter the columns. Go. Now you have your create view table. Refresh localhost databases. Your table should be there added bellow other tables.

That’s it.