CREATE TABLE IF NOT EXISTS candata(id FLOAT, timestamp FLOAT, yawrate VARCHAR(4), accy VARCHAR(4), rollrate VARCHAR(4), accx VARCHAR(4), accz VARCHAR(4), fueltemp VARCHAR(4), watertemp VARCHAR(4), oilpressure VARCHAR(4), oiltemp VARCHAR(4)) ENGINE = MEMORY

INSERT INTO candata (id, timestamp, yawrate, accy, rollrate, accx, accz, fueltemp, watertemp, oilpressure, oiltemp) VALUES (?,?,?,?,?,?,?,?,?,?,?)