How about 'Everything You Must Know About MySQL'-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

How about 'Everything You Must Know About MySQL'

(*-*)浩

May 31, 2019 pm 04:40 PM

mysql

"Must Know MySQL" focuses on practicality and is highly operable. It is suitable for learning reference for the majority of software developers and database managers.

About the author

BenForta, a world-renowned technical writer, is also the most well-known in the Adobe technology community One of the experts, currently serves as a senior technical promotion expert at Adobe. He has more than 20 years of working experience in the computer industry and has written more than a dozen technical books over the years, including "Must Know and Must Know Regular Expressions", "Must Know and Must Know SQL" (published by People's Posts and Telecommunications Press) and other world-wide bestsellers , has been translated into more than a dozen languages.

Recommended courses: MySQL Tutorial.

Editor recommendation

As a representative of open source software, MySQL has become one of the most popular database management systems in the world.

"Must Know and Must Know MySQL" is written by the author at the request of many readers after the classic bestseller "Must Know and Must Know SQL", specifically for MySQL users. "Must Know MySQL Must Know" inherits the advantages of "Must Know SQL Must Know". It does not elaborate too much on the basic theory of database, but closely follows the actual needs. It starts directly from data retrieval and gradually deepens into various complex contents, including The use of joins, subqueries, regular expressions and full-text based searches, stored procedures, cursors, triggers, table constraints, and more. Through "MySQL Must Know, Must Know", readers can master solid basic skills and quickly become MySQL masters.

A new work by the author of "Must Know SQL", with a full five-star rating on Amazon, suitable for both study and reference.

"Must Know MySQL": A portable manual and introductory book for MySQL

Recommended for people who have no knowledge of MySQL to read it to establish basic concepts, and have almost the same knowledge about MySQL that I learned in college Those who have lost everything quickly regain the basics.

This book basically covers the knowledge points that you need to know about MySQL, but for each point it is mainly practical, explaining the basic usage, not going into the principles, but more giving a way.

I think this book is more like a panoramic map, allowing novices to have a bird's eye view of the whole situation, and at least know where to go in-depth when they have a certain problem.

The previous chapters are actually quite practical, but I think the advanced content chapters are too simple, and even the concepts and practical application scenarios are not well explained (but this is the positioning of this book itself) limitations), it is necessary to read some more in-depth books after the beginning of this chapter on stored procedures.

Due to checking for gaps in my own knowledge, I read and took notes on the chapters starting with Chapters 1 and 2, full-text search, and view. On the one hand, I basically understand the core part of SQL in the middle. On the other hand, I don’t know how to write “raw query” in actual coding now. It is more left to ORM to solve, so I didn’t take a closer look.

The above is the detailed content of How about 'Everything You Must Know About MySQL'. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How to Grant Permissions to New MySQL UsersMay 09, 2025 am 12:16 AM

TograntpermissionstonewMySQLusers,followthesesteps:1)AccessMySQLasauserwithsufficientprivileges,2)CreateanewuserwiththeCREATEUSERcommand,3)UsetheGRANTcommandtospecifypermissionslikeSELECT,INSERT,UPDATE,orALLPRIVILEGESonspecificdatabasesortables,and4)

How to Add Users in MySQL: A Step-by-Step GuideMay 09, 2025 am 12:14 AM

ToaddusersinMySQLeffectivelyandsecurely,followthesesteps:1)UsetheCREATEUSERstatementtoaddanewuser,specifyingthehostandastrongpassword.2)GrantnecessaryprivilegesusingtheGRANTstatement,adheringtotheprincipleofleastprivilege.3)Implementsecuritymeasuresl

MySQL: Adding a new user with complex permissionsMay 09, 2025 am 12:09 AM

ToaddanewuserwithcomplexpermissionsinMySQL,followthesesteps:1)CreatetheuserwithCREATEUSER'newuser'@'localhost'IDENTIFIEDBY'password';.2)Grantreadaccesstoalltablesin'mydatabase'withGRANTSELECTONmydatabase.TO'newuser'@'localhost';.3)Grantwriteaccessto'

MySQL: String Data Types and CollationsMay 09, 2025 am 12:08 AM

The string data types in MySQL include CHAR, VARCHAR, BINARY, VARBINARY, BLOB, and TEXT. The collations determine the comparison and sorting of strings. 1.CHAR is suitable for fixed-length strings, VARCHAR is suitable for variable-length strings. 2.BINARY and VARBINARY are used for binary data, and BLOB and TEXT are used for large object data. 3. Sorting rules such as utf8mb4_unicode_ci ignores upper and lower case and is suitable for user names; utf8mb4_bin is case sensitive and is suitable for fields that require precise comparison.

MySQL: What length should I use for VARCHARs?May 09, 2025 am 12:06 AM

The best MySQLVARCHAR column length selection should be based on data analysis, consider future growth, evaluate performance impacts, and character set requirements. 1) Analyze the data to determine typical lengths; 2) Reserve future expansion space; 3) Pay attention to the impact of large lengths on performance; 4) Consider the impact of character sets on storage. Through these steps, the efficiency and scalability of the database can be optimized.

MySQL BLOB : are there any limits?May 08, 2025 am 12:22 AM

MySQLBLOBshavelimits:TINYBLOB(255bytes),BLOB(65,535bytes),MEDIUMBLOB(16,777,215bytes),andLONGBLOB(4,294,967,295bytes).TouseBLOBseffectively:1)ConsiderperformanceimpactsandstorelargeBLOBsexternally;2)Managebackupsandreplicationcarefully;3)Usepathsinst

MySQL : What are the best tools to automate users creation?May 08, 2025 am 12:22 AM

The best tools and technologies for automating the creation of users in MySQL include: 1. MySQLWorkbench, suitable for small to medium-sized environments, easy to use but high resource consumption; 2. Ansible, suitable for multi-server environments, simple but steep learning curve; 3. Custom Python scripts, flexible but need to ensure script security; 4. Puppet and Chef, suitable for large-scale environments, complex but scalable. Scale, learning curve and integration needs should be considered when choosing.

MySQL: Can I search inside a blob?May 08, 2025 am 12:20 AM

Yes,youcansearchinsideaBLOBinMySQLusingspecifictechniques.1)ConverttheBLOBtoaUTF-8stringwithCONVERTfunctionandsearchusingLIKE.2)ForcompressedBLOBs,useUNCOMPRESSbeforeconversion.3)Considerperformanceimpactsanddataencoding.4)Forcomplexdata,externalproc

See all articles