更新时间：2021-06-30 19:24:04
coverpage
Title Page
Dedication
Packt Upsell
Why subscribe?
PacktPub.com
Contributors
About the author
About the reviewers
Packt is searching for authors like you
Preface
Who this book is for
What this book covers
To get the most out of this book
Conventions used
Sections
Getting ready
How to do it…
How it works…
There's more…
See also
Get in touch
Reviews
MySQL 8 - Installing and Upgrading
Introduction
Installing MySQL using YUM/APT
How to do it...
Using YUM repositories
Using APT repositories
Installing MySQL 8.0 using RPM or DEB files
Using the RPM bundle
Using the APT bundle
Installing MySQL on Linux using Generic Binaries
There's more...
Starting or Stopping MySQL 8
Starting the MySQL 8.0 server
Stopping the MySQL 8.0 server
Checking the status of the MySQL 8.0 server
Uninstalling MySQL 8
On YUM-based systems
On APT-based systems
Uninstalling Binaries
Managing the MySQL Server with systemd
Downgrading from MySQL 8.0
In-place Downgrades
Using APT Repositories
Using the RPM or APT bundle
Using Generic Binaries
Logical Downgrades
Using YUM Repositories
Using RPM or APT bundles
Upgrading to MySQL 8.0
In-place upgrades
YUM-based systems
APT-based systems
Logical Upgrades
Installing MySQL utilities
Using MySQL
Connecting to MySQL using the command-line client
Creating databases
Creating tables
Cloning table structure
Inserting updating and deleting rows
Inserting
Updating
Deleting
REPLACE INSERT ON DUPLICATE KEY UPDATE
Truncating tables
Loading sample data
Selecting data
Selecting columns
Count
Filter based on condition
