MySQL 5 Development (Part 1) Tutorials
Introduction / Help on the MySQL Web Site
Subtitles of the Movie (MySQL 5 Development (Part 1) / Introduction / Help on the MySQL Web Site)
One of the most powerful and most overlooked features of the MySQL community website is the online documentation available for MySQL users. The developers of this website have provided a clever mechanism that makes looking up information in the online manuals a real pleasure; I know that you will find this to be useful. It is important to understand that this facility only works on the dev.MySQL.com site and not on the wwwdotMySQLdotcom website. When MySQL was its own company, and even during the years MySQL belonged to Sun Microsystems, much of this functionality was also available from the main website. But once Oracle acquired Sun and therefore MySQL, the MySQL website was split into the main and the community websites, housed on different equipment and otherwise separated to conform to some very strict rules Oracle has involving Internet access. The main issue was that Oracle had rules against having open access to its source code of its products as well as to alpha and beta versions in development. And yet MySQL is an open-source product and access to its source code and to prerelease versions is required as part of his very existence. Separating the Dev or community content from the main website was the answer. So in order to get to all the good stuff these days, we need to remember to go to the dev.MySQL.com site. I won't bother take you on a tour of that site, I'm sure you can find your way around to all of the obvious things, but perhaps the most beneficial aspect of this site isn't obvious at all, the powerful and streamlined navigation technique we can use to find information in the online documentation. So what is the syntax we use for these URL documentation queries? To put it briefly, we can simply add keywords and key phrases to the URL line of our browser immediately following the basic dev.MySQL.com URL. In general, the name of any command, any function, or any data type, should get a hit, although there are exceptions to this. And there are many other technologies and features such as dynamic system variables that also score a direct hit, you will figure out most of your favorites by experimenting with the site. If we get a hit, the technology added to the community Web server takes us immediately to the appropriate page in the documentation for the currently shipping version of MySQL. As of the recording of this lesson, Version 5.1 is still the official Generally Available or GA Release, but very soon that will become version 5.5 so what you see as a result a few months from now will differ from what I can demonstrate today. And if the keywords we enter do not identify a specific page in the manual, the website technology turns our keywords into a general search of documentation and shows us the results of that search sorted by relevance. Another click or two should usually be all that is required to get us where we want to go or we can perform other operations to refine our search. So let's see how this works, this will also give us a chance to see how nicely the documentation developers used hypertext to help us seek out related information in our initial queries as well. I will demonstrate all of this in the next lesson.
Tutorial Information
| Course: | MySQL 5 Development (Part 1) |
| Author: | David Swain |
| SKU: | 34225 |
| ISBN: | 1-936334-93-3 |
| Release Date: | 2011-05-27 |
| Duration: | 11 hrs / 129 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
