Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from MySQL 8 Administrator???s Guide Effective guide to administering high-performance MySQL 8 solutions

Product type Paperback

Published in Feb 2018

Publisher Packt

ISBN-13 9781788395199

Length 510 pages

Edition 1st Edition

Languages

SQL

Tools

MySQL

Concepts

Database Administration

Authors (3):

Chintan Mehta

Hetal Oza

Subhash Shah

View More author details

Table of Contents (17) Chapters

Preface

1. An Introduction to MYSQL 8 FREE CHAPTER

2. Installing and Upgrading MySQL 8

3. MySQL 8 – Using Programs and Utilities

4. MySQL 8 Data Types

5. MySQL 8 Database Management

6. MySQL 8 Storage Engines

7. Indexing in MySQL 8

8. Replication in MySQL 8

9. Partitioning in MySQL 8

10. MySQL 8 – Scalability and High Availability

11. MySQL 8 – Security

12. Optimizing MySQL 8

13. Extending MySQL 8

14. MySQL 8 Best Practices and Benchmarking

15. Troubleshooting MySQL 8

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

MySQL 8 client errors

This section focuses on errors that occur on the MySQL 8 client. The job of a MySQL client is to connect to the MySQL server so as to execute the SQL queries and get the results from the MySQL 8 database. This section lists errors related to execution of the queries.

Case sensitivity in string searches

The string searches use the logical sequence of comparison operands for non-binary strings, such asCHAR, VARCHAR, and TEXT. The comparisons of binary strings, such as BINARY, VARBINARY, and BLOB use the numeric values of the bytes in the operands. It essentially means that the comparison will be case sensitive for the alphabetic characters.

The comparison of a non-binary string with a binary string will...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (3)

Mehta

Chintan Mehta is a co-founder of KNOWARTH Technologies and heads the cloud/RIMS/DevOps team. He has rich, progressive experience in server administration of Linux, AWS Cloud, DevOps, RIMS, and on open source technologies. He is also an AWS Certified Solutions Architect. Chintan has authored MySQL 8 for Big Data, Mastering Apache Solr 7.x, MySQL 8 Administrator's Guide, and Hadoop Backup and Recovery Solutions. Also, he has reviewed Liferay Portal Performance Best Practices and Building Serverless Web Applications.

See other products by Mehta

Oza

Hetal Oza an MCA from a reputable institute of India, is working as a lead consultant at KNOWARTH Technologies. She has rich experience in Java-based systems with various databases. Her 10 years of experience covers all stages of software development. She has worked on development of web-based software solutions on various platforms. She has good exposure to integration projects with web-service-based and thread-based architecture. Her knowledge is not bound to any single field because she has worked on wide range of technologies and tools.

See other products by Oza

Subhash Shah

Subhash Shah is an experienced solution architect. With 14 years of experience in software development, he works as an independent technical consultant now. He is an advocate of open source development and its utilization in solving critical business problems. His interests include Microservices architecture, Enterprise solutions, Machine Learning, Integrations and Databases. He is an admirer of quality code and test-driven development (TDD). His technical skills include translating business requirements into scalable architecture and designing sustainable solutions. He is a co-author of Hands-On High Performance with Spring 5, Hands-On AI for Banking and MySQL 8 Administrator's Guide. He has also been a technical reviewer for other books.

See other products by Subhash Shah