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 [...]
MySQL
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
My name is Ramesh Natarajan. I will be posting instruction guides, how-to, troubleshooting tips and tricks on Linux, database, hardware, security and web. My focus is to write articles that will either teach you or help you resolve a problem. Read more about