Re: editing database data from arduino

[Charles Bell]

Hi. Allow me to give you an example.

char buf[128];
int count;

// Open serial communications and wait for port to open:
Serial.begin(115200);
while (!Serial) {
; // wait for serial port to connect. Needed for Leonardo only
}
Serial.println("Hello. Demo string replacement.");
count = 125;
sprintf(buf, "UPDATE test_arduino.variable SET 'test' ='%d' WHERE inventory_id ='5'", count);
Serial.println(buf);

Output:

Hello. Demo string replacement.
UPDATE test_arduino.variable SET 'test' ='125' WHERE inventory_id ='5'


You can also examine the Strings-StringReplace example sketch for more clues.