Practical solutions

MySQL Howtos How-To Guides

Solve the problem. Keep building. Collection of MySQL how-to articles

Find the answer you need

Browse practical solutions, grouped by the task you're working on.

__COUNT__ entries on this page

MySQL VariableHow to Declare and Use Variables in MySQLLearn when to use MySQL session variables, local DECLARE variables, or system variables, with SET, SELECT ... INTO, scope rules, and tested examples. MySQL TableHow to Truncate All Tables in MysqlIn 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 quickly. Understand the implications and best practices for truncating tables in MySQL. MySQL LogTransaction Log in MySQLThis 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 code examples and detailed explanations. Enhance your database management skills by understanding how to monitor and maintain transaction integrity effectively. MySQL RestartHow to Restart MySQL Server on WindowsThis 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 your MySQL server and resolve common issues with ease. Whether you're a developer or database administrator, this guide equips you with essential knowledge for efficient MySQL management. MySQL WorkbenchHow to View Tables in MySQL WorkbenchDiscover 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 beginner or an experienced developer, this article provides essential tips and techniques to enhance your database management skills. MySQL LowercaseHow to MySQL Convert String to LowercaseLearn how to convert strings to lowercase in MySQL using the LOWER() function. This article covers various methods, including updating columns and performing case-insensitive searches. Discover practical examples and enhance your database management skills today! MySQL CountMySQLi count() FunctionDiscover the MySQLi count() function in PHP, a powerful tool for counting rows in a database result set. Learn how to use it effectively with practical examples, covering counting all rows, conditional counting, and using the SQL COUNT() function. This comprehensive guide is essential for both beginners and experienced developers looking to improve their database management skills. MySQL ServerHow to Start MySQL ServerThis 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 initiate your MySQL Server using command line tools and graphical interfaces like MySQL Workbench. Whether you're a beginner or experienced, this guide has you covered for effective database management. SQL ImageHow to Store Image in MySQL DatabaseThis tutorial demonstrates how to store images in a MySQL database using Python. Learn to create a database, insert images, and retrieve them effectively. Enhance your web applications with multimedia content management skills. MySQL ProcessHow to Kill a Process in MySQLThis tutorial demonstrates how to kill a process in a MySQL database. Learn to identify and terminate unresponsive processes effectively, ensuring optimal database performance. Discover command-line and MySQL Workbench methods to manage your database processes. MySQL IntegerHow to Cast as Integer in MySQLThis 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 better database management. Enhance your MySQL skills with clear examples and explanations, ensuring accurate data representation in your queries. MySQL NULLHow to Set Null in MySQLThis 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 enhance your database management skills with our comprehensive guide on handling null values in MySQL. MySQL TableHow to Count Table Rows in MySQLThis 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 effectively. Whether you are a beginner or an experienced developer, this guide will enhance your MySQL skills and enable you to manage your databases more efficiently. MySQL SleepThe Correct Way to Use MySQL SLEEP() CommandThis 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 queries and understand their behavior in various scenarios. Enhance your database management skills with practical examples and detailed explanations. MySQL PortPort Number in MySQLThis 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 command-line queries, and MySQL Workbench. Enhance your database management skills and troubleshoot connectivity issues effectively. MySQL FormatHow to Format Numbers in MySQLThis 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. Improve readability and user experience with clear, concise formatting techniques. MySQL ColumnIdentity Column in MySQLIn 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 database effectively. Discover practical examples and best practices to enhance your MySQL database design. MySQL PrivilegeHow to Revoke Privileges in MySQLLearn how to revoke privileges in MySQL effectively with our comprehensive guide. Understand the REVOKE command, manage user access, and enhance your database security. This article covers various methods to revoke privileges, ensuring you have the knowledge to maintain a secure and efficient database environment. MySQL LoopWhile Loop in MySQLThis 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 processing workflows with while loops. Whether you're updating records or performing calculations, this tutorial will enhance your MySQL skills and improve your database management efficiency. MySQLHow to Calculate the Median in MySQLLearn how to calculate the median in MySQL with our comprehensive guide. Discover SQL queries and user-defined functions to derive the median value from your datasets effectively. Enhance your database management skills with these practical solutions. MySQL QueryHow to Run MySQL Queries From the Command LineThis tutorial demonstrates how to run MySQL queries from the command line. Learn to access the MySQL shell, execute basic commands, and manipulate data efficiently. Perfect for beginners and experienced users alike, this guide will enhance your database management skills. MySQLDifference Between VARCHAR and TEXT in MySQLThis tutorial presents the difference between VARCHAR and TEXT in MySQL database, exploring their unique characteristics, storage methods, and performance implications. Learn when to use each data type effectively to optimize your database design and management. Whether you're a beginner or an experienced developer, understanding these differences will enhance your database skills. MySQL StringHow to Split String in MySQLThis 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 strings and extract valuable data. Enhance your MySQL skills with practical examples and clear explanations, making string handling straightforward and efficient. MySQL CHARDifference Between VARCHAR and CHAR in MySQLThis tutorial presents the differences between VARCHAR and CHAR in MySQL database. Learn how to choose the right data type for your applications based on performance, storage efficiency, and use cases. Explore the advantages and disadvantages of each type to optimize your MySQL database design.