One of the numerous significant changes to MySQL Server for version 8 includes a new component-based infrastructure. That will make the architecture more modular while allowing users to extend server capabilities through the addition of individual components.
Each component provides services that are available to the server as well as to other components. In fact, the server itself is now considered to be a component, equal to other components. Components interact with each other only through the services they provide.
In these turbulent times, encrypting your sensitive data only makes sense. The question is not so much whether to encrypt, but rather, which method of encryption to employ. There are several options, the three main widely used database encryption methods being:
In last week’s Getting Advanced Row Counts in MySQL (Part 2) blog we employed the native COUNT() function to tally unique values as well as those which satisfy a condition. In today’s final third instalment, we’ll learn how to obtain row counts from all of the tables within a database or entire schema.
In last week’s Getting Row Counts in MySQL blog we employed the native COUNT() function’s different variations to tally the number of rows within one MySQL table. In today’s follow-up, we’ll use the COUNT() function in more sophisticated ways to tally unique values as well as those which satisfy a condition.
There are several ways to get a row count in MySQL. Some database management products provide database statistics like table sizes, but it can also be done using straight SQL. In today’s tip, we’ll use the native COUNT() function to retrieve the number of rows within one table or view within a MySQL database. In part 2, we’ll learn how to obtain a row count from multiple tables, or even from all of the tables within a database.
- 2019 (1)
- 2018 (1)
- December (1)
- November (1)
- October (1)
- September (1)
- August (1)
- July (1)
- June (1)
- An Introduction to Database Events (Part 1)
- Manage MySQL Users in Navicat Premium - Part 4: The Privilege Manager tool (2)
- Manage MySQL Users in Navicat Premium - Part 4: The Privilege Manager tool
- Manage MySQL Users in Navicat Premium - Part 3: Configuring User Privileges
- Manage MySQL Users in Navicat Premium - Part 2: Creating a New User
- May (1)
- April (1)
- March (1)
- February (1)
- January (1)
- 2017 (1)
-
About Us
