≡ Menu

MySQL

15 mysqlbinlog Command Examples for MySQL Binary Log Files

In MySQL or MariaDB, anytime you make a change to the database, that particular event is logged. For example, when you create a new table, or update data on an existing table, those events are stored in the binary logs. Binary log is very helpful in MySQL replication, where the main server will send the [...]

{ 1 comment }

Once you’ve installed and configured MySQL or MariaDB, the first step is to create a database. Only after creating a database, you can create tables and insert records. This tutorial explains the following examples that are used to create and manipulate a MySQL database: Create New MySQL Database Create MySQL DB with Specific Character Set [...]

{ 1 comment }

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 [...]

{ 1 comment }

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 [...]

{ 3 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 [...]

{ 7 comments }