· 8 years ago · Jun 17, 2018, 09:52 AM
1CREATE TABLE IF NOT EXISTS `job_done` (
2 `x` float NOT NULL,
3 `y` float NOT NULL,
4 `z` float NOT NULL,
5 `hx` float NOT NULL,
6 `hy` float NOT NULL,
7 `hz` float NOT NULL,
8 `id` int(11) NOT NULL AUTO_INCREMENT,
9 PRIMARY KEY (`id`)
10) ENGINE=InnoDB AUTO_INCREMENT=68697503 DEFAULT CHARSET=utf8;
11
12
13SQL_Prepare(hDB, "INSERT INTO job_done (x, y, z, hx, hy, hz) VALUES (?, ?, ?, ?, ?, ?);");