≡ Menu

MySQL

Starting from CentOS 7, you will not see a package called mysql-server in the yum repository. Now the package is called as mariadb-server. The original MySQL is now owned by Oracle corporation. But MariaDB is a fork of the original MySQL database. Just like the original MySQL, MariaDB is also open source, developed by open [...]

{ 0 comments }

3 Methods to Connect to MySQL from PHP using Example Code

To get most out of your MySQL database, it is important to understand how to connect from your custom PHP program to MySQL database. This tutorial explains the following three methods along with appropriate example PHP program, which will explain how to connect from your PHP to MySQL database. Connect using mysqli extension (Recommended) Connect [...]

{ 2 comments }

8 Steps to Install MirthConnect with MySQL / MariaDB on Linux

Mirth Connect is an Open Source Integration Engine that is primarily used in the Health Care domain. This support various health care standards (HL7, XML, EDI/X12, DICOM etc) that will help enterprise to integrate different systems, and let them talk to each other in a common language. MirthConnect interface engine also supports various standard protocols [...]

{ 0 comments }

If you have data in a text file, you can easily upload them to one or more tables in a database. In MySQL database (or MariaDB), using "load data infile" command, you can upload data from a text file to tables. The load data infile command provides several flexible options to load various formats of [...]

{ 1 comment }

10 Essential MariaDB / MySQL DELETE Command Examples

When you are working on MySQL database, on several situations you may want to delete existing records from one or more tables. In this tutorial, we'll explain how to use MySQL Delete with some useful examples. The following are covered in this tutorial: Delete a specific row Delete multiple rows (using number column matching) Delete [...]

{ 3 comments }

How to Connect to MySQL Database from Python With Example

From a Python program, you can connect to MySQL database to access the tables and manipulate your data. For this, you should use one of the Python MySQL Libraries. While there are few of these libraries available, the most popular and stable is mysql-connector-python library. The mysql-connector-python library uses APIs that are complaint with the [...]

{ 6 comments }

11 Essential MySQL Update Command Examples

One of the most common MySQL operation is to change an existing value of a record in a table. In this article, we’ll explain how to use MySQL update command along with some helpful examples. The following are covered in this tutorial: Update All Rows Update Only Selected Rows Update Column Value with Expression DEFAULT [...]

{ 0 comments }

By default MySQL database will be created under /var/lib/mysql directory. This might be Ok if you are running a small database that doesn’t take much space. But on production, for a larger database, you might not have enough space under root partition. In that case, you may want to move your MySQL database from root [...]

{ 8 comments }