MariaDB Connector

The high-performance MariaDB Connector provides read/write capabilities within your application, allowing you to perform numerous MariaDB operations with minimal coding or even no-coding at all. Integrate MariaDB data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download

Integrate MariaDB with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

SQL examples for MariaDB Connector

Use these example MariaDB SQL queries within SSIS, SQL Server or any ODBC-compatible application:

Get orders

This example query shows how to access the data by specifying the table name within the current database.

SELECT * FROM orders

Get order lines

This example query shows how to do a simple join on two tables.

SELECT 
    o.id, 
    ol.*
FROM orders o
JOIN order_lines ol 
  ON o.id = ol.order_id

Get product quantities for a specific order

This example query retrieves the product name and quantity for each line item belonging to order ID 12345.

SELECT
    ol.order_id,
    p.name AS product,
    ol.quantity
FROM order_lines ol
JOIN products p ON ol.product_id = p.id
WHERE ol.order_id = 12345

Reading data from a table with a space in its name

This example query shows how to query a table with a space inside its name.

-- Execute this query first to enable ANSI_QUOTES mode
SET SESSION sql_mode = CONCAT(@@SESSION.sql_mode, ',ANSI_QUOTES')

-- Then run the query
SELECT
    id,
    name
FROM `order lines`

Download