I was wondering if somebody could give me some information about views. I did various searches and have gotten things from they are great - and make your life easier, to they are the devil and avoid them. I created a view and it was pretty nice when I can do a simply select and it takes one line. The query i made into a view was around 5 or 6. However I forgot a field and had to delete - remake the view.

Also can somebody give me information on the different options you get after clicking make view in phpMyAdmin? While view name is kind of a given - I don't know what the others do. Between searches and in the irc channel for 12 hours, I didn't get any answers.