Tag: "MySQL" (6)

Complete MySQL Commands Guide from Linux Terminal

Feb 12, 2026

While working on cloud server where PHPMyAdmin is not installed then using Linux terminal is the most efficient way to manage MySQL database and respective tables. These are the all...

MySQL columns total and show highest totals

Jan 10, 2025

To get the total of a MySQL field and then select the three highest totals from the table, you can use the following PHP script: Make sure to replace ‘your_username’, ‘your_password’,...

Import CSV data into MySQL using PHP

Nov 21, 2024

Here’s a detailed example of how to import data from a CSV file into a MySQL database using PHP. The script processes each row one by one, displays a...

Clean WordPress database infected with Malware

Jun 3, 2023

I just finished a new job to clean a WordPress website that was compromised with malicious codes. Removing the malicious codes from the theme files is easy, but the complex...

Delete users from WordPress database

May 30, 2023

I just finished a new job to clean a WordPress website that was compromised with malicious codes. While investigating I noticed that there were several unidentified admin users created on...

Covert all date data format from VARCHAR to DATE in any MySQL table

Jun 12, 2022

I am working on a project which was majorly developed by any otehr developer. My work is to update every module and add some functionality. This is a financial application...