MySQL

How-tos How to Reset the MySQL Root Password in Ubuntu This tutorial demonstrates how to reset the MySQL root password in Ubuntu when we forgot it and we cannot set a root password. ↗ How-tos How to Insert Timestamp Into a MySQL Table This tutorial demonstrates different approaches to insert timestamp into a MySQL table depending on table definition. ↗ How-tos How to Convert From Datetime Type to Date Only in MySQL This tutorial demonstrates the use of DATE(), CAST(), CONVERT(), and DATE_FORMAT() to convert from datetime type to date type in MySQL. ↗ How-tos How to Use, Benefits, and Alternative of the Zerofill in MySQL This tutorial educates about the use of zerofill in MySQL and its benefits. It also highlights the use of the zerofill attribute's alternative function. ↗ How-tos How to Append Strings to an Existing Field in MySQL This tutorial educates how we can use CONCAT() and CONCAT_WS() to append strings to an existing field in MySQL. ↗ How-tos How to Process Form Data With Mysqli_real_escape_string This article teaches you how to process form data using mysqli_real_escape_string. We'll set up a local server, create the database and a table. Afterward, you'll learn how to … ↗ How-tos How to Enable Slow Query Log in MySQL This tutorial demonstrates how to enable slow query log in MySQL using Windows and Ubuntu. ↗ How-tos How to Use Mysqldump Gzip to Create a Compressed File for a MySQL Database This tutorial educates about using mysqldump gzip and crontab to create a compressed backup file for a MySQL database. ↗ How-tos How to Generate Random and Unique Strings in MySQL This tutorial demonstrates how to generate random and unique strings 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 Change MySQL Root Password on Mac This article teaches you how to change the MySQL root user password on OSX. We'll use XAMPP, so you can change the password using the MySQL console. ↗ 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 MySQL Check if Column Is Null or Empty This article introduces how check if a column is null or empty in MySQL. ↗ How-tos How to Open MySQL Using Mac Terminal This article will teach you how to open MySQL using a Mac terminal. We'll show you how to do this on macOS Catalina and later. And also, macOS Mojave and earlier. ↗ How-tos How to Use CURRENT_TIMESTAMP as Default in MySQL This article teaches you how to use CURRENT_TIMESTAMP as DEFAULT in MySQL versions less than 5.6.5. As a result, you can prevent MySQL Error 1293. Our methods include reordering … ↗ How-tos How to Create Table Alias With MySQL VIEW and MERGE This article will teach you how to create a table alias using MySQL VIEW and MERGE. In both cases, changes in the original table will reflect in the aliased table. Also, the … ↗ How-tos How to Sort MySQL Data in Alphabetical Order This tutorial demonstrates how to sort data in a MySQL server in alphabetical order. ↗ How-tos How to Show Foreign Keys in MySQL This tutorial demonstrates how to showcase the foreign keys of a table and a column in MySQL. ↗ 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 Calculate Average of a Table Column in MySQL This tutorial demonstrates how to calculate the average of a column in MySQL. ↗ How-tos How to Select Multiple Values Using WHERE in MySQL This article will discuss using the WHERE clause in SQL queries. Moreover, it will discuss different methods for selecting multiple values using the WHERE clause. ↗ How-tos How to Use PHP MySQLi Function to Fetch Last Inserted ID This tutorial demonstrates how to fetch the last insert id from the MySQL database using PHP MySQLi function. ↗ How-tos How to Find Tables in MySQL With Specific Column Names in Them This tutorial demonstrates how to find tables from a schema with specific column names in MySQL. ↗ How-tos How to Convert Rows to Columns in MySQL This tutorial demonstrates how to convert or change rows to columns in MySQL. ↗