MySQL

How-tos How to MySQL Convert String to Lowercase Learn how to convert strings to lowercase in MySQL using the LOWER() function. This article covers various methods, including updating columns and performing case-insensitive … ↗ How-tos Count Rows in MySQL with MySQLi Learn how SQL COUNT(*) and COUNT(column) differ, how WHERE and GROUP BY shape row counts, and how to retrieve a count with PHP MySQLi. ↗ How-tos How to Implement Flush Privileges in MySQL This tutorial explains how FLUSH PRIVILEGES reloads existing grant data after relevant grant-table changes, without creating or changing permissions. ↗ How-tos How to Copy Database in MySQL This article introduces how to copy MySQL database. ↗ How-tos How to Revoke Privileges in MySQL Learn how to revoke specific MySQL privileges, understand account and object scope, remove broad grants or grant options, and inspect an account's grants afterward. ↗ How-tos Difference Between Two Tables in MySQL Find selected row values that occur in only one of two MySQL tables. ↗ How-tos Intersect Operator in MySQL Learn what the INTERSECT operator returns and how to emulate it in MySQL with INNER JOIN, IN, and EXISTS. ↗ How-tos How to Set Timezone in MySQL Learn how to check MySQL time-zone settings and choose a persistent server default, a runtime global value, or a session value. ↗ How-tos Greater Than Date in MySQL Learn how to filter MySQL rows whose date is later than a supplied date, including the strict boundary behavior of DATE and DATETIME comparisons. ↗ How-tos MySQL COUNT IF Method Learn how COUNT() and IF() combine to count matching rows and distinct values in MySQL. ↗ How-tos How to INSERT IF NOT EXISTS in MySQL Learn how to insert a row in MySQL only when no row matches your chosen duplicate rule. ↗ How-tos How to Reset Auto Increment in MySQL This tutorial demonstrates how to reset auto increment in MySQL. ↗ How-tos How to Change the max_allowed_packet Size in the MySQL Server Learn how to check and change the MySQL max_allowed_packet setting temporarily or persistently on Windows and Ubuntu. ↗ How-tos How to Generate Random Strings in MySQL Learn how to combine MySQL functions to generate short strings and assess their randomness and uniqueness. ↗ How-tos How to Clear the Screen in MySQL The main aim of this topic is to demonstrate how to clear the screen of the MySQL console. We also have a look at how to clear console in the different operating systems. ↗ How-tos How to Pivot Table in MySQL Learn fixed and dynamic ways to pivot rows into columns in MySQL. ↗ How-tos How to Calculate Percentage in MySQL Learn how to calculate a row's share of a total, a ratio between two columns, and grouped shares in MySQL. ↗ How-tos How to Group the Datetime Column by Date Only in MySQL Group MySQL DATETIME values by calendar date and count attendance rows with DATE() and GROUP BY. ↗ How-tos How to Export MySQL Database Using Mysqldump We will learn about how to export MySQL database using mysqldump command-line utility. We will also learn how to export tables from a particular database. ↗ How-tos How to Show the Current Database in MySQL Check the database selected for your MySQL session with SELECT DATABASE(), MySQL Workbench, or the interactive mysql client. Learn what NULL means and how to select a database. ↗ How-tos Difference Between VARCHAR and TEXT in MySQL Compare MySQL VARCHAR and TEXT by expected values, declared length, storage considerations, and query needs, then choose a suitable column type. ↗ How-tos How to Get the Size of MySQL Database This tutorial demonstrates how to find the size of a MySQL database. ↗ How-tos How to Create New Database in MySQL Workbench This tutorial guides you about how can you create a new database using GUI options and SQL query in MySQL Workbench. ↗ How-tos How to Search Occurrences of String in MySQL Database This tutorial guides you on how you can search a complete database to find the occurrences of a pattern or string in MySQL Workbench and phpMyAdmin. ↗