Hi
Just a question, as a total and absolute newbie and old grey hair to boot. I am hoping to learn a little about MySQL. I like the idea of managing my database(s) via a GUI front end and was recommended this one. I have downloaded the trial version and it looks fairly intuitive, clear and well laid out an it has impressed me so far. However, as a newbie I am unsure of how somethings work which, while no fault of the program, does make my learning a little difficult.
I have a book on MySQL but it is all command line and I am finding it difficult to translate across to the GUI front end. For example I want to create a view, my understanding of a view is to produce a 'Form' for the end user, but when I select this option on SQLyog I am presented with an SQL script
CREATE
/*[ALGORITHM = {Undefined | Merge |TEMPTABLE}]
[DEFINER = {iser ACURRENT_USER}]
[SQL SECURITY (DEFINER | INVOKER}] */
View 'test'.'Books'
AS
(Select * FROM …)
Can anyone help or tell me where I can find decent documentation or if the commercial versions come with documentation and help fileson how functions work?
Cheers
OldMike
