linux howto's for Server System Administrations

Adminer – A Full-Featured MySQL Database Management Tool

Formerly phpMyAdmin, Adminer is a front-end database management tool written in PHP. Unlike phpMyAdmin, it only comprises a single PHP file that can be downloaded on the target server on …

MariaDB

How to Install MariaDB in RHEL and Debian Systems

MariaDB is a binary drop-in replacement for MySQL, developed by the original authors of MySQL Project and fully compatible with MySQL having more features and better performance enhancement. Why should …

MariaDB / MySQL / Top Tools

8 Best MySQL/MariaDB GUI Tools for Linux Administrators

MySQL is one of the most widely-used open-source relational database management systems (RDBMS), that has been around for a long time. It is an advanced, fast, reliable, scalable, and easy-to-use …

Database / Linux / MariaDB / MySQL / MySQL Commands / ORDER BY Clause / Order Data / PHP / PHP MySQL / PROGRAMMING / XAMPP

PHP MySQL ORDER BY Clause

This guide describes how to select data from a MySQL database table and sort the data by a specific column in ascending or descending order with ORDER BY clause using …

Database / Delete Rows / Drop Table / Linux / MariaDB / MySQL / MySQL Commands / PHP / PHP MySQL / Phpmyadmin / PROGRAMMING / Truncate Table / XAMPP

PHP MySQL DELETE, TRUNCATE, DROP Table

In this guide, we will discuss how to perform DELETE, TRUNCATE, And DROP operations on a MySQL database table using PHP in XAMPP in Linux. Before getting into the topic, …

Database / Linux / MariaDB / MySQL / MySQL Logical Operators / MySQL Operators / PHP / PHP MySQL / PROGRAMMING / Uncategorized / XAMPP

PHP MySQL Logical Operators

This tutorial explains how to select data from a database using WHERE clause and SELECT query with MySQL logical operators such as BETWEEN, IN, AND, OR etc., in PHP. We …

Database / Linux / MariaDB / MySQL / MySQL LIKE Operator / PHP / PHP MySQL / PROGRAMMING / WHERE Clause / XAMPP

PHP MySQL LIKE Operator

In this guide, we will discuss how to select data from a table using MySQL LIKE operator and WHERE clause along with the SELECT command in a particular database using …

Database / Linux / MariaDB / MySQL / PHP / PHP MySQL / PROGRAMMING / XAMPP

PHP MySQL WHERE Clause

In this guide, we will discuss how to select the records from a MySQL database based on specific conditions with the WHERE clause and the SELECT command using PHP in …

Code / Database / Linux / MacOS / MariaDB / MySQL / MySQL Commands / PHP / PHP Code / PHP MySQL / PHP MySQL Select Query / Phpmyadmin / PROGRAMMING / Select data from MySQL database / SELECT Query / Windows / XAMPP

PHP MySQL Select Data

This tutorial walks you through the steps to select data in a table from a MySQL database using PHP in XAMPP stack. Prerequisites Make sure you have set up the …

Code / Database / Insert Data In MySQL / Insert Records / LAMP Stack / LEMP Stack / Linux / MacOS / MariaDB / MySQL / MySQL Commands / PHP / PHP MySQL / Phpmyadmin / PROGRAMMING / Windows / XAMPP

How To Insert Data In MySQL Database Using PHP In XAMPP

After creating a MySQL database and table, we can start inserting the data (i.e. records) in them. In this tutorial, we are going to learn how to insert data in …

Category: MariaDB