MySQL Database

How-tos How to Show the Current Database in MySQL This tutorial demonstrates how to show the current database in MySQL using various methods like SELECT DATABASE and SHOW DATABASES commands. Whether you prefer command-line tools … ↗ How-tos Difference Between Schema and Database in MySQL This tutorial teaches you about Schema and Database, and the key differences between them. It also highlights what the schema and database are in MySQL and Oracle. ↗ How-tos How to Optimize Tables and Databases in MySQL This tutorial demonstrates how to optimize tables and databases in MySQL using Windows and Ubuntu operating systems. ↗ 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 Select Top N Rows in MySQL In this article, we will learn how to select top n rows in MySQL using LIMIT clause. We will also see how to select top n rows and top rows from m to n. ↗ How-tos How to Delete a Column From a Table in MySQL This tutorial demonstrates how to delete a column from a table in MySQL. ↗ How-tos How to Copy Database in MySQL This article introduces how to copy MySQL database. ↗ How-tos How to Copy Rows in the MySQL Database This tutorial demonstrates how to copy rows in the MySQL database. It explains by copying rows within the same table as well as from one table to another. ↗ How-tos How to Show Table and Database Structure in MySQL This tutorial demonstrates the use of the mysqldump utility, DESCRIBE, SHOW TABLES, and SHOW CREATE TABLE statements to show table and database structures in MySQL. ↗ How-tos How to Connect a Remote MySQL Database Using the Command Line This tutorial demonstrates how to connect a remote MySQL database using the command line. ↗ How-tos How to Find Value in a Set in MySQL Database This tutorial demonstrates how to check the occurrence of a value or find a value in a set in a MySQL database. ↗ How-tos How to Check if a Database Exists in MySQL In today's post, we'll learn how to check if a database exists in MySQL. ↗ How-tos Solutions to the Deprecated Mysql_connect in PHP This article will teach solutions to the deprecated mysql_connect in PHP. These solutions include mysqli_connect (procedural and OOP) and PHP Data Objects (PDO). ↗ How-tos Tiny Integer in MySQL This tutorial helps us understand about the concept of tiny integer in a MySQL database. ↗