1:
| INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 32176,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 0),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 835,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 100),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 903,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 200),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1195,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 300),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1251,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 400),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1271,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 500),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1223,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 600),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1428,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 700),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1656,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 800),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1688,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 900),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1713,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 1000),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1800,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 1100),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1689,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 1200),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1737,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 1300),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1393,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 1400),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1388,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 1500),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1462,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 1600),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1578,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 1700),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1497,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 1800),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1614,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 1900),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1708,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 2000),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1622,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 2100),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1705,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 2200),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1644,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 2300),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1746,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 2400),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1759,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 2500),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1789,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 2600),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1858,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 2700),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1783,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 2800),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1642,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 2900),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1683,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 3000),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1719,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 3100),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1774,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 3200),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1806,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 3300),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1867,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 3400),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0);SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`values` (`idx`, `value`, `mset`, `parameter`) VALUES (NULL, 1781,0, NULL); SET @mvalue = (SELECT (LAST_INSERT_ID())); INSERT INTO `messdaten`.`coordinates` (`index`, `name`, `correspondingvalue`, `coordinate`) VALUES (NULL, 'x', @mvalue, 3500),(NULL, 'y', @mvalue, 0),(NULL, 'z', @mvalue, 28500),(NULL, 'p1', @mvalue, 0),(NULL, 'p2', @mvalue, 0),(NULL, 'px', @mvalue, 25600),(NULL, 'py', @mvalue, 25600),(NULL, 'pz', @mvalue, 0); |