MySQL

How-tos How to Install the MySQL Client in Linux This article introduces how to install the MySQL client in Linux. ↗ How-tos How to Cast to Decimal in MySQL This tutorial educates about how to cast to decimal in MySQL using CAST() and CONVERT() with the DECIMAL(M,D) function. ↗ How-tos How to Compare MySQL Timestamp Dates With the Date Parameter Only This tutorial demonstrates how we can compare MySQL timestamp dates with the date parameter only using the DATE(), CAST(), and CONVERT() functions. ↗ How-tos How to Change the Connection Timeout in MySQL This tutorial demonstrates how we can change the connection timeout in MySQL using Windows and Linux operating system. ↗ How-tos How to Get the ID of the Latest Inserted Record in MySQL This tutorial tackles about how to get the ID of the latest inserted record in MySQL. ↗ How-tos How to Turn Off Foreign Key Constraint in MySQL This tutorial educates how to turn off foreign key constraint in MySQL. ↗ 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 Add the Primary Key to a MySQL Table This tutorial demonstrates how to add the primary key to a MySQL table using CREATE TABLE and ALTER TABLE statements. ↗ How-tos How to Select the First Row From the MySQL Table This tutorial educates about how we can select the first row from a MySQL table. ↗ 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 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 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 Show Foreign Keys in MySQL This tutorial demonstrates how to showcase the foreign keys of a table and a column in MySQL. ↗