| 商家名称 | 信用等级 | 购买信息 | 订购本书 |
 |
 |
Mastering phpMyAdmin 3.4 for Effective MySQL Management |  |
 |
|
Mastering phpMyAdmin 3.4 for Effective MySQL Management | |
网友对Mastering phpMyAdmin 3.4 for Effective MySQL Management的评论
I am new to phpMyAdmin and MySQL; however, I do have a background in developing MS Access databases and using SQL and VBA. Bottom line, this book was well written and the presentation of the code was easy for me to follow and use. Whether you are a beginner or seasoned programmer, you can gain an excellent understanding of how phpMyAdmiin and MySQL works.
Extremely satisfied with the product and the seller.
IT'S GOOD IDEA TO HAVE THIS ON YOUR BOOKSELVE AS A REFERENCE, AS A DBA WE SHOULD MASTERING QUERY TECHNIQUE WITH COMMAND LINE , HOWEVER THIS BOOK ALSO A GOOD REFERENCE THAT HELP YOU TO UNDERSTAND HOW IT WORKS THROUGH GRAPHICAL USER INTERFACE , THE FIRST 60 PAGES ARE UNCLEAR , LACK OF INFORMATION AND TECHNICAL DETAILS, IF YOU'RE NEWBIE IN SQL THIS BOOK IS NOT FOR YOU BUT IF YOU'RE ALREADY KNOW CERTAIN LEVEL IN SQL IT WOULD HELP TO IMPROVE YOUR TECHNIQUE AND KNOWLEDGE.
phpMyAdmin exists for you to run a MySql database via PHP commands, but also by doing so thru a web interface. In part this is because the web page paradigm is so dominant. But also because MySql for all its power is rather awkward to directly deal with, unless you are already expert in it. Yes, I know that sounds a little circular, because it certainly is. Breaking out of that rough input impedance is why this book teaches phpMyAdmin.
There are many general purpose settings that you can configure. Chapter 3 walks through the most important of these. You also need to learn the syntax of the directives that control the settings. The notation is not the most concise, but at least as evidenced by the book's examples, it can be fairly self documenting. Speaking of general settings, one of the nicest is surely the ability to pick your language. The labels and other online help have been i18n to the major languages.
But perhaps the most common administration activities you'll need relate to editing and deleting data in a table - or rather, in a subset of a table. Typically this will be in a single row. Then multiple rows. The text shows that this is straightforward. More complex tasks are possible - like changing the structure of an existing table. A common operation is to add a column and edit its attributes. Via phpMyAdmin, all this is possible.
Note that the author assumes that you are already versed in the theory of relational databases and in the syntax of SQL. Given this, you can treat the entire text as a nice GUI front end to avoid as much as possible a direct editing of SQL commands. The GUI makes it easier and less error prone.
The text also roams into ancillary topics that are not strictly SQL, but which are largely unavoidable. There is a brief walkthrough of XML, LaTex, CSV and PDF. As a database administrator, you may well run into these, when gathering input data into your MySql tables.
But perhaps the nicest features are in Chapter 12, which deals with advanced issues of multi-table queries. You can make automatic joins. And there is a visual builder tool that provides a very intuitive means of making a long query.
喜欢Mastering phpMyAdmin 3.4 for Effective MySQL Management请与您的朋友分享,由于版权原因，读书人网不提供图书下载服务
