MySQL

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. ↗ How-tos Check Whether a Row Exists in MySQL with EXISTS and IF() Check whether a row matches a condition in MySQL with EXISTS, then use IF() to return a readable result. ↗ How-tos How to Import Excel File Into a MySQL Database Learn three ways to import Excel data into MySQL: convert it to CSV for LOAD DATA or phpMyAdmin, or convert the workbook with Sqlizer.io. ↗ How-tos How to Drop All Tables in MySQL Safely remove every base table from a MySQL database, handle foreign keys, and verify the result. ↗ How-tos How to Declare and Use Variables in MySQL Learn when to use MySQL session variables, local DECLARE variables, or system variables, with SET, SELECT ... INTO, scope rules, and tested examples. ↗ How-tos How to Truncate All Tables in Mysql In this tutorial, learn how to truncate all tables in MySQL efficiently. We explore various methods, including dynamic SQL and Python scripts, to help you reset your database … ↗ How-tos Transaction Log in MySQL This tutorial explains how to access the transaction log in a MySQL database using Python. Learn different methods, including MySQL Connector, SQLAlchemy, and MySQLdb, with clear … ↗ How-tos How to Restart MySQL Server on Windows This tutorial demonstrates how to restart MySQL server on Windows using various methods including command line, MySQL Workbench, and batch files. Learn effective steps to manage … ↗ How-tos How to View Tables in MySQL Workbench Discover how to view tables in MySQL Workbench with our comprehensive guide. Learn to access table structures, query data, and export information efficiently. Whether you are a … ↗ How-tos How to Start MySQL Server This tutorial provides a comprehensive guide on how to start MySQL Server across different operating systems, including Windows, macOS, and Linux. Learn step-by-step methods to … ↗ How-tos How to Kill a Process in MySQL This tutorial demonstrates how to kill a process in a MySQL database. Learn to identify and terminate unresponsive processes effectively, ensuring optimal database performance. … ↗ How-tos How to Cast as Integer in MySQL This tutorial demonstrates how to cast as an integer in MySQL using various methods like CAST, CONVERT, and arithmetic operations. Learn to convert data types effectively for … ↗ How-tos How to Set Null in MySQL This tutorial demonstrates how to set null values in MySQL, covering methods for inserting, updating, and using default null values. Learn to manage optional data effectively and … ↗ How-tos How to Count Table Rows in MySQL This tutorial demonstrates how to count rows in a MySQL table using various methods. Learn to use SELECT COUNT(*), WHERE clauses, GROUP BY, and COUNT DISTINCT to analyze your data … ↗ How-tos The Correct Way to Use MySQL SLEEP() Command This article will teach you two ways to use the MySQL SLEEP() command, including SLEEP() and DO SLEEP(). You'll learn how to implement these commands effectively in your SQL … ↗ How-tos Port Number in MySQL This tutorial demonstrates how to showcase the port number of MySQL. Learn various methods to find and verify the MySQL port number, including checking configuration files, using … ↗ How-tos How to Format Numbers in MySQL This tutorial demonstrates how to change the format of a number in MySQL. Learn various methods such as FORMAT(), ROUND(), CAST(), and CONCAT() to enhance your data presentation. … ↗ How-tos Identity Column in MySQL In this article, we explore the equivalent of an identity column in MySQL using the AUTO_INCREMENT feature. Learn how to create, insert, and manage unique identifiers in your … ↗ How-tos While Loop in MySQL This comprehensive guide covers the while loop in MySQL, explaining its syntax, use cases, and practical examples. Learn how to automate repetitive tasks and streamline your data … ↗