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 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. 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. MySQL QueryTruncated Incorrect Double Value in MySQLThis tutorial provides a comprehensive guide on how to fix the truncated incorrect double value error in MySQL. Learn effective methods, including checking data types, cleaning input data, and using proper SQL syntax to ensure your database operations run smoothly. Discover the common causes of this error and how to prevent it for a seamless MySQL experience. MySQL StringHow to Escape Single Quote in MySQLLearn how to escape single quotes in MySQL effectively with our comprehensive tutorial. Explore various methods like using backslashes, double single quotes, and prepared statements. Enhance your SQL skills and prevent errors and vulnerabilities in your database queries. Perfect for developers of all levels. MySQL QueryHow to Insert Date in MySQLThis tutorial demonstrates how to insert date in a MySQL table. Learn various methods to effectively manage date entries, including direct insertion, using functions, and inserting multiple dates at once. Get practical examples and clear explanations to enhance your database skills. MySQL VersionHow to Get Version in MySQLThis tutorial demonstrates how to quickly fetch the current version of MySQL. Learn various methods including command line, MySQL Workbench, and Python scripting to easily determine your MySQL version. This guide is perfect for developers and database administrators looking for efficient ways to manage their MySQL databases. MySQL CSVHow to Create Table From CSV in MySQLThis tutorial demonstrates how to create a table from a CSV file in MySQL database. Learn various methods including using MySQL commands, MySQL Workbench, and Python scripts to import your data efficiently. Enhance your database management skills and streamline your workflows with our step-by-step guide. MySQL ExportHow to Export Database in MySQL From the Command LineThis tutorial demonstrates how to export a MySQL database from the command line. Learn to use the mysqldump command effectively, explore options for exporting specific tables, and discover how to compress your backups for efficiency. Whether you're a beginner or an experienced user, this guide will help you manage your MySQL databases confidently and securely. MySQL DateMySQL Date SubtractThis article introduces how to subtract dates in MySQL using functions like DATE_SUB and DATEDIFF. Learn effective methods to manipulate date values, calculate differences, and improve your data management skills in MySQL. Discover practical examples and explanations to enhance your understanding of date subtraction techniques. MySQL VersionHow to Check MySQL Version in macOSThis tutorial demonstrates how to check the current version of MySQL server in macOS. Learn various methods, including using the Terminal, SQL commands, and MySQL Workbench, to easily determine your MySQL version. Whether you prefer command-line tools or graphical interfaces, this guide provides clear instructions and helpful tips for managing your MySQL environment effectively.