Examples

This page presents documentation on how to start using the connector in your sketches. You will see helpful, brief introductions to the more commonly used example sketches as well as how to implement common solutions.

Example Sketches

The following are some of the more popular example sketches available with the connector. The following shows the complete list of example sketches. Be sure to start with one of these as you start using the connector. It is recommended you start with the first one named connect.ino.

You can find these examples sketches under the File | Examples | MySQL Connector Arduino menu.

Hello, MySQL! (connect.ino)

Connect by Hostname (connect_by_hostname.ino)

Basic Insert (basic_insert.ino)

Complex Insert (complex_insert.ino)

Basic Select (basic_select.ino)

Complex Select (complex_select.ino)

Connect with WiFi (connect_wifi.ino)

Common Solutions

The following are code fragments and suggestions for solving some of the more common problems working with MySQL, data, and the connector.

Replacing Values in SQL Commands for Variables

Storing FLoating Point Values

Inserting Multiple Rows in a Single Query

Recording Datetime for a Row

Using a Lookup Table

Retriving a Field Value in a Variable

Preventing Dropped Connections

Using PROGMEM for Query Strings (SQL)

Connect/Reconnect

Reboot