MySQL Database
Tags
Summary
Editor's review
The content follows a progressive structure. The first half lays the theoretical groundwork with basic database concepts, data models, and relational algebra, building a solid foundation for later practice. The second half focuses on concrete MySQL applications, covering database creation and management, table operations, data queries (SELECT statements and their various clauses), data updates, indexes, views, stored procedures, and triggers in detail. The book includes extensive example code and step-by-step instructions for readers to follow along.
As an introductory textbook, its strengths lie in clear structure, comprehensive coverage, and detailed explanations. It is particularly suitable as a course textbook for university programs or as a first MySQL guide for self-learners. It helps readers build an overall cognitive framework of database systems and MySQL technology. However, for readers who already have some foundation and wish to explore advanced MySQL features in depth—such as performance optimization, high-availability architecture, or the internals of the InnoDB storage engine—the book's depth may be somewhat insufficient.
Overall, this is a solid and well-structured introductory book. It does not pursue novelty or showmanship but is dedicated to building a correct and stable starting point of knowledge for readers. Through this book, readers can master the basic skills of using MySQL for everyday data management and processing, paving the way for further advancement to intermediate and advanced levels.
Who it's for
A good fit for
- University students majoring in computer science, software engineering, and related fields, as a course textbook or supplementary reading.
- Developers or data analysts planning a career change or new to the workplace who need to quickly master basic database operations and SQL.
- Complete self-learners interested in database technology who wish to study MySQL systematically from scratch.
- Non-technical professionals such as product managers and project managers who need to understand basic database concepts to support their work.
Not a good fit for
- Senior database engineers seeking advanced MySQL content such as performance tuning, cluster architecture, or source code analysis.
- Readers looking for a quick command-syntax reference or solutions to specific tricky problems; this book is oriented toward systematic learning rather than serving as a tool manual.
Reading tips
- Read the chapters in order and do not skip the theoretical foundation in the early part; it directly affects how deeply you understand the later practical work.
- Be sure to install a MySQL environment on your computer while reading and personally practice every example code and operation command in the book—this is key to learning database technology.
- After each chapter, try closing the book and designing small exercises on your own (such as creating a personal contacts table and performing CRUD operations) to reinforce what you have learned.
About the publisher
Chongqing University Press is a comprehensive university press whose publishing areas span social and cultural studies, industrial technology, finance and economics, medicine, social psychology, and theory. Judging from its catalog, the press publishes both academic works and popular science titles. Representative books include E. H. Gombrich's Shadows: The Depiction of Cast Shadows in Western Art, Magnesium-Based Hydrogen Storage Materials by Pan Fusheng et al., Research on China's Regional Spatial Development Models by Sun Jiuwen, and titles from the Gynecologic Oncology Committee of the Chinese Anti-Cancer Association, such as the Guidelines for Diagnosis and Treatment of Common Gynecologic Malignancies in China (2019) and Bipolar Disorder: What You and Your Family Need to Know. Its authors work in art history, materials science, regional economics, clinical medicine, and social research methods. Public information is limited, but its publishing profile combines academic translation, industrial technology, and practical medical guides.
Contents
- 版权信息
- 内容提要
- 前言
- 模块1 认识MySQL
- 任务1.1 什么是数据库
- 任务1.2 了解主流数据库
- 任务1.3 Windows下安装维护MySQL
- 任务1.4 使用MySQL Workbench数据库管理工具
- 任务1.5 Linux下安装维护MySQL
- 拓展阅读：国产数据库不畏艰险仍向前
- 思考题
- 模块2 创建和管理MySQL数据库与表
- 任务2.1 创建数据库
- 任务2.2 管理数据库
- 任务2.3 创建数据表
- 任务2.4 管理数据表
- 任务2.5 绘制E-R图
- 拓展阅读：国产数据库的春天来了
- 思考题
- 模块3 增、删、改MySQL记录
- 任务3.1 插入记录
- 任务3.2 修改与删除记录
- 拓展阅读：关于国产数据库TiDB
- 思考题
- 模块4 查询MySQL记录
- 任务4.1 创建单表基本查询
- 任务4.2 使用关键字查询
- 任务4.3 使用聚合函数和分组查询
- 任务4.4 应用系统内置函数查询
- 任务4.5 使用连接查询
- 任务4.6 创建子查询
- 拓展阅读：武汉达梦数据库（DM）
- 思考题
- 模块5 创建和管理MySQL索引与视图
- 任务5.1 创建索引
- 任务5.2 删除索引
- 任务5.3 创建视图
- 任务5.4 管理视图
- 拓展阅读：国产数据库OceanBase与SequoiaDB
- 思考题
- 模块6 创建和使用MySQL函数、存储过程和触发器
- 任务6.1 定义和使用变量
- 任务6.2 掌握SQL流程控制语句
- 任务6.3 创建和使用自定义函数
- 任务6.4 创建存储过程
- 任务6.5 创建和使用游标
- 任务6.6 创建和管理触发器
- 拓展阅读：数据库卡脖子的时代一去不复返了
- 思考题
- 模块7 管理MySQL用户
- 任务7.1 添加和删除用户
- 任务7.2 管理权限
- 拓展阅读：数据库 2025 趋势前瞻
- 思考题
- 参考文献
FAQ
Does this book require readers to have a programming background?
Is the MySQL version covered in this book outdated?
What level can I reach after finishing this book?
Comments
Find this book
This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.
About the author
Zeng Hong is an author about whom little public information is currently available; the name appears in Chinese book publishing data, with MySQL Database as the representative work. The book is catalogued under exam-oriented titles, suggesting that its content is designed for course study and test preparation, likely covering basic database concepts, SQL statements, table structure design, and common examination points for readers taking related exams or course assessments. Based on the available information, Zeng Hong's writing leans toward teaching support and introductory technology, emphasizing the organization of key knowledge points alongside practice rather than advanced topics for experienced developers. Because reliable records of birth and death dates, nationality, education, and professional experience are unavailable, no further biographical details can be given, and readers can only understand this author's approach to database teaching and exam preparation through this single work.
Hu Dehong: publicly available information is limited. Only one work is known under this name, MySQL Database, commonly classified under exam preparation. This suggests that the writing is aimed at study and teaching scenarios, likely covering database fundamentals, SQL syntax, and common exam points, with an emphasis on clear organization and easy review. Because the author's biography, nationality, and dates of birth and death are not recorded, it is difficult to outline any academic background or professional experience, or to judge long-term influence in the field. Based on the available material, readers may regard the author as someone involved in compiling computer textbooks for exam preparation, whose work mainly offers candidates systematic knowledge review and practice frameworks rather than original research or industry commentary.
Chen Weihua — public information about this author is limited. At present, only one work is known, MySQL Database, commonly classified under exam preparation. This suggests that the writing is likely aimed at test preparation and technical learning, covering database fundamentals, operational skills, and exercise practice, and that it belongs to the practical supplementary-teaching category. The title indicates content related to the use and maintenance of a relational database, with readers likely including students preparing for relevant exams or course assessments, as well as beginners seeking a quick introduction to database operations. Because biographical details, professional background, and further works are unavailable, it is difficult to judge the full range of the author's style or long-term influence in the field. The available material shows only that Chen Weihua took the author's role in compiling an exam-oriented database textbook, with the contribution mainly consisting of organizing MySQL-related knowledge into materials suited to learning and test preparation.
