MySQL

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. ↗ How-tos How to Update Multiple Tables With One Query in MySQL This article introduces how to update multiple tables with one query in MySQL. ↗ How-tos How to Sort MySQL Data in Alphabetical Order Learn how to sort MySQL rows by a text column in ascending or descending alphabetical order. ↗ How-tos How to Check if String Contains Certain Data in MySQL This tutorial demonstrates how to check whether a string contains a certain data or substring in a MySQL table. ↗ How-tos How to Split String in MySQL This tutorial demonstrates how to split a string in a MySQL database effectively. Learn various methods, including the SUBSTRING_INDEX function and JSON functions, to manipulate … ↗ How-tos How to Connect to a MySQL Database Using JDBC Build a MySQL JDBC connection URL and use Java with MySQL Connector/J to connect, check the connection, and close resources. ↗ How-tos How to Access MySQL Command Line With XAMPP Connect to XAMPP's MySQL-compatible server from the command line, create a target database, and import an SQL file into it. ↗